'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Excel for the Web from Printing All Columns on One Page
Question details
The user needs to change the default print scaling in Excel for the web so it does not force all columns onto a single page.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to print a workbook from the web version of Excel.
- Observed behavior
- Excel for the web defaults to 'Fit all columns on one page', ignoring the print settings originally configured in the desktop application.
Ensure you have a stable internet connection and are signed into your Microsoft account so that any changes you make to the workbook's print settings are successfully saved to OneDrive or SharePoint.
Adjust Print Scaling Options in Excel for the Web
Manually change the print scaling settings directly within the Excel web interface to stop it from compressing all columns.
Excel for the web often attempts to compress spreadsheet data to save paper by default. Because web and desktop print configurations operate independently, you must adjust the web-specific settings directly before printing.
Launch your web browser and open the desired workbook in Excel for the web.
Click on 'File' in the top ribbon menu, then select 'Print' from the sidebar.
In the Print setup dialog, locate the scaling dropdown menu. Change it from 'Fit all columns on one page' to 'No Scaling' or your preferred layout.
Print the document or view the preview to ensure the columns are laid out correctly, then save the workbook.
Clear Browser Cache and Cookies
If Excel for the web keeps reverting to the 'Fit all columns on one page' default, clearing your browser data can resolve persistent setting resets.
Take Full Control of Your Print Settings with WPS Office
If Excel for the web's browser-based printing is causing persistent layout issues, WPS Spreadsheet offers a robust, desktop-class printing experience. You can easily manage print scaling, set specific print areas, and adjust margins without dealing with browser cache resets or web sync glitches.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheet on your computer and open your existing Excel workbook.
- 2. Access Print Settings: Click on 'Menu' in the top-left corner and select 'Print', or simply use the 'Ctrl + P' keyboard shortcut.
- 3. Adjust Print Scaling: In the Print dialog box, navigate to the scaling options and select '100% Normal Size' or set a custom scaling percentage instead of compressing columns.
- 4. Preview and Print: Review the precise layout in the print preview window and click 'Print' for a perfect physical copy.
Frequently Asked Questions
Why do my desktop print settings not apply when using Excel for the web?
Excel for the web and the Excel desktop application handle print configurations independently. Settings saved in the desktop app, such as specific column scaling or margins, may not automatically carry over to the web browser's built-in print engine.
What scaling options are available in Excel for the web?
In the Print setup menu of Excel for the web, you can typically choose between 'No Scaling' (printing at 100% actual size), 'Fit Sheet on One Page', 'Fit All Columns on One Page', and 'Fit All Rows on One Page'.
Why does my print scaling setting keep resetting to the default?
This behavior is often tied to how your web browser stores temporary data and site preferences. Clearing your browser's cache and cookies, or trying a different supported web browser, can usually prevent the settings from resetting.
