How to Make Page Numbers Lighter in Excel Page Break Preview
Question details
The user wants to adjust the color, brightness, or opacity of the large page number watermarks displayed in Excel's Page Break Preview mode.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing spreadsheet layouts in Page Break Preview to manage print settings.
- Observed behavior
- The background page numbers (e.g., 'Page 1') appear too dark or obstructive, and there is no direct setting available in Excel to change their appearance.
Check your monitor's hardware brightness and contrast settings, as physical display configurations can heavily influence how background watermarks are rendered on your screen.
Change the Microsoft Office Theme
Switching to a different Office theme can alter the overall contrast of Excel's interface, sometimes making the page break watermarks appear lighter.
Excel does not provide a dedicated setting to adjust the opacity of the Page Break Preview numbers. However, the overall Office Theme affects how these elements are displayed.
Launch Microsoft Excel, click on the 'File' tab in the top left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, ensure the 'General' tab is selected on the left pane.
Scroll down to the 'Personalize your copy of Microsoft Office' section. Click the dropdown menu next to 'Office Theme' and select 'White' or 'Light Gray'.
Click 'OK' to save the changes. Switch back to Page Break Preview to see if the contrast of the page numbers has improved.

Display Page Breaks in Normal View
If the large page numbers in Page Break Preview remain too distracting, you can display page break lines in Normal view instead.
Adjust System Graphics Settings
Modifying your computer's display gamma or contrast settings can globally lighten the appearance of gray elements on your screen.
Try WPS Office for a Better Spreadsheet Experience
If Excel's display limitations are frustrating, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment that perfectly handles complex layouts and printing configurations.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Microsoft Excel files directly without losing any formatting.
- 3. Use Page Layout Tools: Navigate to the View tab to easily manage your page breaks and print layouts in a clean environment.

Frequently Asked Questions
Can I completely hide the page numbers in Excel's Page Break Preview?
No, Microsoft Excel does not provide a built-in option to turn off or hide the large page number watermarks while using the Page Break Preview mode. To avoid seeing them, you must switch to Normal view or Page Layout view.
Will the large page numbers print on my final document?
No, the large 'Page 1' or 'Page 2' watermarks seen in Page Break Preview are strictly for on-screen layout assistance. They will not appear on your printed documents or exported PDFs.
Why do the page numbers look darker on my new monitor?
The darkness of gray watermarks in Excel is heavily influenced by your monitor's contrast, brightness, and gamma calibration, as well as your computer's graphics drivers. Adjusting your monitor's physical settings can often lighten the text.




