Set Fit Sheet on One Page as Excel's Default Print Setting
Question details
The user wants Excel to use Fit Sheet on One Page automatically when printing worksheets.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is looking for a default print setting that scales a worksheet to one page.
- Observed behavior
- Fit Sheet on One Page is a worksheet Page Setup property and does not appear as a global option in Excel's Advanced print settings.
Select the worksheet that needs the scaling rule and open Print Preview to check whether the intended print area and page orientation are correct before saving the setting.
Apply Fit Sheet on One Page through Excel Page Setup
Use this method when you need to scale the current worksheet to one page immediately.
Fit Sheet on One Page belongs to the worksheet's page-scaling settings, not to Excel's general printer preferences. Applying it through Page Layout or the Print screen changes the selected sheet's print setup.
In Excel, select the worksheet, open the Page Layout tab, and click the small Page Setup launcher in the Page Setup group.
On the Page tab of the Page Setup dialog box, select Fit to under Scaling, then set the page width to 1 page and the page height to 1 page.
Click OK, then select File > Print and review the preview to confirm that the entire worksheet fits on one page.
Save the page-scaling setting in an Excel template
Use a template when new worksheets or workbooks should start with the same one-page print setup.
Print a WPS Spreadsheet on One Page with Page Scaling
WPS Spreadsheet lets you apply Fit to One Page from Page Layout or the Print settings, then save the configured workbook as a reusable template for future reports.
- 1. Select the worksheet: Open the workbook in WPS Spreadsheet and select the sheet that you want to print.
- 2. Open page scaling: Go to the Page Layout tab, open Page Setup, and locate the Scaling options.
- 3. Fit the sheet to one page: Choose Fit to and set the width to 1 page and the height to 1 page, or open the Print screen and choose Fit Sheet on One Page.
- 4. Check the print preview: Select Menu or File > Print and review the preview before printing or saving the workbook as a template.
Frequently Asked Questions
Why is Fit Sheet on One Page missing from Excel's Advanced settings?
It is a worksheet Page Setup property rather than a global printer preference. Open Page Layout > Page Setup > Scaling, or use File > Print and select Fit Sheet on One Page.
Can I make Fit Sheet on One Page the default for every Excel workbook?
Excel does not provide this as a universal Advanced print preference. Configure the worksheet and save it as an Excel template, or use a VBA macro to apply the page setup automatically.
Does the setting apply to every worksheet in a workbook?
The setting applies to the selected worksheet. To apply it to several sheets, select the worksheet tabs together before opening Page Setup, then remember to ungroup the sheets afterward.
Will fitting a sheet to one page make the text smaller?
Yes. Excel scales the worksheet content to fit the selected page dimensions. If the result is difficult to read, adjust the print area, orientation, margins, or page width and height settings.
