How to remove gridlines in Excel – 3 easy methods

Here are three methods to remove gridlines in Excel!

Reviewed By: Kevin Pocock

Last Updated on February 23, 2024
Learn how to remove gridlines in Excel
You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

If you want to learn how to remove gridlines in Excel, we’ve got your back.

Gridlines are automatically added to all documents made in Excel. While they make it easier to read through certain documents, there may be instances where you would like to remove them. However, the process of removing gridlines in Excel can be tricky, especially for those who are new to the tool.

This is where we come in. In this guide, we are going to explain how to remove gridlines in Excel using three different methods.

1

How to remove gridlines in Excel through dedicated button

Here’s how you can quickly remove gridlines from your Excel sheet using a dedicated button.

Step

1

Open the document

Open up the document you would like to edit in Excel.

Step

2

Go to the View tab

Now, go to the View tab.

Remove Gridlines In Excel to create a clean and professional-looking spreadsheet.

Step

3

Untick the box

To hide the gridlines in Excel, untick the box next to Gridlines. This will be the result:

Learn how to create a table in Excel quickly and easily.

To bring back the gridlines, you just have to tick this box again.

2

How to remove gridlines in Excel through fill color

Alternatively, you can also use the fill color option to hide gridlines in Excel.

Step

1

Go to the Home tab

After opening your sheet, go to the Home tab.

Step

2

Select the cells

Select the cells from which you want to remove the gridlines. Or, you can select the entire sheet by pressing CTRL + A.

Step

3

Change the fill color

Now, click on the fill color icon, and select the white color.

Learn how to create a personalized name in Excel by customizing the gridlines.

This will remove the gridlines from your sheet in Excel.

3

How to remove gridlines from specific cells

In case you want to remove gridlines from specific cells in Excel, follow these steps.

Step

1

Select the cells

First, open your document and select the cells.

Step

2

Go to Format Cells

Next, right-click on the cells, and select Format Cells.

Learn how to easily create a pivot table in Excel.

Step

3

Adjust the settings

Now go to the Border tab, and select Outline and Inside under Presets. Then, select the white color in the Line box.

Learn how to remove gridlines in Excel

Once done, click OK, and the gridlines will be gone.

Learn how to remove gridlines in Excel

Final Thoughts 

In our guide on how to remove gridlines in Excel, we have mentioned a total of three methods. All of them work flawlessly and will help you get rid of the gridlines from your sheet. If you want to remove them from the entire sheet, you can opt for the first two methods. And if you want to make the changes to specific cells only, follow the third method.

Learn more about Excel through these helpful guides:

Kevin is the Editor of PC Guide. He has a broad interest and enthusiasm for consumer electronics, PCs and all things consumer tech - and more than 15 years experience in tech journalism.