Printing Problems

How to Make a Dark Excel Worksheet Print Clearly

Steven ParkerSteven Parker Nov 10, 2026 869 views

Question details

The user needs to print an Excel worksheet that currently has a dark background, making the printed text illegible.

How to Make a Dark Excel Worksheet Print Clearly
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 you start

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.

Solution 1Recommended

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.

1
Select the affected area

Highlight the cells containing your data (for example, A1:J12) that have the dark formatting applied.

2
Change font color

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.

3
Remove background fill

Click the drop-down arrow on the Fill Color button (located on the Home tab) and select 'No Fill'.

4
Modify table style

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.

Adjust Worksheet Fill and Table Design
Always verify before printing: Press Ctrl + P to open the Print Preview. This ensures your newly selected light background and font colors are easily readable before you use any printer ink.
Easily Manage Spreadsheet Formatting

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. 1. Open the Spreadsheet: Launch WPS Office and open your dark-themed Excel template.
  2. 2. Clear Dark Formatting: Highlight your data cells, go to the Home tab, and set the Fill Color to 'No Fill'.
  3. 3. Apply a Light Table Style: Select the data table, click on the Table Tools tab, and pick a light, pre-designed style.
  4. 4. Preview and Print: Go to Menu > Print > Print Preview to verify readability, then click Print to finish the task.
Easily switch between hundreds of built-in light table stylesFully compatible with Microsoft Excel (.xlsx) formatsAccurate Print Preview ensures your document prints exactly as expectedLightweight, fast, and completely free to download and use
microsoft office alternative - wps office

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.