{"id":5389,"date":"2023-09-06T11:17:13","date_gmt":"2023-09-06T11:17:13","guid":{"rendered":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/"},"modified":"2023-09-06T11:17:13","modified_gmt":"2023-09-06T11:17:13","slug":"trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini","status":"publish","type":"post","link":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/","title":{"rendered":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini"},"content":{"rendered":"

<\/p>\n

  <\/p>\n

PIKIRANACEH.COM | NEWS – <\/strong> Trik yang bisa Anda terapkan agar pekerjaan Anda di Ms Excel berjalan lancar. Deretan tips dan trik ini diharapkan bisa membantu aktivitas Anda sehingga lebih cepat tuntas.<\/p>\n

Ada sejumlah pekerjaan berkaitan dengan data yang harus dikerjakan dengan Microsoft Excel. Apabila Anda tidak mengetahui trik tersembunyinya, pekerjaan Anda diprediksi akan terhambat sehingga selesai lebih lambat.<\/p>\n

5 trik tersembunyi Ms Excel<\/h2>\n
    \n
  1. \n

    Hapus Sel Kosong dengan Cepat<\/h2>\n

    Jika Anda perlu menghapus sel kosong terutama saat menghitung nilai rata-rata, cara cepatnya adalah dengan memfilter semua sel dan menghapusnya dengan satu klik. Pilih kolom yang ingin Anda filter, buka Data -> Filter, setelah tombol ke bawah muncul, batalkan Pilih Semua lalu ambil opsi terakhir, Kosong. Semua sel akan segera kosong. Kembali ke Beranda dan langsung klik Hapus, semuanya akan dihapus.<\/p>\n<\/li>\n

  2. \n

    Pembatasan Input dengan Fungsi Validasi Data<\/h2>\n

    Untuk menjaga validitas data, terkadang Anda perlu membatasi nilai input dan menawarkan beberapa tips untuk langkah selanjutnya. Misalnya, usia dalam lembar ini harus berupa bilangan bulat dan semua orang yang berpartisipasi dalam survei ini harus berusia antara 18 dan 60 tahun. Untuk memastikan bahwa data di luar rentang usia ini tidak dimasukkan, buka Data -> Data Validation -> Setting, masukkan kondisi dan geser ke Input Message untuk memberikan perintah sesuai keinginan Anda.<\/li>\n

  3. \n

    Navigasi Cepat dengan Tombol Ctrl + Panah<\/h2>\n

    Baca Juga: Cara Ubah File MS Word jadi PDF tanpa Internet, Praktis 4 Kali Klik!<\/strong> <\/p>\n

     <\/p>\n

    Saat Anda mengeklik Ctrl + tombol panah apa pun di keyboard, Anda dapat melompat ke tepi lembar ke arah yang berbeda. Kalau mau lompat ke baris terbawah, caranya yakni klik Ctrl + tombol bawah.<\/p>\n<\/li>\n

  4. \n

    Ubah Urutan Data dari Baris ke Kolom<\/h2>\n

    Anda bisa menggunakan fitur ini jika ingin mengubah urutan data demi mendapatkan tampilan yang lebih baik tanpa perlu mengetik ulang. Caranya cukup dengan menggunakan fungsi Transpose di Paste. Caranya: copy area yang ingin ditranspose, pindahkan pointer ke lokasi kosong. Buka Beranda -> Paste -> Transpose, harap dicatat bahwa fungsi ini tidak akan aktif sampai Anda menyalin data terlebih dahulu.<\/li>\n

  5. \n

    Sembunyikan Data Secara Menyeluruh<\/h2>\n

    Cara terbaik dan termudah adalah dengan menggunakan fungsi Format Cell. Pilih area dan buka Beranda -> Font -> Buka Format Cell -> Tab Nomor -> Kustom -> Jenis ;;; -> Klik OK, maka semua nilai di area tersebut tidak akan terlihat, dan hanya dapat ditemukan di area pratinjau di sebelah tombol Function.***<\/li>\n<\/ol>\n

     <\/p>\n

     <\/div>\n","protected":false},"excerpt":{"rendered":"

      PIKIRANACEH.COM | NEWS –  Trik yang bisa Anda terapkan…<\/p>\n","protected":false},"author":1,"featured_media":5390,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4464,4463],"newstopic":[],"class_list":["post-5389","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-politik","tag-excel","tag-trik"],"yoast_head":"\nTrik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH\" \/>\n<meta property=\"og:description\" content=\"  PIKIRANACEH.COM | NEWS –  Trik yang bisa Anda terapkan...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\" \/>\n<meta property=\"og:site_name\" content=\"PIKIRAN ACEH\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-06T11:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"pikiranaceh2025\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"pikiranaceh2025\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\"},\"author\":{\"name\":\"pikiranaceh2025\",\"@id\":\"https:\/\/pikiranaceh.com\/#\/schema\/person\/8998c46edc92c9412ea8ddb0cc9461c1\"},\"headline\":\"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini\",\"datePublished\":\"2023-09-06T11:17:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\"},\"wordCount\":421,\"publisher\":{\"@id\":\"https:\/\/pikiranaceh.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg\",\"keywords\":[\"Excel\",\"trik\"],\"articleSection\":[\"Politik\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\",\"url\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\",\"name\":\"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH\",\"isPartOf\":{\"@id\":\"https:\/\/pikiranaceh.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg\",\"datePublished\":\"2023-09-06T11:17:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage\",\"url\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg\",\"contentUrl\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg\",\"width\":750,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pikiranaceh.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pikiranaceh.com\/#website\",\"url\":\"https:\/\/pikiranaceh.com\/\",\"name\":\"PIKIRAN ACEH\",\"description\":\"BERITA ACEH HARI INI\",\"publisher\":{\"@id\":\"https:\/\/pikiranaceh.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pikiranaceh.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/pikiranaceh.com\/#organization\",\"name\":\"PIKIRAN ACEH\",\"url\":\"https:\/\/pikiranaceh.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/pikiranaceh.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/WhatsApp-Image-2025-10-22-at-16.32.07.jpeg\",\"contentUrl\":\"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/WhatsApp-Image-2025-10-22-at-16.32.07.jpeg\",\"width\":1080,\"height\":902,\"caption\":\"PIKIRAN ACEH\"},\"image\":{\"@id\":\"https:\/\/pikiranaceh.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/pikiranaceh.com\/#\/schema\/person\/8998c46edc92c9412ea8ddb0cc9461c1\",\"name\":\"pikiranaceh2025\",\"sameAs\":[\"http:\/\/pikiranaceh.com\"],\"url\":\"https:\/\/pikiranaceh.com\/index.php\/author\/pikiranaceh2025\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/","og_locale":"en_US","og_type":"article","og_title":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH","og_description":"  PIKIRANACEH.COM | NEWS –  Trik yang bisa Anda terapkan...","og_url":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/","og_site_name":"PIKIRAN ACEH","article_published_time":"2023-09-06T11:17:13+00:00","og_image":[{"width":750,"height":500,"url":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg","type":"image\/jpeg"}],"author":"pikiranaceh2025","twitter_card":"summary_large_image","twitter_misc":{"Written by":"pikiranaceh2025","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#article","isPartOf":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/"},"author":{"name":"pikiranaceh2025","@id":"https:\/\/pikiranaceh.com\/#\/schema\/person\/8998c46edc92c9412ea8ddb0cc9461c1"},"headline":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini","datePublished":"2023-09-06T11:17:13+00:00","mainEntityOfPage":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/"},"wordCount":421,"publisher":{"@id":"https:\/\/pikiranaceh.com\/#organization"},"image":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage"},"thumbnailUrl":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg","keywords":["Excel","trik"],"articleSection":["Politik"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/","url":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/","name":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini - PIKIRAN ACEH","isPartOf":{"@id":"https:\/\/pikiranaceh.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage"},"image":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage"},"thumbnailUrl":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg","datePublished":"2023-09-06T11:17:13+00:00","breadcrumb":{"@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#primaryimage","url":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg","contentUrl":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/3306799054.jpg","width":750,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/pikiranaceh.com\/index.php\/2023\/09\/06\/trik-ms-excel-lancar-dan-cepat-wajib-tahu-5-langkah-ini\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pikiranaceh.com\/"},{"@type":"ListItem","position":2,"name":"Trik Ms Excel Lancar dan Cepat Wajib Tahu 5 Langkah Ini"}]},{"@type":"WebSite","@id":"https:\/\/pikiranaceh.com\/#website","url":"https:\/\/pikiranaceh.com\/","name":"PIKIRAN ACEH","description":"BERITA ACEH HARI INI","publisher":{"@id":"https:\/\/pikiranaceh.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pikiranaceh.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pikiranaceh.com\/#organization","name":"PIKIRAN ACEH","url":"https:\/\/pikiranaceh.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pikiranaceh.com\/#\/schema\/logo\/image\/","url":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/WhatsApp-Image-2025-10-22-at-16.32.07.jpeg","contentUrl":"https:\/\/pikiranaceh.com\/wp-content\/uploads\/2025\/10\/WhatsApp-Image-2025-10-22-at-16.32.07.jpeg","width":1080,"height":902,"caption":"PIKIRAN ACEH"},"image":{"@id":"https:\/\/pikiranaceh.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pikiranaceh.com\/#\/schema\/person\/8998c46edc92c9412ea8ddb0cc9461c1","name":"pikiranaceh2025","sameAs":["http:\/\/pikiranaceh.com"],"url":"https:\/\/pikiranaceh.com\/index.php\/author\/pikiranaceh2025\/"}]}},"_links":{"self":[{"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/posts\/5389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/comments?post=5389"}],"version-history":[{"count":0,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/posts\/5389\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/media\/5390"}],"wp:attachment":[{"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/media?parent=5389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/categories?post=5389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/tags?post=5389"},{"taxonomy":"newstopic","embeddable":true,"href":"https:\/\/pikiranaceh.com\/index.php\/wp-json\/wp\/v2\/newstopic?post=5389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}