{"id":1805,"date":"2023-11-03T19:45:13","date_gmt":"2023-11-03T19:45:13","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menyegarkan\/"},"modified":"2023-12-06T06:14:57","modified_gmt":"2023-12-06T06:14:57","slug":"menyegarkan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menyegarkan\/","title":{"rendered":"Bagaimana cara memperbarui spreadsheet di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1694324371\"><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, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu menyegarkannya secara manual karena, secara default, opsi pembaruan &#8220;Otomatis&#8221; dipilih. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92708\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\" sizes=\"auto, \" srcset=\"\" alt=\"menyegarkan sehelai daun\" width=\"437\" height=\"315\"><\/figure><\/div><p> Namun ada beberapa cara yang dapat Anda gunakan untuk menyegarkan sheet secara manual, dan dalam tutorial ini kita akan mempelajari metode tersebut. Pada contoh di bawah, kami menggunakan fungsi RAND, yang mengubah nilainya saat Anda me-refresh sheet. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92709\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-la-fonction-change-de-valeur-lorsque-la-feuille-est-actualisee-a-chaque-fois.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi-berubah-nilai-saat-lembar-disegarkan-setiap saat\" width=\"486\" height=\"293\"><\/figure><\/div><h2 id=\"h-using-the-keyboard-shortcut\" class=\"wp-block-heading\"> Menggunakan pintasan keyboard<\/h2><p> Anda dapat menggunakan Shift+F9 (atau Shift+Fn+F9) untuk menyegarkan lembar secara instan. Ini cepat dan Anda menggunakannya berkali-kali jika perlu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92710\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourcis-clavier-pour-referencer.png\" sizes=\"auto, \" srcset=\"\" alt=\"hotkey-untuk-referensi\" width=\"292\" height=\"94\"><\/figure><\/div><p> Anda juga bisa menggunakan tombol F9, yang akan menghitung seluruh buku kerja, bukan lembar aktif. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92711\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-f9-pour-calculer-le-classeur-entier.png\" sizes=\"auto, \" srcset=\"\" alt=\"f9-untuk-menghitung-seluruh buku kerja\" width=\"104\" height=\"100\"><\/figure><\/div><h2 id=\"h-using-the-calculate-sheet-option\" class=\"wp-block-heading\"> Menggunakan opsi Hitung Lembar<\/h2><ol type=\"1\"><li> Navigasikan ke lembar yang ingin Anda segarkan.<\/li><li> Buka tab Rumus.<\/li><li> Buka grup Opsi perhitungan.<\/li><li> Klik pada opsi &#8220;Hitung Lembar&#8221;. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92712\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-option-de-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi lembar perhitungan\" width=\"660\" height=\"313\"><\/figure><\/div><p> Saat Anda mengklik opsi tersebut, lembar aktif akan disegarkan dan semua rumus Anda dihitung ulang.<\/p><h2 id=\"h-using-a-vba-code-to-refresh-a-sheet\" class=\"wp-block-heading\"> Gunakan kode VBA untuk menyegarkan lembar<\/h2><p> Ya, Anda dapat menggunakan untuk menyegarkan spreadsheet. Yang harus Anda lakukan adalah membuka editor Visual Basic, memasukkan modul baru, lalu menempelkan kode di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> Macro1() ActiveSheet.Calculate <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Dan setelah Anda menempelkannya, Anda dapat menjalankan kode untuk menyegarkan spreadsheet hanya dengan satu klik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92713\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-vba-pour-consulter-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-untuk-menyegarkan-lembar\" width=\"688\" height=\"256\"><\/figure><\/div><p> Kode yang kita miliki di atas menyegarkan lembar aktif. Namun jika Anda ingin me-refresh sheet tertentu, Anda dapat menulis kode seperti di bawah ini:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub <strong>Macro1<\/strong> () <strong>Sheets<\/strong> (\"Sheet1\").Calculate End Sub<\/code><\/pre><p> Sekarang kode di atas baru saja me-refresh &#8220;Sheet1&#8221;; jika anda ingin mengganti nama anda bisa mengubahnya langsung dari kodenya sendiri. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/feuille-de-rafraichissement.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/div><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\/mengkonsolidasikan\/\">Konsolidasikan data dari beberapa spreadsheet<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\">Ganti nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/grup-1\/\">Kelompokkan Lembar Kerja di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\">Lihat dua lembar berdampingan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan\/\">Tambahkan spreadsheet 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-1805","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 cepat menyegarkan spreadsheet di Excel?<\/title>\n<meta name=\"description\" content=\"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena\" \/>\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\/menyegarkan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara cepat menyegarkan spreadsheet di Excel?\" \/>\n<meta property=\"og:description\" content=\"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menyegarkan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/\",\"name\":\"Bagaimana cara cepat menyegarkan spreadsheet di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\",\"datePublished\":\"2023-11-03T19:45:13+00:00\",\"dateModified\":\"2023-12-06T06:14:57+00:00\",\"description\":\"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menyegarkan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbarui spreadsheet 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 cepat menyegarkan spreadsheet di Excel?","description":"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena","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\/menyegarkan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara cepat menyegarkan spreadsheet di Excel?","og_description":"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena","og_url":"https:\/\/exceladvisor.org\/id\/menyegarkan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:57+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/","url":"https:\/\/exceladvisor.org\/id\/menyegarkan\/","name":"Bagaimana cara cepat menyegarkan spreadsheet di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","datePublished":"2023-11-03T19:45:13+00:00","dateModified":"2023-12-06T06:14:57+00:00","description":"Di Excel, Anda bisa menyegarkan spreadsheet secara manual. Anda biasanya tidak perlu me-refresh secara manual karena","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menyegarkan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbarui spreadsheet 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\/1805","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=1805"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1805\/revisions"}],"predecessor-version":[{"id":2382,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1805\/revisions\/2382"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}