Excel Gridlines are Not Showing by Default – 3 Solutions

This is the sample dataset. There is no gridline in the Excel sheet.

excel gridlines not showing by default


Solution 1 – Enabling the Show Gridlines Option

Steps:

  • Go to the View tab.
  • Check Gridlines.

Your workbook will display the gridlines.

excel gridlines not showing by default

 


Solution 2 – Using a Suitable Color to Show Gridlines

Steps:

  • Go to the File tab.

The Gridlines option is checked but they aren’t visible.

  • Select Options.

excel gridlines not showing by default

  • In the Options window, select Advanced.
  • Go to Display options for this worksheet and select Gridline color. It is set to White. Choose a color.
  • Click OK.

Gridlines will be visible.

excel gridlines not showing by default

Read More: How to Show Gridlines after Using Fill Color in Excel


Solution 3 – Repair or Reinstall Office 365

Steps:

  • Open the Excel workbook in Safe Mode: select the Excel workbook, press and hold the CTRL and press ENTER.
  • In the dialog box asking if you want to open the application file in Safe Mode, click Yes.

The Excel sheet displays gridlines.

If the above steps fail, repair your Office software:

  • Open the Control Panel.
  • Select Uninstall a Program.

excel gridlines not showing by default

  • Select Microsoft 365 Apps and right-click it.
  • Select Change.

  • In the new window, you will see two options: Quick Repair and Online Repair. Select either one.
  • If the above process doesn’t work, you need to uninstall Microsoft 365 Apps, install them again (you need the original activation key) and restart your computer.

Download Practice Workbook


Related Articles


<< Go Back to Show Gridlines | Gridlines | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo