How to Handle Custom Print Scaling Not Available in Excel for iPad
Question details
The user wants to apply custom print scaling to a worksheet in Excel for iPad, but the feature is not exposed in Excel for iPad or Excel for the web.
- Product
- Microsoft Excel for iPad
- Device & OS
- iPadOS
- Scenario
- Preparing a workbook for printing from an iPad while needing custom scale-to-fit or percentage scaling.
- Observed behavior
- Excel for iPad and Excel for the web do not include the desktop Scale a Worksheet printing controls; custom scaling is available only in Excel for Windows and Excel for Mac.
Confirm the workbook is saved to a cloud or shared location that Excel for Windows or Mac can open, such as OneDrive. You also need access to a desktop Excel version because the Scale a Worksheet controls are not exposed in Excel for iPad or Excel for the web.
Set Custom Print Scaling in Excel for Windows or Mac
Use this solution when you need access to the full Scale a Worksheet controls that are missing in Excel for iPad and Excel for the web.
Excel for iPad and Excel for the web do not expose the desktop Scale a Worksheet feature. Opening the same workbook in Excel for Windows or Mac gives you the Page Layout scaling controls and print-area tools needed for precise output.
Install or open Excel for Windows or Excel for Mac, sign in, and open the workbook that you prepared on your iPad.
In the ribbon, click the Page Layout tab to reveal the Scale to Fit group.
In the Scale to Fit group, choose a Width, Height, and Scale percentage, such as 1 page wide by 1 page tall or a custom 80% scale.
Select the range to print, then click Page Layout > Print Area > Set Print Area.
Click File > Print to preview the scaled layout, then save the workbook so the settings remain with the file.
Submit Feedback to Microsoft for iPad and Web Printing Improvements
Use this if the workflow must stay in Excel for iPad or Excel for the web and you want Microsoft to add the missing scaling feature.
Use WPS Office as a Free Alternative for Spreadsheet Printing
When Microsoft Excel for iPad or Excel for the web lacks the custom Scale a Worksheet control, WPS Office gives you a free, lightweight spreadsheet alternative. It opens and saves .xlsx files, keeps a familiar ribbon-based workspace, and lets you continue your printing and layout tasks without paying for desktop Excel.
Frequently Asked Questions
Can I scale a worksheet to fit one page in Excel for iPad?
No. Excel for iPad and Excel for the web do not include the Scale a Worksheet print feature. Open the workbook in Excel for Windows or Mac to set scaling and print-area options.
Where is the Scale to Fit group in Excel for iPad?
There is no Scale to Fit group in Excel for iPad. In Excel for Windows or Mac, go to the Page Layout tab, where the Scale to Fit group contains Width, Height, and Scale controls.
Does Excel for the web support custom print scaling?
No. Excel for the web also lacks the desktop Scale a Worksheet feature. Use Excel for Windows or Excel for Mac to configure custom scaling.
Will print scaling set in desktop Excel apply when I open the workbook on an iPad?
Page setup information, including scaling, is saved with the workbook. You may be able to print using the saved layout, but you cannot adjust the scaling from Excel for iPad; test the print preview on the iPad before final printing.
Is WPS Office a free alternative for editing and printing Excel files?
Yes. WPS Office is free, supports .xlsx workbooks, and provides Excel-compatible spreadsheet tools with a familiar interface for everyday spreadsheet tasks.
