Your Excel sheet is too large to fit on a single printed page. The default scaling options may not give you the exact size you need. The Page Layout settings in Excel allow you to manually adjust the print scale. This article explains how to set a precise scaling percentage to shrink or enlarge your printout.
Key Takeaways: Adjusting Print Scale in Excel
- Page Layout > Scale to Fit > Scale: Enter a percentage to uniformly shrink or enlarge the printed content.
- Page Setup dialog launcher: Access the Page tab to set scaling and preview the adjustment before printing.
- Print Preview: Use this view to verify the scaled printout fits correctly on the page before using paper.
Understanding Excel’s Print Scaling Feature
Print scaling changes the size of your worksheet content on the printed page without altering the actual cell dimensions in the workbook. You can scale a sheet to a percentage of its normal size. For example, scaling to 80% makes everything smaller, while 150% makes it larger. This is different from fitting the sheet to a specific number of pages, which Excel does automatically. Manual percentage scaling gives you direct control over the final output size.
Before adjusting the scale, ensure your data is formatted correctly. Check page breaks using View > Page Break Preview. This shows how your data is currently divided across pages. Scaling is applied from the Page Layout tab. Changes made here affect only the print output for the active worksheet, not other sheets in the file.
Steps to Set a Custom Print Scale Percentage
Follow these steps to manually set a scaling percentage for your printout. The most reliable method uses the Page Layout tab on the ribbon.
- Select the worksheet to print
Click the sheet tab at the bottom of the Excel window. The scaling setting applies only to the active sheet. - Go to the Page Layout tab
Click the Page Layout tab on the Excel ribbon. Locate the Scale to Fit group of commands. - Enter a custom scale percentage
In the Scale to Fit group, find the box labeled Scale. Click inside the box and type a number between 10 and 400. This number is a percentage. Press Enter on your keyboard to apply it. - Open the Page Setup dialog for more control
Click the small dialog launcher icon in the bottom-right corner of the Page Setup group on the Page Layout tab. This opens the Page Setup dialog box. - Verify and adjust the setting
In the Page Setup dialog, ensure you are on the Page tab. The Scaling section has an option called Adjust to. The percentage you typed in step 3 will be shown here. You can change it directly in this dialog. - Preview the scaled printout
Click the Print Preview button in the Page Setup dialog. Alternatively, go to File > Print. The preview pane on the right shows exactly how your scaled sheet will look on the page. - Print the worksheet
If the preview looks correct, select your printer and click the Print button. If the scale is not right, click the back arrow to return to the worksheet and adjust the percentage again.
Using the Print Settings Directly
You can also set the scale just before printing without using the Page Layout tab. Go to File > Print. In the Settings section, click the last option which may say No Scaling. A menu will open. Select Custom Scaling Options at the bottom. This opens the Page Setup dialog where you can enter your percentage on the Page tab.
Common Mistakes and Limitations
Scale Percentage Has No Visible Effect
If changing the scale does not alter the print preview, another setting may be overriding it. In the Scale to Fit group, check the Width and Height boxes. If they are set to Automatic or a specific number of pages, they control the scaling instead. Change both Width and Height back to Automatic to let your custom percentage work.
Printed Text Becomes Too Small to Read
Scaling below 70% can make font sizes very small. Before printing at a low percentage, check the print preview carefully. Consider adjusting the default font size for the sheet or using the Fit to option instead to ensure text remains legible.
Margins or Headers Are Also Scaled
The custom scale percentage applies to the entire sheet area, including any headers and footers you have set. It does not scale the page margins. If your header text becomes too small, you may need to increase its font size separately via Page Setup > Header/Footer > Custom Header.
Manual Scaling vs Fit to Page: Key Differences
| Item | Custom Scale Percentage | Fit Sheet to One Page |
|---|---|---|
| Primary Control | You set an exact percentage (e.g., 85%) | Excel calculates the percentage automatically |
| Best Use Case | When you need a specific output size for consistency | When you simply want everything to fit on one page |
| Flexibility | High – any value between 10% and 400% | Low – Excel decides the scale |
| Effect on Readability | Risk of making text too small if percentage is too low | May create very small text if sheet is large |
| Location in Excel | Page Layout > Scale to Fit > Scale box | Page Layout > Scale to Fit > Width/Height boxes |
You can now resize your Excel printouts to any specific scale. Use the Scale box in the Page Layout tab for direct control. Next, try setting custom margins to work with your new print scale. For advanced control, use the F4 key to repeat your last scaling action on other sheets quickly.