{"id":367046,"date":"2021-11-14T19:00:26","date_gmt":"2021-11-14T16:00:26","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-set-the-print-area-in-microsoft-excel\/"},"modified":"2021-11-14T19:00:26","modified_gmt":"2021-11-14T16:00:26","slug":"how-to-set-the-print-area-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-print-area-in-microsoft-excel\/","title":{"rendered":"#How to Set the Print Area 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-6a3b180cdf450\" 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-6a3b180cdf450\" 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-set-the-print-area-in-microsoft-excel\/#How_to_Set_a_Print_Area_in_Excel\" >How to Set a Print Area 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-set-the-print-area-in-microsoft-excel\/#How_to_View_a_Print_Area\" >How to View a Print Area<\/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-set-the-print-area-in-microsoft-excel\/#How_to_Add_Cells_to_a_Print_Area\" >How to Add Cells to a Print Area<\/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-set-the-print-area-in-microsoft-excel\/#How_to_View_a_Print_Preview\" >How to View a Print Preview<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-set-the-print-area-in-microsoft-excel\/#How_to_Clear_a_Print_Area\" >How to Clear a Print Area<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Set the Print Area in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you frequently print a certain part of your spreadsheet, you can choose a designated print area in Microsoft Excel. This saves you from having to select it every time you want to print. We\u2019ll show you how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Set_a_Print_Area_in_Excel\"><\/span>How to Set a Print Area in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can set one or more print areas in the same Excel sheet. To set a single print area, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/354258\/how-to-easily-select-a-block-of-cells-in-excel\/\">select the cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. Choose \u201cSet Print Area.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760465\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/SetArea-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Print Area, Set Print Area\" width=\"559\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To set multiple print areas in your sheet, hold Ctrl as you select each group of cells.<\/p>\n<p>Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. Next, head to the Page Layout tab and pick \u201cSet Print Area\u201d in the Print Area drop-down box. When it\u2019s time to print, each print area will display on its own page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760464\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/SetMultiple-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Print Area, Set Print Area\" width=\"650\" height=\"279\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you set a print area in your Excel sheet, it will save automatically when you save your workbook. This allows you to quickly print that same spot without resetting the print area.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_View_a_Print_Area\"><\/span>How to View a Print Area<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you set up your print area, you may want to confirm you\u2019ve selected the right cells. Open the View tab and select \u201cPage Break Preview.\u201d You\u2019ll then see each print area you\u2019ve set for that sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760467\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreakPreview-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Page Break Preview to see print areas\" width=\"650\" height=\"343\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cNormal\u201d or \u201cPage Layout\u201d to return to your sheet, depending on which view you were using.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Add_Cells_to_a_Print_Area\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">How to Add Cells to a Print Area<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You may need to add more cells to your print area after you set it up. You have two options for adjusting the print area, depending on if you want to incorporate adjacent cells or not.<\/p>\n<p>If you simply want to include another set of cells in the print area setup, select the cells. Then, go to the Page Layout tab and select \u201cAdd to Print Area\u201d in the Print Area drop-down box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760469\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AddNonAdjacentCells-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add Nonadjacent Cells\" width=\"496\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you do this, those additional cells are considered their own print area because they are not adjacent to another print area in the sheet. So, that group of cells will print on their own page as you can see below in the Page Break Preview.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760468\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreakPreviewNonAdjacentCells-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Preview Nonadjacent Cells\" width=\"415\" height=\"251\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now if you want to increase the size of a current print area to include more cells, be sure to select the cells adjacent to the area. Then, select \u201cAdd to Print Area\u201d in the Print Area drop-down box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760471\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/AddAdjacentCells-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add Adjacent Cells\" width=\"489\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then if you use the Page Break Preview, you can see that the print area has been increased and stays on the same page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760470\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageBreakPreviewAdjacentCells-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Preview Adjacent Cells\" width=\"423\" height=\"250\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_View_a_Print_Preview\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">How to View a Print Preview<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to see a quick preview of how the page will look when you print it, return to the Page Layout tab. Click the arrow on the bottom right corner of the Page Setup section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760474\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageSetup-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the arrow for Page Setup\" width=\"481\" height=\"159\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cPrint Preview.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760473\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageSetupPrintPreview-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Print Preview\" width=\"650\" height=\"444\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see exactly what the sheet will look like when you print. Hit the arrow on the top left to return to your sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760472\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PrintPreview-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Print preview in Excel\" width=\"650\" height=\"416\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> Alternatively, you can select File &gt; Print or <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/361582\/all-the-best-microsoft-excel-keyboard-shortcuts\/\">use a keyboard shortcut, Ctrl+F2, to see your print preview.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Clear_a_Print_Area\"><\/span>How to Clear a Print Area<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you make many changes to your sheet, prefer not to print only a specific section, or want to set up a new print area, you can remove an existing one easily.<\/p>\n<p>Select the print area or a cell within it. Back on the Page Layout tab, click \u201cClear Print Area\u201d in the Print Area drop-down box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760475\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PageLayoutClear-ExcelPrintArea.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Print Layout, Clear Print Area\" width=\"560\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have more than one print area set up, simply do this for each one on your sheet.<\/p>\n<p>For additional help printing in Microsoft Excel, learn how 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\/\">print the gridlines with row and column headers or how to print an Excel sheet that has a background.<\/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\/760456\/how-to-set-the-print-area-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Set the Print Area in Microsoft Excel&#8221; If you frequently print a certain part of your spreadsheet, you can choose a designated print area in Microsoft Excel. This saves you from having to select it every time you want to print. We\u2019ll show you how. How to Set a Print Area in Excel&#8230;<\/p>\n","protected":false},"author":1,"featured_media":367047,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-367046","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\/367046","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=367046"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/367046\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/367047"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=367046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=367046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=367046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}