{"id":1886,"date":"2023-10-30T09:05:14","date_gmt":"2023-10-30T09:05:14","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/"},"modified":"2023-12-06T06:15:44","modified_gmt":"2023-12-06T06:15:44","slug":"mencetak-judul","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/","title":{"rendered":"Bagaimana cara menerapkan judul cetak di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1520385468\"><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, jika Anda ingin mencetak beberapa halaman tetapi ingin membuat header atau judul dari baris pertama untuk dicetak di bagian atas setiap halaman, Anda bisa menggunakan opsi Cetak Judul di Excel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72469\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\" sizes=\"auto, \" srcset=\"\" alt=\"mencetak beberapa halaman\" width=\"651\" height=\"403\"><\/figure><\/div><p> Di atas kita memiliki datanya dan kita perlu mengatur baris pertama sebagai judul yang akan dicetak pada setiap halaman. Tabel ini memiliki lebih dari 1000 baris data ketika saya mencoba mencetaknya, ada 23 halaman untuk dicetak.<\/p><h2 class=\"wp-block-heading\"> Gunakan judul cetak untuk menetapkan 1 baris sebagai header dalam hasil cetakan<\/h2><ol><li> Pertama, buka tab Tata Letak \u21e2 Grup Kumpulan Halaman \u21e2 Judul Cetak. <br><img loading=\"lazy\" decoding=\"async\" title=\"Ubin cetak 2 kali pakai\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-des-tuiles-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-print-tiles\" width=\"654\" height=\"207\"><\/li><li> Setelah itu, klik tombol \u201cCetak Judul\u201d untuk membuka kotak dialog \u201cPengaturan Halaman\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"Dialog konfigurasi 3 halaman\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-de-configuration-a-3-pages.png\" sizes=\"auto, \" srcset=\"\" alt=\"page-setup-dialog-box\" width=\"540\" height=\"521\"><\/li><li> Sekarang, dari kotak dialog ini, Anda perlu menggunakan opsi \u201cGaris untuk diulang di atas:\u201d. Jadi, klik panah atas yang Anda miliki di sisi kanan. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-pilih-baris-untuk-mengulangi-di-atas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lignes-selectionnees-a-repeter-en-haut.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-rows-to-repeat-at-top\" width=\"541\" height=\"522\"><\/li><li> Pada titik ini Anda memiliki bilah input pemilihan rentang dan Anda harus memilih baris pertama untuk menentukannya. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-tentukan-baris\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-specifier-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"specify-the-row\" width=\"672\" height=\"243\"><\/li><li> Selanjutnya, klik panah bawah di sebelah kanan untuk kembali ke halaman pengaturan. <br><img loading=\"lazy\" decoding=\"async\" title=\"Konfigurasi 6-kembali ke halaman\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-revenir-a-la-configuration-de-la-page.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-back-to-the-page-setup\" width=\"683\" height=\"83\"><\/li><li> Pada akhirnya, klik OK untuk menyimpan pengaturan. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-simpan-pengaturan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-enregistrer-les-parametres.png\" sizes=\"auto, \" srcset=\"\" alt=\"save-the-settings\" width=\"542\" height=\"523\"><\/li><\/ol><p> Sekarang saat mencetak data ini, Excel akan mencetak baris pertama setiap halaman. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-dapercu-avant-impression.png\" sizes=\"auto, \" srcset=\"\" alt=\"data pratinjau cetak\" width=\"812\" height=\"433\"><\/figure><\/div><p> Seperti yang Anda lihat pada cuplikan di atas, kami memiliki total 23 halaman dalam pratinjau cetak, dan ini menunjukkan judul halaman yang kami tentukan mulai dari baris pertama.<\/p><h2 class=\"wp-block-heading\"> Menggunakan banyak baris sebagai judul cetak (header)<\/h2><p> Demikian pula, ketika Anda menentukan baris pertama, Anda juga dapat menentukan beberapa baris untuk ditetapkan sebagai judul cetakan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72477\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-utiliser-plusieurs-lignes-comme-titre-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan beberapa baris sebagai judul cetak\" width=\"665\" height=\"232\"><\/figure><\/div><p> Anda hanya perlu memilih baris-baris ini dan menentukan alamatnya di bilah input, lalu klik OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72478\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionner-les-lignes-pour-les-en-tetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-baris-untuk-header\" width=\"500\" height=\"523\"><\/figure><\/div><p> Tetapi Anda hanya dapat menentukan garis kontinu, jika Anda mencoba merujuk ke garis tidak kontinu, kesalahan akan ditampilkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72479\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-selectionner-uniquement-les-lignes-continues.png\" sizes=\"auto, \" srcset=\"\" alt=\"hanya-pilih-lanjutkan-baris\" width=\"568\" height=\"497\"><\/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\/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\/mengatur-area-cetak\/\">Atur Area Cetak 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><\/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-1886","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 menerapkan judul cetak di Excel?<\/title>\n<meta name=\"description\" content=\"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...\" \/>\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\/mencetak-judul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menerapkan judul cetak di Excel?\" \/>\n<meta property=\"og:description\" content=\"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.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\/mencetak-judul\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/\",\"name\":\"Bagaimana cara menerapkan judul cetak di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\",\"datePublished\":\"2023-10-30T09:05:14+00:00\",\"dateModified\":\"2023-12-06T06:15:44+00:00\",\"description\":\"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menerapkan judul 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 menerapkan judul cetak di Excel?","description":"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...","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\/mencetak-judul\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menerapkan judul cetak di Excel?","og_description":"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...","og_url":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.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\/mencetak-judul\/","url":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/","name":"Bagaimana cara menerapkan judul cetak di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png","datePublished":"2023-10-30T09:05:14+00:00","dateModified":"2023-12-06T06:15:44+00:00","description":"Pelajari opsi sederhana namun kuat untuk menerapkan judul cetak di Excel di mana kita dapat mengatur baris 1 untuk dicetak...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mencetak-judul\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mencetak-judul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menerapkan judul 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\/1886","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=1886"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1886\/revisions"}],"predecessor-version":[{"id":2445,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1886\/revisions\/2445"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}