How to Add, Change or Remove Gridlines in Excel

Gridlines provide a visual reference of the cells in an Excel spreadsheet. You can choose to remove them or modify them for your spreadsheet.

This guide will show you how to add, change or remove gridlines in Excel. In addition, I will show you how to include gridlines if you want to print your spreadsheet.

I will be using the Office 365 version of Excel (build 2203). However, the instructions are similar in other versions.

Adding and Removing Gridlines

1. From the top menu, click on the View tab.

   

2. Navigate to the Show section and Deselect the Gridlines option to remove gridlines from your spreadsheet.

   

   The gridlines are now removed.

   

   Alternatively, you can Select the gridlines option to re-add them.

How to Change Gridline Color

Gridlines are a primary function in Excel, and you cannot apply that many changes to them. However, you can change their color by following these steps:

1. Open the File tab from the top menu.

   

2. Select Options from the side menu.

   

   This will open the Excel Options tab. This interface allows you to change various default options.

   

    

3. Open Advanced options from the left.

   

   Navigate to the Display Options section. From here, you can select your desired Gridline color.

   

4. Select your desired color and click on OK.

   

   Your gridline color is now changed.

   

How to Print Gridlines in Excel

1. Navigate to the Page Layout tab from the top menu.

   

2. From the Sheet Options section, under Gridlines, select Print.