{"id":1831,"date":"2023-10-31T23:04:24","date_gmt":"2023-10-31T23:04:24","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/ganti-nama\/"},"modified":"2023-12-06T06:16:21","modified_gmt":"2023-12-06T06:16:21","slug":"ganti-nama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/ganti-nama\/","title":{"rendered":"Bagaimana cara mengganti nama lembar di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2865800030\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel ada beberapa cara untuk mengganti nama sheet dan dalam tutorial ini kita akan mempelajari semua metode tersebut.<\/p><h2 id=\"h-rename-a-sheet-from-option-menu\" class=\"wp-block-heading\"> Ganti nama sheet dari menu opsi<\/h2><p> Metode default untuk mengganti nama sheet adalah dengan menggunakan menu opsi klik kanan. Lihat langkah-langkahnya di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png\" sizes=\"auto, \" srcset=\"\" alt=\"ganti nama-lembar-dari-menu-opsi\" width=\"347\" height=\"407\"><\/figure><\/div><ol type=\"1\"><li> Pertama, aktifkan sheet yang ingin Anda ganti namanya.<\/li><li> Selanjutnya, klik kanan pada tab lembar.<\/li><li> Setelah itu, klik opsi \u201cGanti Nama\u201d dari daftar opsi.<\/li><li> Sekarang hapus nama lama dan ketikkan nama baru yang ingin Anda perbaiki.<\/li><li> Pada akhirnya, tekan Enter.<\/li><\/ol><h2 id=\"h-keyboard-shortcut-to-rename-a-sheet\" class=\"wp-block-heading\"> Pintasan keyboard untuk mengganti nama sheet<\/h2><p> Ada juga pintasan keyboard yang bisa Anda gunakan untuk mengganti nama lembar di Excel. Untuk menggunakan pintasan keyboard ini, Anda harus terlebih dahulu mengaktifkan lembar yang ingin Anda ganti namanya dan setelah itu tekan tombol berikut:<\/p><p> <kbd>Alt \u21e2 H \u21e2 O \u21e2 R<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61148\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-pour-renommer-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan keyboard-untuk-mengganti nama-lembar\" width=\"903\" height=\"210\"><\/figure><\/div><p> Saat Anda menekan tombol pintas ini, nama lembar diubah. Anda kemudian dapat mengetikkan nama baru yang ingin Anda tentukan dan tekan Enter.<\/p><h2 id=\"h-double-click-of-rename-a-sheet\" class=\"wp-block-heading\"> Klik dua kali untuk mengganti nama sheet<\/h2><p> Anda juga dapat menggunakan klik dua kali mouse untuk mengedit nama sheet dan kemudian mengganti namanya nanti.<\/p><ol type=\"1\"><li> Pertama, aktifkan sheet yang ingin Anda ganti namanya.<\/li><li> Klik dua kali tab lembar untuk mengeditnya.<\/li><li> Hapus nama lama yang sudah Anda miliki di sana.<\/li><li> Ketik nama baru lalu tekan Enter.<\/li><\/ol><h2 id=\"h-using-the-format-options\" class=\"wp-block-heading\"> Menggunakan opsi format<\/h2><p> Demikian pula, Anda bisa mengganti nama lembar kerja menggunakan opsi format pada pita. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61149\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-renommer-la-feuille-en-utilisant-loption-de-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"ganti nama-lembar-menggunakan-format-opsi\" width=\"272\" height=\"434\"><\/figure><\/div><ol><li> Pertama, buka tab Beranda dan temukan daftar drop-down opsi format.<\/li><li> Selanjutnya, klik menu drop-down untuk mendapatkan daftar opsi.<\/li><li> Setelah itu, klik opsi \u201cRename Sheet\u201d untuk mengubah nama sheet.<\/li><li> Pada akhirnya, masukkan nama baru dan tekan Enter.<\/li><\/ol><p> Seperti semua metode lainnya, Anda harus mengaktifkan sheet terlebih dahulu untuk menggunakan metode ini.<\/p><p class=\"mytip\"> Anda juga dapat menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama-lembar\/\">VBA untuk mengganti nama sheet<\/a> .<\/p><h2 id=\"h-rules-you-need-to-know-naming-a-sheet\" class=\"wp-block-heading\"> Aturan yang perlu Anda ketahui (beri nama sheetnya)<\/h2><p> Ada beberapa aturan yang perlu diingat saat mengganti nama sheet.<\/p><ol type=\"1\"><li> Anda dapat memberi nama pada dua lembar berbeda dengan nama yang sama.<\/li><li> Nama sheet tidak boleh berupa nilai kosong.<\/li><li> Maksimum 31 karakter dapat digunakan dalam satu nama sheet.<\/li><li> Tanda kutip (&#8216;) tidak dapat digunakan di awal dan akhir nama, tetapi dapat digunakan di tengah-tengah.<\/li><li> Beberapa karakter tidak dapat digunakan pada nama, seperti [ ] \\ \/? :*<\/li><li> Anda tidak dapat menggunakan kata &#8220;Riwayat&#8221; sebagai nama lembar, yang dicadangkan oleh Excel. <\/li><\/ol><div class=\"gb-container gb-container-3044ba66 gb-container-mt\"><p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja\/\" data-wpil=\"url\">Lembar Bentang Excel<\/a><\/strong><\/p><h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> Tutorial lainnya <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-7495e031\"><div class=\"gb-container gb-container-7495e031\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan\/\">Tambahkan spreadsheet di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-warna-tab\/\">Ubah Warna Tab di Excel (Tab Lembar Kerja)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-judul\/\">Tambahkan judul ke lembar kerja di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/salinan-1\/\">Menyalin atau memindahkan lembar (spreadsheet)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-semua-1\/\">Pilih semua lembar kerja (sheet)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-530ab33a\"><div class=\"gb-container gb-container-530ab33a\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1831","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\",\"name\":\"Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png\",\"datePublished\":\"2023-10-31T23:04:24+00:00\",\"dateModified\":\"2023-12-06T06:16:21+00:00\",\"description\":\"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ganti-nama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengganti nama lembar di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)","description":"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)","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:\/\/exceladvisor.org\/id\/ganti-nama\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)","og_description":"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)","og_url":"https:\/\/exceladvisor.org\/id\/ganti-nama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/","url":"https:\/\/exceladvisor.org\/id\/ganti-nama\/","name":"Bagaimana cara mengganti nama lembar di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png","datePublished":"2023-10-31T23:04:24+00:00","dateModified":"2023-12-06T06:16:21+00:00","description":"Di sini kita akan mempelajari berbagai cara untuk mengganti nama sheet di Excel (pintasan keyboard, klik mouse, klik kanan, dll.)","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/ganti-nama\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-renommer-la-feuille-a-partir-du-menu-doptions.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/ganti-nama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengganti nama lembar di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1831"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1831\/revisions"}],"predecessor-version":[{"id":2522,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1831\/revisions\/2522"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}