{"id":14648,"date":"2023-02-01T10:13:28","date_gmt":"2023-02-01T10:13:28","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=14648"},"modified":"2024-03-28T12:20:38","modified_gmt":"2024-03-28T12:20:38","slug":"print-excel-sheet-on-a4","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/","title":{"rendered":"Print Excel Sheet on A4"},"content":{"rendered":"\n
Print-Excel-Sheet-on-A4<\/a>Download File<\/a><\/div>\n\n\n\n

Just as there are multiple ways to manipulate the data in Excel, we also have ways to manipulate the look of our data before printing, and to find the best way to present the data in hard copy.<\/p>\n\n\n\n

We will show different ways to prepare the Excel file for printing on A4 format<\/strong> paper.<\/p>\n\n\n\n

Use Page Setup<\/h2>\n\n\n\n

For our example, we will use the list of NBA players<\/strong> with their stats for points, rebounds, assists, and turnovers for one night:<\/p>\n\n\n\n

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

To print this table to an A4 format<\/strong> we need to go to the Page Layout tab<\/strong>, then find the Page Setup<\/strong>, and click on the little triangle in the bottom right corner<\/strong>:<\/p>\n\n\n\n

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

In the window that appears, we will go to the Page tab<\/strong>, go to the Fit to<\/strong>, and choose fit to one page<\/strong>. We will also select A4 as the paper size from the dropdown:<\/p>\n\n\n\n

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

We can click OK<\/strong>, but we can also choose the Print Preview option<\/strong> to see what we would end up with:<\/p>\n\n\n\n

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

Under the settings, we can see that the option for printing is in A4 format<\/strong>.<\/p>\n\n\n\n

Use Size in Page Layout<\/h2>\n\n\n\n

Another way to achieve the same results is to go to the Page Layout tab<\/strong>, then go to Size<\/strong> under Page Setup<\/strong> and finally choose A4 format<\/strong>:<\/p>\n\n\n\n

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

Use Print Preview<\/h2>\n\n\n\n

Print Preview<\/strong> is one of the most convenient options for printing sheets on A4. We will go to File >> Print<\/strong> and in the middle of the page we will see printing settings. We will choose A4<\/strong> as an option:<\/p>\n\n\n\n

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

Use Orientation<\/h2>\n\n\n\n

One more option to use is Orientation<\/strong>. Again, we go to the Page Layout tab<\/strong>, then we go to Page Setup >> Orientation >> Landscape<\/strong>:<\/p>\n\n\n\n

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

When we go to the Print Preview<\/strong> option this time, we will notice that our table will be presented in a Landscape view<\/strong> and that the A4 format option<\/strong> is chosen automatically:<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

Just as there are multiple ways to manipulate the data in Excel, we also have ways to manipulate the look of our data…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nPrint Excel Sheet on A4<\/title>\n<meta name=\"description\" content=\"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.\" \/>\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-excel-sheet-on-a4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Print Excel Sheet on A4\" \/>\n<meta property=\"og:description\" content=\"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-01T10:13:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T12:20:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-excel-sheet-on-a4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Print Excel Sheet on A4\",\"datePublished\":\"2023-02-01T10:13:28+00:00\",\"dateModified\":\"2024-03-28T12:20:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\"},\"wordCount\":329,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\",\"name\":\"Print Excel Sheet on A4\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png\",\"datePublished\":\"2023-02-01T10:13:28+00:00\",\"dateModified\":\"2024-03-28T12:20:38+00:00\",\"description\":\"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png\",\"width\":717,\"height\":274},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Print Excel Sheet on A4\"}]},{\"@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.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Print Excel Sheet on A4","description":"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.","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-excel-sheet-on-a4\/","og_locale":"en_US","og_type":"article","og_title":"Print Excel Sheet on A4","og_description":"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.","og_url":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/","article_published_time":"2023-02-01T10:13:28+00:00","article_modified_time":"2024-03-28T12:20:38+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Print Excel Sheet on A4","datePublished":"2023-02-01T10:13:28+00:00","dateModified":"2024-03-28T12:20:38+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/"},"wordCount":329,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/","url":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/","name":"Print Excel Sheet on A4","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png","datePublished":"2023-02-01T10:13:28+00:00","dateModified":"2024-03-28T12:20:38+00:00","description":"Choose A4 as the paper size for printing an Excel sheet. Learn more on how to do it here.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/02\/word-image-14648-1.png","width":717,"height":274},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/print-excel-sheet-on-a4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Print Excel Sheet on A4"}]},{"@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."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14648"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=14648"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14648\/revisions"}],"predecessor-version":[{"id":15395,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/14648\/revisions\/15395"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=14648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=14648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=14648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}