Forum Discussion

Danexet's avatar
Danexet
Copper Contributor
Jan 15, 2019

Excel - The very basics! Grey grid lines disappearing..

Hey there! Could someone please let me know why they grey grid lines disappear when you edit the contents? One or two is fine, but my spreadsheet is becoming awkward to read as the lines disappear wh...
excel
PHerrin's avatar
PHerrin
Copper Contributor
Mar 04, 2020

I am supporting a small group of Office365 business users.  One user has this problem, grid lines disappearing, with Excel on every sheet she opens.  How do I fix the formatting problem for Excel, not an individual sheet?

 

Nauthstar 

Charla74's avatar
Charla74
Iron Contributor
Mar 04, 2020

PHerrin 

 

Go to File > Options > Advanced >

Scroll down to 'Display Options for this Worksheet'

Check that 'Show Gridlines' is ticked and that you have a visible colour selected below that.

  • PHerrin's avatar
    PHerrin
    Copper Contributor
    Mar 04, 2020

    Thanks.  Will that change be applied to all new sheets when she starts Excel?

     

     

    • Charla74's avatar
      Charla74
      Iron Contributor
      Mar 04, 2020

      PHerrin 

       

      If it doesn't, open a new worksheet, make the changes as mentioned and then 'save as', change workbook name to Book and save in the XLSTART folder (path should look something like below):

       

      C:\Users\JohnDoe\AppData\Roaming\Microsoft\Excel\XLSTART

       

      When you open Excel thereafter, this should open as your default blank workbook.

Resources