{"id":1867,"date":"2023-10-30T15:22:45","date_gmt":"2023-10-30T15:22:45","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/"},"modified":"2023-12-06T06:15:55","modified_gmt":"2023-12-06T06:15:55","slug":"mengatur-area-cetak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/","title":{"rendered":"Bagaimana cara mengatur area cetak di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2132028129\"><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, area cetak adalah rentang sel yang hanya boleh dicetak dari lembar kerja.<\/p><p> Di Excel, pengguna sering kali ingin mencetak hanya area tertentu pada lembar kerja daripada mencetak seluruh lembar.<\/p><p> Untuk ini pengguna dapat mengatur dan membuat area pemilihan pencetakan dan setelah area pencetakan dipilih, setiap kali pengguna akan mendapatkan pencetakan pada rentang area yang dipilih saja.<\/p><p> Pengguna dapat membuat beberapa pilihan area cetak di spreadsheet dan masing-masing akan mencetak pada halaman terpisah.<\/p><p> Kami memiliki langkah cepat dan mudah yang disebutkan di bawah ini tentang cara mengatur dan mengubah pilihan area cetak di Excel.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Mengatur Area Cetak di Excel<\/h2><ol><li> Pertama, pilih rentang sel individual atau beberapa rentang sel menggunakan tombol &#8220;Kontrol&#8221; yang ingin Anda tetapkan sebagai area cetak di lembar.<\/li><li> Setelah itu, buka tab \u201cPage Setup\u201d dan klik ikon \u201cPrint Area\u201d, lalu pilih opsi \u201cSet Print Area\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-set-area-cetak-di-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"set-print-area-in-excel\" width=\"378\" height=\"449\"><\/li><li> Untuk melihat pilihan area cetak, buka tab \u201cLihat\u201d dan klik ikon \u201cTampilan Page Break\u201d dan Anda akan menemukan pratinjau hentian halaman berdasarkan pilihan area cetak. &#8216;kesan. <br><img loading=\"lazy\" decoding=\"async\" title=\"Tampilan jeda 2 halaman\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Vue-de-saut-de-2-pages.png\" sizes=\"auto, \" srcset=\"\" alt=\"page-break-view\" width=\"367\" height=\"400\"><\/li><\/ol><p> Pilihan area cetak disimpan saat Anda menyimpan buku kerja, dan setiap pilihan area cetak dicetak pada halaman terpisah yang berarti satu pilihan area cetak per halaman.<\/p><h2 class=\"wp-block-heading\"> Tambahkan sel dan rentang ke area cetak<\/h2><p> Kapan saja, pengguna dapat menambahkan sel untuk memperluas pilihan area cetak atau untuk membuat area cetak tambahan.<\/p><p> Saat pengguna menambahkan sel yang berdekatan dengan area cetak yang sudah ada, Excel menyertakan sel tersebut dalam pilihan area cetak yang sudah ada.<\/p><p> Jadi pemilihan area cetak ini diperluas dan ketika pengguna menambahkan rentang sel yang tidak berdekatan, Excel membuat rentang tersebut sebagai pilihan area cetak tambahan yang dicetak Excel pada halaman terpisah.<\/p><ul><li> Pertama, pilih rentang sel tambahan yang berdekatan jika Anda ingin memperluas pilihan area cetak saat ini.<\/li><li> Atau, pilih rentang sel tambahan yang tidak berdekatan jika Anda ingin menambahkan area cetak baru dengan area cetak yang sudah ada di lembar kerja.<\/li><li> Setelah itu, buka tab \u201cPage Layout\u201d dan klik ikon \u201cPrint Area\u201d lalu pilih \u201cAdd to Print Area\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66766\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-modifier-la-zone-dimpression1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah-area cetak\" width=\"428\" height=\"431\"><\/figure><\/div><p> Dalam \u201cPratinjau Hentian Halaman\u201d di bawah, Anda dapat melihat bahwa Excel telah memperluas pilihan area cetak di mana kami telah menambahkan sel yang berdekatan dan membuat pilihan area cetak tambahan di mana kami telah menambahkan sel yang tidak berdekatan.<\/p><p> Jadi dalam hal ini Anda akan mendapatkan tiga area cetak yang akan dicetak pada tiga halaman terpisah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66767\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Vue-de-saut-de-4-pages-pour-les-zones-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"area-tampilan-pemecah-halaman-untuk-cetak-area\" width=\"445\" height=\"369\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hapus pemilihan area cetak<\/h2><p> Di bawah tab &#8220;Tata Letak&#8221;, Excel tidak memiliki kemampuan untuk menghapus atau menghapus area cetak tertentu dari beberapa area cetak dalam satu lembar. Oleh karena itu, menghapus area cetak berarti menghapus seluruh area cetak.<\/p><ul><li> Pertama, klik di mana saja di lembar kerja yang ingin Anda hapus area cetaknya.<\/li><li> Setelah itu, buka tab \u201cPage Setup\u201d dan klik ikon \u201cPrint Area\u201d, lalu pilih \u201cClear Print Area\u201d dan ini akan menghapus semua area cetak dari lembar. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66768\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-effacer-la-zone-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"area cetak yang jelas\" width=\"544\" height=\"161\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Abaikan area cetak saat mencetak lembar kerja<\/h2><p> Pengguna dapat melewati area pencetakan untuk mencetak saat mencetak tanpa mengosongkan area pencetakan dan dapat mencetak seluruh lembar kerja kapan saja.<\/p><ul><li> Pertama, tekan \u201cCtrl+P\u201d untuk mencetak lembar kerja yang terbuka dan kotak dialog cetak akan terbuka.<\/li><li> Setelah itu, klik opsi \u201cCetak lembar aktif\u201d dan Anda akan mendapatkan daftar drop-down.<\/li><li> Sekarang, pilih opsi \u201cAbaikan Area Cetak\u201d dan Excel akan mengabaikan pemilihan area cetak dan mencetak seluruh lembar kerja. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66769\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ignorer-la-zone-dimpression.jpg\" sizes=\"auto, \" srcset=\"\" alt=\"abaikan area cetak\" width=\"261\" height=\"368\"><\/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\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/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\/kertas-grafik\/\">Cetak kertas grafik di Excel (templat kotak persegi)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-hentian-halaman\/\">Hapus hentian halaman di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/\">Pusatkan lembar kerja secara horizontal dan vertikal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-orientasi-halaman\/\">Ubah orientasi halaman di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/margin-halaman\/\">Margin Halaman di Excel (Ubah dan Atur)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1867","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 mengatur area cetak di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan\" \/>\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\/mengatur-area-cetak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengatur area cetak di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/\",\"name\":\"Bagaimana cara mengatur area cetak di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png\",\"datePublished\":\"2023-10-30T15:22:45+00:00\",\"dateModified\":\"2023-12-06T06:15:55+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengatur area cetak 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 mengatur area cetak di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan","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\/mengatur-area-cetak\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengatur area cetak di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan","og_url":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:55+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/","url":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/","name":"Bagaimana cara mengatur area cetak di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png","datePublished":"2023-10-30T15:22:45+00:00","dateModified":"2023-12-06T06:15:55+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara mengatur area cetak di Excel. Tambahkan sel dan rentang ke area cetak dan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-zone-dimpression-definie-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengatur area cetak 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\/1867","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=1867"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1867\/revisions"}],"predecessor-version":[{"id":2469,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1867\/revisions\/2469"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}