{"id":1926,"date":"2023-10-27T23:44:57","date_gmt":"2023-10-27T23:44:57","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/"},"modified":"2023-12-06T06:19:38","modified_gmt":"2023-12-06T06:19:38","slug":"temukan-rentang-nama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/","title":{"rendered":"Bagaimana menemukan rentang nama di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2308820945\"><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, memberi nama rentang sel adalah cara termudah dan tercepat untuk merujuk ke sel tersebut dalam rumus. Anda bisa membuat beberapa rentang nama di lembar kerja dan menggunakannya sebagai referensi sel saat menerapkan rumus.<\/p><p> Namun terkadang jika Anda memiliki beberapa rentang nama di buku kerja, mungkin sulit mengingat nama dan lokasi rentang nama tersebut.<\/p><p> Jadi, dalam tutorial ini, kami akan menunjukkan cara menemukan rentang nama di buku kerja saat ini.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Menemukan Rentang Nama Menggunakan Manajer Nama<\/h2><p> Metode terbaik yang direkomendasikan untuk menemukan semua rentang nama di seluruh buku kerja adalah dengan menggunakan &#8220;Manajer Nama&#8221;. Dari sini Anda juga dapat mengedit sel relatif dari rentang bernama apa pun dan mengubah nama rentang bernama dengan mengikuti langkah-langkah di bawah ini:<\/p><ol><li> Pertama, buka tab \u201cRumus\u201d, lalu klik ikon \u201cPengelola Nama\u201d di bawah grup \u201cNama Buatan\u201d.<\/li><li> Atau pertama-tama, tahan tombol \u201cCtrl\u201d lalu tekan tombol \u201cF3\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"-nama-manajer-ikon\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"name-manager-icon\" width=\"726\" height=\"132\"><\/li><li> Pada titik ini, kotak dialog \u201cManajer Nama\u201d akan terbuka.<\/li><li> Di dalamnya Anda akan menemukan semua rentang nama beserta namanya di bawah tab &#8220;Nama&#8221; dan lokasi (nama lembar) termasuk rentang sel yang ditetapkan padanya di bawah tab &#8220;Refer&#8221;&#8221;.<\/li><li> Dari sana, klik dua kali salah satu rentang nama yang ingin Anda edit atau navigasikan ke sel relatif untuk rentang nama tersebut. <br><img loading=\"lazy\" decoding=\"async\" title=\"-dialog-nama-manajer\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-du-gestionnaire-de-2-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"name-manager-dialog-box\" width=\"517\" height=\"405\"><\/li><li> Saat Anda mengklik dua kali pada rentang nama individual, kotak dialog untuk rentang nama tersebut akan terbuka seperti yang ditunjukkan pada gambar di bawah.<\/li><li> Sekarang, untuk mengubah nama rentang nama ini, buka kolom \u201cNama\u201d dan hapus nama yang ada dan tambahkan nama baru, lalu tekan OK.<\/li><li> Untuk mengakses sel yang direferensikan, klik sel terakhir dari referensi yang diberikan dan Anda akan dibawa ke sel yang direferensikan. <br><img loading=\"lazy\" decoding=\"async\" title=\"-edit dialog rentang nama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-boite-de-dialogue-de-modification-de-la-plage-de-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"edit-name-range-dialog-box\" width=\"299\" height=\"227\"><\/li><li> Dari sini Anda dapat memilih ulang rentang sel dan rentang tersebut akan diperbarui.<\/li><li> Anda dapat melihatnya di kolom \u201cRefers to\u201d di kotak dialog, lalu tekan OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pilih ulang rentang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-reselectionner-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"reselect-the-range\" width=\"446\" height=\"276\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Temukan rentang nama menggunakan opsi Go To<\/h2><ol><li> Pertama, masuk ke tab \u201cBeranda\u201d, lalu klik ikon \u201cTemukan dan Pilih\u201d, lalu klik opsi \u201cGOTO\u201d untuk membuka kotak dialog \u201cGOTO\u201d.<\/li><li> Atau cukup tekan pintasan keyboard \u201cCtrl + G\u201d dan itu akan membuka kotak dialog \u201cGOTO\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pergi ke opsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-aller-a-loption.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-option\" width=\"653\" height=\"277\"><\/li><li> Di sini, di kotak dialog &#8220;GOTO&#8221; Anda akan menemukan semua rentang nama di buku kerja Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pergi ke kotak dialog\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-aller-a-la-boite-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-dialog-box\" width=\"329\" height=\"270\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Temukan rentang nama dengan memperkecil<\/h2><p> Untuk menemukan rentang nama di lembar kerja saat ini, cukup perkecil lembar kerja hingga 30% dan Anda akan menemukan nama rentang nama yang disorot di sel relatifnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82876\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-dezoomer.png\" sizes=\"auto, \" srcset=\"\" alt=\"Perkecil\" width=\"424\" height=\"83\"><\/figure><\/div><p> Pada gambar di bawah, lembar kerja diperbesar hingga 30% dan Anda dapat melihat bahwa kami memiliki dua rentang nama terpisah yang ditentukan dalam lembar kerja saat ini di mana nama-nama tersebut disorot. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82877\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-plages-de-noms-en-surbrillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang nama yang disorot\" width=\"472\" height=\"253\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Temukan rentang nama dari kotak nama<\/h2><p> Anda juga dapat menemukan rentang nama di &#8220;kotak nama&#8221; di kiri atas spreadsheet dan untuk menavigasi ke sel yang relevan dalam rentang nama, cukup klik sel tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82878\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-a-9-noms.png\" sizes=\"auto, \" srcset=\"\" alt=\"nama kotak\" width=\"223\" height=\"393\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\">Terapkan beberapa filter ke kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data di Excel<\/a><\/li><\/ul><\/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-1926","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 menemukan rentang nama di Excel?<\/title>\n<meta name=\"description\" content=\"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\" \/>\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\/temukan-rentang-nama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana menemukan rentang nama di Excel?\" \/>\n<meta property=\"og:description\" content=\"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.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\/temukan-rentang-nama\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/\",\"name\":\"Bagaimana menemukan rentang nama di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png\",\"datePublished\":\"2023-10-27T23:44:57+00:00\",\"dateModified\":\"2023-12-06T06:19:38+00:00\",\"description\":\"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana menemukan rentang nama 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 menemukan rentang nama di Excel?","description":"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","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\/temukan-rentang-nama\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana menemukan rentang nama di Excel?","og_description":"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.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\/temukan-rentang-nama\/","url":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/","name":"Bagaimana menemukan rentang nama di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png","datePublished":"2023-10-27T23:44:57+00:00","dateModified":"2023-12-06T06:19:38+00:00","description":"Panduan singkat ini akan membantu Anda menemukan rentang bernama di Excel. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-de-gestionnaire-de-noms.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/temukan-rentang-nama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana menemukan rentang nama 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\/1926","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=1926"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1926\/revisions"}],"predecessor-version":[{"id":2869,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1926\/revisions\/2869"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}