Excel does not show gridline by default

Question

Exact the same problem: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-gridlines-will-not-show-by-default/59f1de65-46f6-4b37-8f5a-8f88ea8079f6

Microsoft® Excel® 2019 MSO (16.0.14326.20164) 64 bit

Tried everything.

• Create a new workbook: does not show gridline by default.
• Turn on Gridline on on gridlines under View ribbon - gridline shows
  • then create a new sheet: no gridline.
• Turn on Show Gridlines in Option - Advanced Option: gridline shows
  • then create a new sheet: no gridline.
  • create a new workbook: no gridline.
• no template files (or any files) in any of my custom office template folders or XLSTART folders
  • create a template file with gridline and put it in XLSTART folder: gridline shows, but no gridline when create a new sheet.
• Repair installation: same as above, no gridline.
• Completely remove and reinstall: same as above, no gridline.
• Use SetupProd_OffScrub.exe to completely remove and reinstall: same as above, no gridline.

The only way to show default gridline is safemode (excel /safe), but safemode does not save any settings.

How can I save the "Show Gridlines" option?

How can I completely restore the default settings of Excel?

Answer 1

Hi Renzo,

Thank you for your reply.

1. Safe mode does show gridline by default.
2. No active add-in.
3. Did repair but does not work.
4. 5. Did uninstall and reinstall but does not work.

Answer 2

Hi Shane,

Thank you for your reply.

I am able to turn on gridline for one sheet and multiple sheets all at once, but when I create a new sheet or new file, there is no gridline. The expected behavior (as a brand new out-of-the-box Excel does) is to show gridlines for any new files and new sheets.

My XLSTART folder (C:\Program Files\Microsoft Office\root\Office16\XLSTART) is already empty.

Are there any other factors that affect the gridline? Configuration files, registry keys, etc?

Answer 3

Dear 俺,
I'm Renzo,, I'll help you with your question.
You could try with following process:

1. Run Excel in Safe-mode, tap and hold "Ctrl" key the open the app, should be appears a pop up window that you try to run Excel in Safe-mode, click on Yes, then check out app behavior.
2. If it's work fine, the issue could be related to an add-in in the app, you should remove the add-ins installed on the app.
   https://support.microsoft.com/ko-kr/topic/view-...
3. If previous process does not work, in search-box of Windows toolbar, type: Control Panel and open it.

Click in Programs > Uninstall a program, find Microsoft Office 365, right-click over it > click on "Change" then "Quick Repair".

If does not work, you can use an "Online Repair".

Take a look at below link for further information:
https://support.microsoft.com/ko-kr/office/repa...

4. If the error persists, you should uninstall Office with the Support tool, refer to "Option 2" in following link:
   https://support.microsoft.com/ko-kr/office/unin...

Note: before uninstall you will need the original activation "key" to install it again, or depending if your license is associated to your account.

5. Then re-start your PC and Install the last Office version from following link:
   https://support.microsoft.com/ko-kr/office/down...

Answer 4

The Gridline option under File, Options, Advanced applies to the selected sheet. If you want to apply it to all the sheets in a workbook select all the sheet tabs and execute the above command; File, Options (or More Options), Advanced, ... Show Gridlines.

If this situation occurs with all new workbooks or every time you add a new sheet, then you may need to clear the xlstart folder or add a default workbook and worksheet. I would start with clearing the xlstart folder.

The exact locations of the xlstart folders will depend on which version of Excel you are using.

1. 365 - C:\Program Files(x86)\Microsoft Office\Office16\XLStart\
2. 2019 - C:\Program Files(x86)\Microsoft Office\Office15\XLStart\
3. 2016 - C:\Program Files(x86)\Microsoft Office\Office16\XLStart[l](https://exceljet.net/how-to-set-a-default-template-in-excel)

If that doesn't work, here is an idea discussing creating your own default workbooks and worksheets:

https://exceljet.net/how-to-set-a-default-template-in-exce