Office for Mac Issues

Restore Excel Gridlines After Selecting No Borders on Mac

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

Restore visible worksheet gridlines after selecting No Borders in Excel for Mac.

Restore Excel Gridlines After Selecting No Borders on 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.
Before you start

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.

Solution 1Recommended

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.

1
Check the gridline setting

Open the View tab and make sure Gridlines is checked. You can also check View under Page Layout > Gridlines.

2
Select the affected cells

Click and drag over the cells where gridlines are missing.

3
Remove the fill color

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.

4
Check the result

Review the selected cells. If you need darker or differently styled lines, use the Borders menu on the Home tab to apply cell borders.

Remove cell fill and confirm gridlines are enabled
Gridlines and borders look different: Default gridlines may appear lighter than applied borders. Removing a fill color also removes any intentional shading from the selected cells.
Free Microsoft Office alternative

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.

View worksheet gridlines and format cell borders in WPS SpreadsheetsOpen and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday spreadsheet tasksWork with a free, lightweight office suite
QA img-9

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.