Formatting Issues

Show Excel Gridlines After Highlighting Cells on Mac

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user wants to restore worksheet gridlines after highlighting cells or rows in Excel for Mac without adding borders.

Show Excel Gridlines After Highlighting Cells on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user has highlighted cells or rows in an Excel table and wants to see the worksheet gridlines.
Observed behavior
Gridlines disappear from the highlighted cells or rows.
Before you start

Open the affected worksheet and check whether the highlighted cells have a fill color or are formatted as part of an Excel table. Gridlines are not visible through cell fill, including white fill.

Solution 1Recommended

Enable gridlines and remove cell fill in Excel for Mac

Use this method to show worksheet gridlines without adding borders.

Excel does not display worksheet gridlines over cells with a fill color. To see the actual gridlines, you must remove the fill; enabling gridlines alone will not make them appear over highlighted cells.

1
Enable gridlines

Open the affected worksheet, select the View tab, and check Gridlines.

2
Select the highlighted cells

Select the cells or rows where gridlines are missing.

3
Remove the fill

On the Home tab, open the Fill Color menu and choose No Fill. Do not choose white, because white is still a fill color.

4
Check table or conditional formatting

If color remains, select a cell in the table and review its style on the Table Design tab. Also check Home > Conditional Formatting > Manage Rules for rules that apply fill to the affected cells.

Keeping the highlight: If you need to keep the cell fill and show lines around the cells, borders are an alternative, but they are not worksheet gridlines.
Work with spreadsheets in WPS Office

Show worksheet gridlines in WPS Spreadsheet

Open your workbook in WPS Spreadsheet, enable gridline display, and remove cell fill where it hides the lines.

  1. 1. Open the workbook: In WPS Spreadsheet, open the Excel workbook and select the affected worksheet.
  2. 2. Show gridlines: On the View tab, enable Gridlines if they are turned off.
  3. 3. Select the cells: Select the highlighted cells or rows where the gridlines are hidden.
  4. 4. Remove the fill: On the Home tab, open the Fill Color menu and choose No Fill.
Show worksheet gridlines without adding cell bordersOpen and edit Microsoft Excel XLSX filesUse familiar spreadsheet formatting controlsWork with spreadsheets in a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why are gridlines missing even though Gridlines is enabled?

A cell fill can hide gridlines. Select the affected cells, then choose Home > Fill Color > No Fill.

Can I keep a highlight color and show Excel gridlines through it?

No. Excel does not show worksheet gridlines through a cell fill. You can remove the fill to restore gridlines or use borders if you need to keep the color.

Does white fill let gridlines show?

No. White is still a fill color. Choose No Fill from the Home tab's Fill Color menu instead.

What if the color returns after I remove the fill?

Check Home > Conditional Formatting > Manage Rules for a rule applying the color. If the cells are in an Excel table, select a table cell and review the style on the Table Design tab.