Restore Excel Gridlines After Selecting No Borders on Mac
Question details
Restore visible worksheet gridlines after selecting No Borders in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A user removes cell borders and wants the underlying worksheet gridlines to remain visible.
- Observed behavior
- Cells appear white after No Borders is selected, even though gridlines are enabled. Applying No Fill may restore gridlines with a different appearance.
Open the affected worksheet and identify the cells where gridlines are missing. Check whether those cells have a white or other fill color, since filled cells can hide gridlines.
Remove cell fill and confirm gridlines are enabled
Use this approach when gridlines are enabled but cells still look white after borders are removed.
Borders are cell formatting, while gridlines are worksheet display guides. Selecting No Borders removes applied borders but does not remove a cell's fill color.
Open the View tab and make sure Gridlines is checked. You can also check View under Page Layout > Gridlines.
Click and drag over the cells where gridlines are missing.
On the Home tab, open the Fill Color menu and select No Fill. The worksheet gridlines should become visible if cell fill was hiding them.
Review the selected cells. If you need darker or differently styled lines, use the Borders menu on the Home tab to apply cell borders.

Test the data in a new Excel workbook
Try a new workbook if gridlines are enabled and removing the fill does not resolve the display.
View and edit spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with cell formatting as you transition between office suites.

Frequently Asked Questions
Why are gridlines missing even though Gridlines is checked?
A cell fill, including white fill, can hide worksheet gridlines. Select the affected cells and choose Home > Fill Color > No Fill.
Does No Borders turn off worksheet gridlines?
No. No Borders removes applied cell borders; gridlines are controlled separately on the View tab or under Page Layout > Gridlines.
Why do restored gridlines look different from my old cell lines?
Worksheet gridlines are display guides and may be lighter than applied borders. To add a specific line style, select the cells and use Home > Borders.
What should I do if No Fill does not restore the gridlines?
Create a blank workbook with File > New, enable Gridlines on the View tab, and paste the affected data using Paste Special > Values. If gridlines appear there, test rebuilding the formatting in the new workbook.




