{"id":376589,"date":"2021-12-04T19:00:05","date_gmt":"2021-12-04T16:00:05","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/"},"modified":"2021-12-04T19:00:05","modified_gmt":"2021-12-04T16:00:05","slug":"how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/","title":{"rendered":"#How to Insert, Edit, or Remove Page Breaks in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a41883b1f1e9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a41883b1f1e9\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/#About_Page_Breaks_in_Excel\" >About Page Breaks in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/#Insert_a_Page_Break_in_Excel\" >Insert a Page Break in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/#Edit_or_Move_a_Page_Break\" >Edit or Move a Page Break<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/#Remove_a_Page_Break\" >Remove a Page Break<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Insert, Edit, or Remove Page Breaks in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-763383\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreaksExcel.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreaksExcel.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreaksExcel.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Page Breaks in Excel\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have a large Excel spreadsheet you\u2019re going to print, you may want the pages separated at particular spots. One way to do this is to set the print area. But another is to insert manual page breaks.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Print a Worksheet with Comments in Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"About_Page_Breaks_in_Excel\"><\/span>About Page Breaks in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It\u2019s best to work with your page breaks in the Page Break Preview in Excel. This allows you to see the automatic and manual breaks as well as the number of pages and their layout.<\/p>\n<p>Go to the View tab and click \u201cPage Break Preview\u201d in the Workbook Views section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763388\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/ViewPageBreakPreview-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to View, Page Break Preview\" width=\"650\" height=\"129\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can close Page Break Preview any time by clicking \u201cNormal\u201d on the View tab.<\/p>\n<p>Excel adds automatic page breaks where it believes they belong. You can also add your own, as we\u2019ll explain, but there are a few differences between automatic and manual page breaks you should be aware of.\u00a0An automatic break that Excel adds is indicated by a dotted blue line whereas a manual break that you add has a solid blue line.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763389\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AutomaticVSManual-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Automatic vs. manual breaks in Excel\" width=\"650\" height=\"205\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In addition:<\/p>\n<ul>\n<li>If you move an automatic page break, it becomes a manual break.<\/li>\n<li>You cannot delete an automatic page break.<\/li>\n<li>If you delete all manual page breaks, this resets the spreadsheet to display automatic breaks.<\/li>\n<\/ul>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_a_Page_Break_in_Excel\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Insert a Page Break in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you open Page Break Preview, you can set up a vertical break, horizontal break, or both. To insert a <strong>vertical<\/strong> page break, select the column to the right of where you want the break. To insert a <strong>horizontal<\/strong> page break, select the row below where you want the break.<\/p>\n<p>Then, go to the Page Layout tab and click the Breaks drop-down arrow. Choose \u201cInsert Page Break.\u201d Alternatively, you can right-click and pick \u201cInsert Page Break.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763391\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/InsertPageBreak-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Breaks, Insert Page Break\" width=\"650\" height=\"341\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the break display with its solid blue line.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763390\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/InsertedPageBreak-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Inserted page break in Excel\" width=\"650\" height=\"249\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Continue the same process to insert additional page breaks as needed.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Edit_or_Move_a_Page_Break\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Edit or Move a Page Break<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can edit a page break by moving it to include more or less of your sheet and use additional or fewer pages. Remember, if you move an automatic page break, this changes it to a manual break.<\/p>\n<p>To move a page break, click and begin to drag in the direction you want. You\u2019ll see a double-sided arrow and dark gray line as you do this. Release when you finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763392\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/MovePageBreak-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Move a page break\" width=\"650\" height=\"248\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/220645\/how-to-print-the-gridlines-and-row-and-column-headings-in-excel\/\">include the row and column headings or gridlines, you do that outside of this process. What you see here is simply for the sheet\u2019s cell data.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Print the Gridlines and Row and Column Headings in Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_a_Page_Break\"><\/span>Remove a Page Break<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can remove a manual page break that you insert easily. Select the column to the right or row below the break you want to delete.<\/p>\n<p>Then, head to the Page Layout tab, click the Breaks drop-down arrow, and choose \u201cRemove Page Break.\u201d You can also right-click and pick \u201cRemove Page Break.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763394\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/RemovePageBreak-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Breaks, Remove Page Break\" width=\"650\" height=\"403\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your sheet will automatically update to accommodate the remaining breaks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763393\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/RemainingPageBreaks-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Removed a page break\" width=\"650\" height=\"249\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to remove all of the page breaks you\u2019ve inserted instead of just one, click the Breaks drop-down box and choose \u201cReset All Page Breaks.\u201d Or, right-click and pick \u201cReset All Page Breaks.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763396\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/ResetPageBreaks-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Breaks, Reset All Page Breaks\" width=\"650\" height=\"401\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your sheet will then update to display only automatic breaks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763395\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/ResetAllPageBreaks-ExcelPageBreaks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Page breaks in Excel reset\" width=\"650\" height=\"248\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you decide that you only want to print part of your spreadsheet, you can also <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/447593\/how-to-print-a-specific-selection-of-cells-in-excel\/\">print a specific selection of cells in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/763379\/how-to-insert-edit-or-remove-page-breaks-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Insert, Edit, or Remove Page Breaks in Microsoft Excel&#8221; If you have a large Excel spreadsheet you\u2019re going to print, you may want the pages separated at particular spots. One way to do this is to set the print area. But another is to insert manual page breaks. RELATED: How to Print a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":376590,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreaksExcel.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-376589","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/376589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=376589"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/376589\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/376590"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=376589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=376589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=376589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}