• Excel Video Tutorials

Excel - Format Grids


Whenever you open the Excel worksheet, gridlines are automatically displayed to separate the rows and columns partitioning each cell, which allows you to read the dataset more clearly. You can also hide these gridlines, which display the worksheet as a single report page similar to an MS Word page. Gridline color, which is Automatic by default, can also be modified in the specific worksheet.

Hide the Gridlines in Microsoft Excel Worksheet

Given below are the steps to hide the gridlines in a specific worksheet −

  • You may select the "Sheet5" worksheet in the Microsoft Excel.
  • Click the File tab, select the More category, and then choose the Options from the drop-down menu.
How to hide the Gridlines in the Microsoft Excel worksheet

Another "Excel Options" dialog box will appear. You can choose the "Advanced" category and uncheck the "Show gridlines" option in the "Display options for this worksheet". After that, click on the OK button.

Advanced Category in Excel Options

Therefore, the gridlines are hidden in the Microsoft Excel worksheet.

Hidden Gridlines in Microsoft Excel worksheet

The Alternative way to hide the gridlines in the Microsoft Excel worksheet is to navigate to the "View" tab and deselect the "Gridlines" checkbox under the "Show" group.

Alternative Way to Hide Gridlines in Microsoft Excel

Change the Color of Gridlines

You may alter the color of the gridlines only in these Microsoft Excel versions: Excel 2019, Excel 2016, Excel 2021, and Excel for Microsoft 365.

The following steps are written below −

Step 1 − First, make the active worksheet a Sheet 5.

Step 2 − After that, you can choose the File tab and click on the "More" category, and then select "Options" from the menu.

How to Change the color of the gridlines

Step 3 − In the "Excel Options" dialog box, you may select the "Advanced" category. Furthermore, expand the "Gridline Color" tile and select the "Sea Green" color from the given list of colors under the "Display options for this worksheet" section. After that, click on the OK button.

Change the color of the gridlines

Gridline Color Changed from Automatic to Green

As you can notice in the screenshot, the gridline color has been changed from Automatic to Green.