{"id":369819,"date":"2021-11-19T19:00:02","date_gmt":"2021-11-19T16:00:02","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-print-a-sheet-on-one-page-in-microsoft-excel\/"},"modified":"2021-11-19T19:00:02","modified_gmt":"2021-11-19T16:00:02","slug":"how-to-print-a-sheet-on-one-page-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-print-a-sheet-on-one-page-in-microsoft-excel\/","title":{"rendered":"#How to Print a Sheet on One Page in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a2ba70d3ce3c\" 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-6a2ba70d3ce3c\" 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-print-a-sheet-on-one-page-in-microsoft-excel\/#How_to_Print_a_Spreadsheet_on_One_Page_in_Excel\" >How to Print a Spreadsheet on One Page 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-print-a-sheet-on-one-page-in-microsoft-excel\/#View_a_Print_Preview\" >View a Print Preview<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Print a Sheet on One Page 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>Printing a spreadsheet in Microsoft Excel can be challenging if you have a lot of data. To cut down on the paper and keep your data together, you can print your sheet on one page instead of multiple pages.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Print_a_Spreadsheet_on_One_Page_in_Excel\"><\/span>How to Print a Spreadsheet on One Page in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While the setup is the same, getting to the settings differs slightly between Excel on Windows versus Mac.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What&#8217;s the Difference Between Microsoft Office for Windows and macOS?<\/em><\/strong><\/p>\n<p>On Windows, go to the Page Layout tab and click the arrow on the bottom right of the Page Setup section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761467\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/OpenPageSetupWindows-ExcelPrintOnePage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Open Page Setup in Excel on Windows\" width=\"477\" height=\"159\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On Mac, go to the Page Layout tab and click \u201cPage Setup.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761466\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/OpenPageSetupMac-ExcelPrintOnePage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Open Page Setup in Excel on Mac\" width=\"525\" height=\"100\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Page Setup window opens, make sure you\u2019re on the Page tab. Go down to the Scaling section, mark the option for Fit To, and enter the number 1 in both boxes. Click \u201cOK\u201d to save your change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-761473 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/FitToPage-ExcelPrintOnePage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter 1 in the Fit To boxes\" width=\"625\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> If your sheet is wider than it is long, consider changing the Orientation in the Page Setup window to Landscape to accommodate the width.<\/p><\/blockquote>\n<p>If you have a ton of rows in your sheet, printing on a single page like this may make the data difficult to read. So, if you want the columns on one page but are fine with the rows extending to more pages, this is doable.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Repeat Specific Rows or Columns on Every Printed Page in Excel<\/em><\/strong><\/p>\n<p>In the Fit To boxes, enter the number 1 in the first box and 9999 in the second box. Click \u201cOK\u201d to save your change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761469\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/FitRows-ExcelPrintOnePage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter 1 and 9999 in the Fit To boxes\" width=\"625\" height=\"500\" 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=\"View_a_Print_Preview\"><\/span>View a Print Preview<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can see a preview of how your sheet will look on a single page before you print it. On both Windows and Mac, click File &gt; Print from the menu or menu bar.<\/p>\n<p>This gives you a nice view of whether or not printing your sheet on one page works for you. If it does, continue to print as you normally would.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761470\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PrintPreview-ExcelPrintOnePage.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Print preview in Excel\" width=\"650\" height=\"361\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re not h<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>y with the preview of your sheet on a single page, remember that you can always print a specific selection of cells in Excel instead. Or, you can set up and save a print area in Excel if you plan to print the same section often.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Set the Print Area in Microsoft Excel<\/em><\/strong><\/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\/761465\/how-to-print-a-sheet-on-one-page-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Print a Sheet on One Page in Microsoft Excel&#8221; Printing a spreadsheet in Microsoft Excel can be challenging if you have a lot of data. To cut down on the paper and keep your data together, you can print your sheet on one page instead of multiple pages. How to Print a Spreadsheet&#8230;<\/p>\n","protected":false},"author":1,"featured_media":369820,"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-369819","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\/369819","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=369819"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/369819\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/369820"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=369819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=369819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=369819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}