Excel spreadsheets that span multiple pages can be difficult to read on the printed page. Fortunately Excel has several tools that you can use to adjust the way that your data prints. One such tool is the print scale setting, where you can enter a percentage by which to grow or shrink your spreadsheet.
Our guide below will show you the steps that you will need to make your Excel 2013 spreadsheet print at half of its default size.
Setting an Excel 2013 Spreadsheet to Print at 50 Percent
The steps in this article will adjust the size of your printed excel spreadsheet so that it is at 50%. If you are trying to modify your spreadsheet so that it fits entirely on one page, you can read this article instead.
Here is how to set the print scale to 50% in Excel 2013 –
- Open the spreadsheet in Excel 2013.
- Click the Page Layout tab at the top of the window.
- Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
- Click inside the field to the right of Adjust to, delete the current value, then type in 50.
- Click the OK button to save your changes.
These same steps are shown below with pictures –
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
Step 4: Click inside the field to the right of Adjust to, then delete the current value and enter 50.
Step 5: Click the OK button to save your changes.
While print scaling can make it easier to fit a lot of data on one sheet, it can be difficult to guess which scale is correct to get all of your columns to fit on the page. You can read this article about fitting all of your columns on one page if you are looking for a simpler way to print your spreadsheets.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.