Formatting Issues

Fix Missing Colors and Borders in Excel Worksheets and Printouts

Algirdas JasaitisAlgirdas Jasaitis Nov 12, 2026 868 views

Question details

The user needs to troubleshoot worksheet colors that are not visible and lines, boxes, or borders that do not appear when an Excel worksheet is printed.

Fix Missing Colors and Borders in Excel Worksheets and Printouts
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is reviewing a formatted worksheet on screen or preparing it for printing.
Observed behavior
Cell font colors or fill colors may appear missing, and gridlines or cell borders may be absent from the printed output.
Before you start

Open the affected worksheet and use Print Preview to compare the worksheet display with the expected printed result. Select an affected cell so you can inspect its font, fill, and border settings.

Solution 1Recommended

Check cell font, fill, and conditional formatting

Use this solution when text or cell background colors are missing or different from the expected worksheet formatting.

A cell can appear blank when its font color matches the background, its fill is set to No Fill, or a conditional-formatting rule overrides the regular cell format.

1
Inspect the font color

Select an affected cell, go to Home, and open the Font Color drop-down. Choose Automatic or a visible color instead of white or a color matching the cell background.

2
Set a visible fill color

With the cell selected, go to Home > Fill Color and select the intended background color. Verify that the cell is not set to No Fill.

3
Review conditional-formatting rules

Go to Home > Conditional Formatting > Manage Rules. Confirm that the rule applies to the intended cell range, its condition is currently met, and its format uses visible font and fill colors.

4
Check the worksheet view and zoom

Go to View > Normal and adjust the zoom control in the lower-right corner. This helps confirm that the issue is not caused by a page view or very small display scale.

Check cell font, fill, and conditional formatting
Conditional formatting can override manual formatting: If a conditional-formatting rule applies to a cell, its font or fill settings can take precedence over the color you selected manually.
Format and print worksheets in WPS Office

Restore worksheet colors and print borders with WPS Spreadsheets

WPS Spreadsheets lets you inspect font and fill formatting, manage conditional formatting, add visible borders, and configure worksheet gridlines before printing. Its familiar spreadsheet interface makes it easy to open and correct Excel workbooks without changing the layout you need.

  1. 1. Open the Excel workbook: In WPS Office, select Open and choose the affected .xlsx or .xls workbook.
  2. 2. Check colors and conditional formatting: Select the affected cells, then use the Home tab to review Font Color, Fill Color, and Conditional Formatting settings.
  3. 3. Add visible borders: Select the required range and choose Home > Borders, then apply All Borders or open More Borders to set the line style and color.
  4. 4. Set gridline print options: Open Page Layout and enable the worksheet Gridlines print option when gridlines, rather than borders, are needed in the output.
  5. 5. Preview and print the worksheet: Choose Menu > Print to inspect the print preview, then print or save the corrected worksheet as a PDF.
Edit font colors, fills, conditional formats, and cell borders in one spreadsheet workspace.Configure printable gridlines and review the result before printing.Open and edit Microsoft Excel .xlsx and .xls files with strong format compatibility.Use a lightweight, free office suite with a familiar spreadsheet interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why are the colors in my Excel cells not showing?

Select the affected cell and check Home > Font Color and Home > Fill Color. Also open Home > Conditional Formatting > Manage Rules, because an active rule can replace the cell's normal colors.

Why do Excel gridlines show on screen but not on paper?

Gridlines do not print by default. Go to Page Layout > Sheet Options and select Print under Gridlines, then verify the output in File > Print.

Should I use gridlines or borders for a printed Excel table?

Use borders for tables, forms, and boxed sections that must print reliably. Apply them from Home > Borders; use gridlines only for general worksheet guidance.

How do I make invisible Excel borders visible again?

Select the affected cells, choose Home > Borders > More Borders, and select a visible border color and line style. Apply the border to the appropriate cell edges and check Print Preview.

Can conditional formatting make a cell fill disappear?

Yes. A conditional-formatting rule can override a manually applied fill or font color. Review rules through Home > Conditional Formatting > Manage Rules and confirm the correct range and rule order.