If you’re like most people, you probably print sheets of paper on one page. But if you’re a Microsoft Excel user, there’s a way to print sheets on one page without having to use the mouse. To do this, open the “Print” tab in your Microsoft Excel window and select “Print as PDF.” Then, enter the following information into the “File name” field: Your name Your company name (optional) The sheet will be printed out as a PDF file.
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 on One Page in Excel
While the setup is the same, getting to the settings differs slightly between Excel on Windows versus Mac.
RELATED: What’s the Difference Between Microsoft Office for Windows and macOS?
On Windows, go to the Page Layout tab and click the arrow on the bottom right of the Page Setup section of the ribbon.
On Mac, go to the Page Layout tab and click “Page Setup.”
When the Page Setup window opens, make sure you’re 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 “OK” to save your change.
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.
RELATED: How to Repeat Specific Rows or Columns on Every Printed Page in Excel
In the Fit To boxes, enter the number 1 in the first box and 9999 in the second box. Click “OK” to save your change.
View a Print Preview
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 > Print from the menu or menu bar.
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.
If you’re not happy 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.
RELATED: How to Set the Print Area in Microsoft Excel
