{"id":1874,"date":"2023-10-30T11:53:34","date_gmt":"2023-10-30T11:53:34","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/"},"modified":"2023-12-06T06:18:29","modified_gmt":"2023-12-06T06:18:29","slug":"jendela-arloji","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/","title":{"rendered":"Bagaimana cara menggunakan jendela tontonan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4218287546\"><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>Seringkali ada sel di spreadsheet kita yang berisi rumus-rumus penting. Dan rumus ini membantu kita menghitung beberapa nilai penting. Dalam situasi ini, sangat penting untuk memantau sel-sel ini apakah perhitungannya benar atau tidak ada kesalahan.<\/p><p> Namun faktanya adalah, semakin banyak jenis sel yang Anda miliki, semakin banyak usaha dan waktu yang harus Anda curahkan untuk melacaknya. Di Excel, ada opsi bernama Watch Window yang diperkenalkan oleh Microsoft pada versi 2013 dan ini bisa menjadi alat bisnis Anda setelah Anda mengetahui betapa bergunanya.<\/p><p> Pada artikel ini, Anda akan mempelajari cara melacak sel penting Anda dengan jendela arloji di Excel. Ini adalah salah satu <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/nasihat\/\" data-wpil=\"url\">trik Excel<\/a> yang dapat membantu meningkatkan <a href=\"https:\/\/exceladvisor.org\/id\/keterampilan-unggul\/\">keterampilan dasar Excel<\/a> .<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Di mana menemukannya di pita?<\/h2><p> <strong>Buka tab Formula \u2192 Audit Formula \u2192 Jendela pemantauan.<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png\" sizes=\"\" srcset=\"\" alt=\"cara menemukan jendela arloji di pita excel\"><\/figure><\/div><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Tombol pintas<\/h2><p> Anda juga dapat menggunakan Alt + M + W untuk membuka jendela Watch.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Tambahkan sel ke jendela pemantauan<\/h2><ul><li> Klik Tambahkan Tontonan.<\/li><li> Tambahkan alamat sel ke kotak input.<\/li><li> Klik Oke. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ajouter-une-cellule-pour-utiliser-la-fenetre-de-surveillance-dans-Excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"tambahkan sel di jendela pemantauan untuk pemantauan\"><\/figure><\/div><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Memantau sel-sel penting dengan jendela pemantauan<\/h2><p> Kami dapat memeriksa dan mengaudit komponen berikut dengan jendela pemantauan.<\/p><ol><li> <strong>Nama Buku Kerja<\/strong> : Saat Anda menambahkan sel ke jam tangan, sel tersebut akan mengambil nama buku kerja.<\/li><li> <strong>Nama Lembar Kerja<\/strong> : Nama lembar kerja juga akan diambil bersama dengan nama buku kerja. Saat Anda memiliki banyak lembar kerja di buku kerja Anda, mudah untuk mengidentifikasi sel dengan nama lembar kerja.<\/li><li> <strong>Nama<\/strong> : Ini juga akan menangkap nama rentang sel jika Anda menentukannya.<\/li><li> <strong>Alamat Sel<\/strong> : Ini akan menampilkan alamat sel.<\/li><li> <strong>Nilai Sel<\/strong> : Anda memiliki nilai sel di jendela pemantauan. Ini adalah nilai yang mudah berubah yang dapat berubah ketika nilai sebenarnya dari sel berubah. Ini memudahkan untuk mengaudit nilai-nilai di dalam sel.<\/li><li> <strong>Rumus<\/strong> : Jika sel yang ditambahkan memiliki rumus, Anda akan mendapatkannya di jendela arloji Anda. Hal ini membuat mereka lebih mudah untuk diperiksa dan diaudit.<\/li><\/ol><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> Hapus sel dari<\/h2><ol><li> Pilih sel yang ingin Anda hapus.<\/li><li> Klik tombol Hapus atau ketuk Hapus. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Supprimer-une-cellule-pour-utiliser-la-fenetre-de-surveillance-dans-Excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"menghapus sel dari jendela pemantauan\"><\/figure><\/div><p> Untuk menghapus lebih dari satu sel, gunakan tombol Shift+panah atau Anda juga dapat menggunakan tombol Shift+end untuk memilih semua sel yang akan dihapus.<\/p><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> Memperbaiki Jendela Pengawasan di bawah Pita Excel Anda<\/h2><p> Anda juga bisa memasangnya di bawah pita Anda. Untuk melakukan ini, cukup klik dua kali pada bilah judul jendela pemantauan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Correction-de-la-fenetre-de-surveillance-dans-Excel-sous-le-ruban-1.png\" sizes=\"\" srcset=\"\" alt=\"perbaiki jendela arloji di bawah kaset\"><\/figure><\/div><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> Poin penting<\/h2><ol><li> Anda dapat menambahkan sel sebanyak mungkin untuk memantaunya, namun menggunakan terlalu banyak sel akan memperlambat buku kerja Anda.<\/li><li> Klik dua kali entri sel untuk memilihnya.<\/li><li> Anda hanya bisa melacak sel di buku kerja jika buku kerja itu terbuka.<\/li><\/ol><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-kamera\/\">Alat Kamera Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-tujuan\/\">Pencari Sasaran di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pemotong-excel\/\">Pemotong Excel (Panduan Lengkap)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/excel-secara-default-di-mac\/\">Jadikan Excel Default di Mac<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mode-aman-excel\/\">Buka Excel dalam Mode Aman<\/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-1874","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 menggunakan Jendela Tontonan di Excel?<\/title>\n<meta name=\"description\" content=\"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.\" \/>\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\/jendela-arloji\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan Jendela Tontonan di Excel?\" \/>\n<meta property=\"og:description\" content=\"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.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\/jendela-arloji\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\",\"name\":\"Bagaimana cara menggunakan Jendela Tontonan di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png\",\"datePublished\":\"2023-10-30T11:53:34+00:00\",\"dateModified\":\"2023-12-06T06:18:29+00:00\",\"description\":\"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan jendela tontonan 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 menggunakan Jendela Tontonan di Excel?","description":"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.","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\/jendela-arloji\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan Jendela Tontonan di Excel?","og_description":"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.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\/jendela-arloji\/","url":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/","name":"Bagaimana cara menggunakan Jendela Tontonan di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png","datePublished":"2023-10-30T11:53:34+00:00","dateModified":"2023-12-06T06:18:29+00:00","description":"Jika penting untuk mengawasi semua sel penting, Anda bisa menggunakan Watch Window di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jendela-arloji\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fenetre-de-surveillance-dans-Excel-1-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jendela-arloji\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan jendela tontonan 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\/1874","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=1874"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1874\/revisions"}],"predecessor-version":[{"id":2730,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1874\/revisions\/2730"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}