My MS Excel Gridlines Have Disappeared

Have you ever opened an Excel spreadsheet and discovered that the gridlines were missing?  Here are four possible reasons that gridlines are not visible in MS Excel.

  1. The gridlines may be turned off
    Click on the View tab, then check the box for Gridlines in the Show group.

    Excel gridlines 1a      

  2. They are colored over
    If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Select the cells that are missing the gridlines, or hit Control + A to select the entire worksheet. Then, under the Home tab in the Font group change the color of the cells by clicking on the little arrow to the right of the can of spilling paint and choosing no fill.

    Excel gridlines 2a

  3. The borders have been colored white
    Select the affected cells, or select everything with Control + A, then right click on the cells and choose Format Cells

    Excel gridlines 3a

    Under the border tab, change the Color to Automatic.

    Excel gridlines 3b

  4. The gridlines have been colored white
    Click on the File tab. Then choose Options.

    Excel gridlines 4a

     Click on Advanced. Scroll down to the Display options for this Worksheet section, and change the Gridline color to Automatic. Click OK.

    Excel gridlines 4c

Thanks to Kim Beaumont for the great tip! 

This article was posted on March 3, 2016, in Office, Tips.