{"id":4736,"date":"2023-07-08T11:19:13","date_gmt":"2023-07-08T11:19:13","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/"},"modified":"2023-07-08T11:19:13","modified_gmt":"2023-07-08T11:19:13","slug":"tabel-mengambang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/","title":{"rendered":"Cara membuat tabel mengambang di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Tabel mengambang<\/strong> di Excel adalah jenis tabel yang bisa Anda pindahkan di sekitar lembar kerja hanya dengan menyeretnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara termudah untuk membuat tabel mengambang di Excel adalah dengan menggunakan <strong>alat Kamera<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan dataset berikut ke dalam Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36979 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata1.png\" alt=\"\" width=\"453\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengonversi rentang ini menjadi tabel, sorot rentang sel <strong>A1:C10<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Tabel<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36980 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata2.png\" alt=\"\" width=\"548\" height=\"139\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rentang tersebut akan dikonversi menjadi array:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36981 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata3.png\" alt=\"\" width=\"434\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan Alat Kamera ke Bilah Alat Akses Cepat<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menambahkan <strong>alat Kamera<\/strong> ke Quick Access Toolbar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik panah drop-down kecil di bagian atas buku kerja, lalu klik <strong>Pesanan Lainnya<\/strong> di menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36982 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata4.png\" alt=\"\" width=\"417\" height=\"542\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Quick Access Toolbar<\/strong> di menu samping, lalu klik <strong>Commands Not on Ribbon<\/strong> di menu drop-down, lalu gulir ke bawah hingga Anda melihat <strong>Camera<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik pada <strong>Kamera<\/strong> lalu klik <strong>Tambah<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36983 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata5.png\" alt=\"\" width=\"672\" height=\"529\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , ikon kamera kecil akan ditambahkan ke Quick Access Toolbar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36984 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata6.png\" alt=\"\" width=\"477\" height=\"153\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Gunakan Alat Kamera untuk Membuat Tabel Mengambang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A1:C10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Kamera<\/strong> di Quick Access Toolbar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik sel mana pun di lembar kerja dan tabel mengambang akan otomatis disisipkan di sana.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kita akan mengklik sel <strong>E2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36985 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata7.png\" alt=\"\" width=\"626\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa tabel mengambang telah dibuat. Sekarang kita dapat mengklik dan menyeret tabel mengambang ini ke lokasi mana pun yang kita inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa jika kita mengubah salah satu nilai di tabel asli, nilai di tabel mengambang akan diperbarui secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya kita mengubah nilai pada kolom poin untuk Warriors menjadi 50:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36986 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata8.png\" alt=\"\" width=\"590\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai tabel mengambang juga berubah agar sesuai dengan nilai tabel asli.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan dua tabel di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-penghapusan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus tabel di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengurutkan-tabel-pivot-berdasarkan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan tabel pivot berdasarkan beberapa kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tabel mengambang di Excel adalah jenis tabel yang bisa Anda pindahkan di sekitar lembar kerja hanya dengan menyeretnya. Cara termudah untuk membuat tabel mengambang di Excel adalah dengan menggunakan alat Kamera . Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Buat tabel Pertama, masukkan dataset berikut ke dalam Excel yang berisi [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Tabel Mengambang di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel mengambang 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\/tabel-mengambang-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 Mengambang di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel mengambang di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T11:19:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata1.png\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/\",\"name\":\"Cara Membuat Tabel Mengambang di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T11:19:13+00:00\",\"dateModified\":\"2023-07-08T11:19:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel mengambang di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tabel mengambang 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 Mengambang di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat tabel mengambang 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\/tabel-mengambang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Tabel Mengambang di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat tabel mengambang di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T11:19:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/","url":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/","name":"Cara Membuat Tabel Mengambang di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T11:19:13+00:00","dateModified":"2023-07-08T11:19:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel mengambang di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-mengambang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tabel mengambang 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\/4736"}],"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=4736"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4736\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}