How to Make a Dark Excel Worksheet Print Clearly
Question details
The user needs to print an Excel worksheet that currently has a dark background, making the printed text illegible.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing a Petty Cash Log created from a dark-themed Excel template.
- Observed behavior
- The printed output is too dark to read due to the template's dark background formatting and incompatible font colors.
Before altering the layout, you may want to save a separate copy of the spreadsheet so you can retain the original dark template design for your digital records.
Adjust Worksheet Fill and Table Design
Remove the dark fill color and select a lighter table style to ensure the printed document is perfectly legible.
Digital templates often use heavy background colors that look good on screen but result in muddy, unreadable printouts. Stripping the background color and utilizing a lighter table style will restore print readability.
Highlight the cells containing your data (for example, A1:J12) that have the dark formatting applied.
Go to the Home tab on the ribbon, click the drop-down arrow next to the Font Color button, and select 'Automatic' to restore default text colors.
Click the drop-down arrow on the Fill Color button (located on the Home tab) and select 'No Fill'.
Select your specific table area (for example, B5:I11). Navigate to the Table Design tab and choose a table style with a light background from the gallery.

Use the 'Black and White' Print Setting
Force Excel to ignore background colors during printing without changing your document's actual formatting on the screen.
Format and Print Spreadsheets Clearly with WPS Office
WPS Spreadsheet provides intuitive table formatting and print preview tools, allowing you to quickly transform dark templates into crisp, print-friendly documents without hassle.
- 1. Open the Spreadsheet: Launch WPS Office and open your dark-themed Excel template.
- 2. Clear Dark Formatting: Highlight your data cells, go to the Home tab, and set the Fill Color to 'No Fill'.
- 3. Apply a Light Table Style: Select the data table, click on the Table Tools tab, and pick a light, pre-designed style.
- 4. Preview and Print: Go to Menu > Print > Print Preview to verify readability, then click Print to finish the task.

Frequently Asked Questions
Why does my Excel template print so dark?
Many digital templates use dark backgrounds for modern screen viewing. However, standard printers attempt to replicate these dark colors using heavy ink or toner, which results in illegible text if the font color doesn't have a high enough contrast against the background.
Will changing the table style delete or alter my data?
No, changing the table style from the Table Design tab only updates the visual formatting, such as fill colors, font colors, and borders. Your underlying data and formulas remain completely unchanged.
What does the 'Automatic' font color setting do?
The Automatic font color setting tells the application to adjust text color based on the background. It generally changes text to black on a light background and white on a dark background, ensuring optimal visibility.
Is there a way to print without background colors automatically?
Yes, you can configure the print job to ignore all background formatting by going to Page Layout > Page Setup > Sheet tab, and checking the 'Black and white' box. This is a great alternative if you want to keep the digital file dark.




