'%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 Change Excel's Gray Non-Print Area to White
Question details
The user wants to remove the gray background and page watermarks from the non-printable area in Excel to restore a standard white background.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Reviewing or adjusting the page layout of a spreadsheet before printing.
- Observed behavior
- The area outside the printable range is displayed in gray, and a large 'PAGE 1' watermark is visible in the background of the cells.
The gray area and page watermarks are default visual aids used in Page Break Preview mode and cannot be recolored. To resolve this, you simply need to change your workbook's view mode.
Switch Back to Normal View
The easiest way to remove the gray background and page watermarks is to exit Page Break Preview and return to the standard spreadsheet view.
Page Break Preview is specifically designed to show you exactly what will be printed. Anything outside the print boundaries is shaded gray to indicate it will be excluded. Switching back to Normal view restores the standard infinite white grid.
Open your Excel workbook and click on the 'View' tab located in the top ribbon menu.
In the 'Workbook Views' group on the left side of the ribbon, click on 'Normal'. The gray non-print area and the 'PAGE 1' watermark will immediately disappear, returning your sheet to a standard white background.
You can also quickly switch views by clicking the 'Normal' view icon located at the bottom right corner of the Excel window, just to the left of the zoom slider.
Expand Your Print Area
If you want to stay in Page Break Preview but need the gray cells to appear white, you must include them in your active print area.
Manage Print Areas and Views Easily in WPS Office
WPS Spreadsheet offers a seamless and intuitive way to manage your workbook views, adjust print areas, and switch between Normal and Page Break Preview without any formatting confusion.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Go to the View menu: Click the 'View' tab in the top navigation ribbon.
- 3. Click Normal View: Select 'Normal' from the ribbon to instantly remove the gray non-printable area and restore the standard white cell background.
Frequently Asked Questions
Can I change the color of the non-print area in Page Break Preview?
No, Excel and most spreadsheet software do not allow you to customize the color of the non-print area. It is permanently set to gray to clearly distinguish it from the white printable area.
How do I remove the 'PAGE 1' watermark in Excel?
The 'PAGE 1' watermark is a built-in feature of the Page Break Preview mode. To remove it from your screen, simply switch your workbook view back to 'Normal' under the View tab. Note that this watermark will never appear on printed documents.
Why did my Excel background suddenly turn gray?
Your workbook view likely changed to Page Break Preview by accident. You can easily fix this by clicking the 'Normal' view icon located at the bottom right corner of your Excel window, next to the zoom slider, or by selecting 'Normal' from the View tab.
Will the gray background show up when I print the document?
No, the gray background and the blue page break lines are only on-screen visual aids to help you format your layout. They will not appear on the final printed paper.
