{"id":2749,"date":"2023-07-20T21:28:06","date_gmt":"2023-07-20T21:28:06","guid":{"rendered":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/"},"modified":"2023-07-20T21:28:06","modified_gmt":"2023-07-20T21:28:06","slug":"membuat-tabel-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/","title":{"rendered":"Cara membuat tabel di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut ini memperlihatkan cara membuat dan memformat tabel di Excel.<\/span><\/p>\n

Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n

Pertama, mari masukkan data berikut tentang berbagai tim bola basket:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Buat tabel<\/strong><\/span><\/h3>\n

Untuk mengubah data ini menjadi tabel, pertama-tama sorot semua sel dalam rentang A1:C11<\/strong> .<\/span><\/p>\n

Lalu klik tab Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon Tabel<\/strong> :<\/span> <\/p>\n

\"membuat<\/p>\n

Di jendela baru yang muncul, verifikasi bahwa rentang tabel sudah benar dan centang kotak di samping Tabel saya memiliki header<\/strong> , lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Tabel berikut akan dibuat secara otomatis:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Format tabelnya<\/strong><\/span><\/h3>\n

Untuk mengubah tampilan tabel, cukup klik nilai mana saja di tabel. Kemudian klik pada tab Desain Tabel<\/strong> di sepanjang pita atas.<\/span><\/p>\n

Ini akan memberi Anda berbagai pilihan untuk mengubah tampilan tabel.<\/span><\/p>\n

Sebagai contoh, kita akan menghapus centang pada kotak di sebelah tombol Filter<\/strong> untuk menghapus panah drop-down di header tabel dan memilih gaya tabel berwarna kuning:<\/span> <\/p>\n

\"\"<\/p>\n

Gaya tabel kami akan diperbarui secara otomatis:<\/span> <\/p>\n

\"\"<\/p>\n

Jangan ragu untuk bermain-main dengan pilihan desain di tab Desain Tabel<\/strong> untuk membuat tabel tampak sesuai keinginan Anda.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n

Cara Membuat Tabel Kontingensi di Excel<\/a>
Cara mengelompokkan berdasarkan bulan dan tahun dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Contoh langkah demi langkah berikut ini memperlihatkan cara membuat dan memformat tabel di Excel. Langkah 1: Masukkan datanya Pertama, mari masukkan data berikut tentang berbagai tim bola basket: Langkah 2: Buat tabel Untuk mengubah data ini menjadi tabel, pertama-tama sorot semua sel dalam rentang A1:C11 . Lalu klik tab Sisipkan di sepanjang pita atas, lalu […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara Membuat Tabel di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Tabel di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T21:28:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau11.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\",\"name\":\"Cara Membuat Tabel di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T21:28:06+00:00\",\"dateModified\":\"2023-07-20T21:28:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tabel di excel (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Tabel di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.","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:\/\/statorials.org\/id\/membuat-tabel-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Tabel di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T21:28:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau11.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/","url":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/","name":"Cara Membuat Tabel di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T21:28:06+00:00","dateModified":"2023-07-20T21:28:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tabel di excel (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2749"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2749"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2749\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}