Show Excel Gridlines After Highlighting Cells on Mac
Question details
The user wants to restore worksheet gridlines after highlighting cells or rows in Excel for Mac without adding borders.

- 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.
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.
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.
Open the affected worksheet, select the View tab, and check Gridlines.
Select the cells or rows where gridlines are missing.
On the Home tab, open the Fill Color menu and choose No Fill. Do not choose white, because white is still a fill color.
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.
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. Open the workbook: In WPS Spreadsheet, open the Excel workbook and select the affected worksheet.
- 2. Show gridlines: On the View tab, enable Gridlines if they are turned off.
- 3. Select the cells: Select the highlighted cells or rows where the gridlines are hidden.
- 4. Remove the fill: On the Home tab, open the Fill Color menu and choose No Fill.

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.




