{"id":1018,"date":"2018-07-01T10:13:43","date_gmt":"2018-07-01T10:13:43","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1018"},"modified":"2024-03-28T12:20:38","modified_gmt":"2024-03-28T12:20:38","slug":"print-area","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/print-area\/","title":{"rendered":"Print Area"},"content":{"rendered":"\n

When it comes to printing, Excel will, by default, print the entire worksheet and in many cases, it will take multiple pages. But Excel has the ability to print only these parts of the worksheet you choose to print. This feature is called Print Area<\/strong>.<\/p>\n\n\n\n

Print Area Button<\/h2>\n\n\n\n

You can find the button in PAGE LAYOUT >> Page Setup >> Print Area<\/strong>. Under this button, you will find three sub-buttons.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set Print Area<\/h2>\n\n\n\n

Set Print Area, as the name suggests, is used to show Excel which parts of the worksheet you want to print. Take a look at the following example.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you try to print the document before setting the print area, Excel will try to print the whole worksheet. If the printing area is too big it will use multiple sheets. Press Ctrl + P<\/span><\/strong> in order to open Print Preview<\/a>. Our document looks like this.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, let\u2019s tell Excel which part to print<\/a>. In this example, we want to print only the table, without the company name and SUM column.<\/p>\n\n\n\n

Select cells from B5<\/strong> to E11,<\/strong> then choose PAGE LAYOUT >> Page Setup >> Print Area >> Set Print Area<\/strong>.<\/p>\n\n\n\n

Open Print Preview<\/a> (Ctrl + P<\/strong>) to see what your document looks like.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Clear Print Area<\/h2>\n\n\n\n

Clear Print Area is used to clear the previously set print area. Now, if you want to print something Excel will use the whole document.<\/p>\n\n\n\n

Add to Print Area<\/h2>\n\n\n\n

If you set the print area and want to add another one, use the Add to Print Area<\/strong> button. It will add an additional area to print.<\/p>\n\n\n\n

CAUTION<\/h3>\n\n\n\n

If you add an area that is a part of another area, the previous selections will vanish and you will have only the last area set.<\/p>\n\n\n\n

A better way is to use Ctrl. Select ranges as shown in the example below and you will get three print areas.<\/p>\n\n\n\n

NOTE<\/h3>\n\n\n\n

Because the ranges from B8<\/strong> to E8<\/strong> and from B9<\/strong> to E9<\/strong> are adjacent, even if you choose them separately, they will be considered by Excel as a single area.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, we have the following print areas created.<\/p>\n\n\n\n

Print Area 1<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Print Area 2<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Print Area 3<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Multiple print areas on a single page<\/h2>\n\n\n\n

If we create multiple print areas you will notice that each of them is printed on a different page. That\u2019s the way that Excel works. We can\u2019t force Excel to pack many areas on a single page, even if there is a lot of space.<\/p>\n\n\n\n

But there may be a workaround in some cases. In our example, we have three print areas. If we want to print it on a single page, we have to use a trick.<\/p>\n\n\n\n

We will print four pages<\/a> on a single page. Click Ctrl + P<\/span><\/strong> to open print options and open Printer Properties<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set Pages per Sheet<\/strong> to 4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If we print it now, our table will be 50%<\/strong> wide and 50%<\/strong> high. In order to scale it, go to Page Setup<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

And scale it to 200%<\/strong> of the normal size.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Print the document and you will get all three print areas on one page.<\/p>\n","protected":false},"excerpt":{"rendered":"

When it comes to printing, Excel will, by default, print the entire worksheet and in many cases, it will take multiple pages. But…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\nPrint Area<\/title>\n<meta name=\"description\" content=\"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Print Area\" \/>\n<meta property=\"og:description\" content=\"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T10:13:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T12:20:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Print Area\",\"datePublished\":\"2018-07-01T10:13:43+00:00\",\"dateModified\":\"2024-03-28T12:20:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\"},\"wordCount\":554,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\",\"name\":\"Print Area\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png\",\"datePublished\":\"2018-07-01T10:13:43+00:00\",\"dateModified\":\"2024-03-28T12:20:38+00:00\",\"description\":\"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/print-area\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-area\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Print Area\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Print Area","description":"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.","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:\/\/officetuts.net\/excel\/examples\/print-area\/","og_locale":"en_US","og_type":"article","og_title":"Print Area","og_description":"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.","og_url":"https:\/\/officetuts.net\/excel\/examples\/print-area\/","article_published_time":"2018-07-01T10:13:43+00:00","article_modified_time":"2024-03-28T12:20:38+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Print Area","datePublished":"2018-07-01T10:13:43+00:00","dateModified":"2024-03-28T12:20:38+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/"},"wordCount":554,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/","url":"https:\/\/officetuts.net\/excel\/examples\/print-area\/","name":"Print Area","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png","datePublished":"2018-07-01T10:13:43+00:00","dateModified":"2024-03-28T12:20:38+00:00","description":"Use Excel's Print Area function to print only parts of your worksheet. Set, clear, and add to print areas easily with these tips.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/print-area\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/07\/print-area-subbuttons.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/print-area\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Print Area"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1018"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1018"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1018\/revisions"}],"predecessor-version":[{"id":15513,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1018\/revisions\/15513"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}