There are a few easy ways to force your Excel 2013 spreadsheet to fit on one page, which can help to solve many of the print problems that you might be having with your worksheets. But many Excel jobs don’t fit into the same set of criteria, or only some of your spreadsheet might be printing, so you may find yourself needing to see the current print layout of your data so that you can adjust it manually.
One way to do this is with the help of the Page Layout view in Excel 2013. Excel 2013 has several different view options that you will find to be effective in certain situations, but the Page Layout option is particularly useful when you are concerned about correctly fitting your rows and columns to the printed page. Our guide below will show you how to switch to that view from whatever view is currently set in your workbook.
Viewing the Print or Page Layout in Excel 2013
The steps in this article will show you how to see the page layout in Excel 2013. This changes the on-screen view so that you can see which cells will be fitting on each page, as well as any header or footer information you have added.
Here is how to see the print layout in Excel 2013 –
- Open the worksheet in Excel 2013.
- Click the View tab at the top of the window.
- Click the Page Layout option in the Workbook Views section of the ribbon.
These steps are repeated below with pictures –
Step 1: open your spreadsheet in Excel 2013.
Step 2: Click the View tab above the ribbon.
Step 3: Click the Page Layout button in the Workbook Views section of the ribbon.
Your sheet should then look something like the image below.
You can also see the print layout in Print Preview by pressing Ctrl + P on your keyboard, of by clicking the File tab, then clicking Print –
You can also change the way that your spreadsheet prints by adjusting the scale. It’s yet another of many ways to adjust the appearance of your data on the physical page.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.