How to Remove Grid from Excel (6 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Excel sheets have grid lines that separate cells. Sometimes, we need to Remove Grid from Excel for better data analysis. It makes the dataset clean and easier to understand. To enhance the readability, we can remove the grid from Excel. There are also various reasons why we need to remove gridlines for the sake of productive analysis.


Overview of Grid in Excel

The faint gray cells that we see in our worksheets in Excel are called Gridlines. The basic idea of Excel is to present our data in rows and columns. For this reason, the use of gridlines is very common in worksheets.

Sometimes, we use borders in our dataset. But the border and grid are different things. The grid covers the whole worksheet but the border covers only some datasets.

Gridline makes the task of data entry easier. But we need to remove it after the completion of the data entry to read it easily.


How to Remove Grid from Excel: 6 Quick Ways

Here we will show 6 methods and using these methods you can easily remove gridlines in Excel.

1. Remove Grid from Excel Using Ribbon

The easiest way to remove gridlines from the whole sheet is to use the ribbon. We can use three tabs for this purpose. They are – View, Page Layout & File tab.

To make the explanation easier, we will use a dataset of two columns here. The dataset has an Employee and a Working Hour column.

Remove Grid from Excel Using Ribbon

We will use the same dataset for every method. Our goal is to remove gridlines easily and quickly.

1.1 Using View Tab

We can see the gridlines in our worksheet.

Remove Grid from Excel Using Ribbon

We will now try to remove the grid. For that, we need to follow the steps:

STEPS:

  • Firstly, select the VIEW tab.
  • Secondly, go to Gridlines and deselect it.

Remove Grid from Excel Using Ribbon

  • Finally, the gridlines will disappear.

Remove Grid from Excel Using Ribbon


1.2 Using Page Layout Tab

We can also use the Page Layout Tab for this purpose.

STEPS:

  • Firstly, select Page Layout.
  • Then, go to the View option and deselect it.

Remove Grid from Excel Using Ribbon

  • Following the steps, we will see a gridless worksheet like below.

Remove Grid from Excel Using Ribbon


1.3 Using File Tab

There is another way where we can remove the grid from Excel using ribbon. We will demonstrate the procedure below.

STEPS:

  • Firstly, go to the FILE tab.

Remove Grid from Excel Using Ribbon

  • Secondly, select Options. An Excel Options window will appear.

Remove Grid from Excel Using Ribbon

  • Thirdly, select Advanced.
  • Then go to the Display options for this worksheet and deselect Show gridlines.

Remove Grid from Excel Using Ribbon

  • Finally, the gridlines will disappear.

Remove Grid from Excel Using Ribbon


2. Using Keyboard Shortcut to Remove Grid

Keyboard Shortcuts are very quick solutions for many tasks. We can use this to remove gridlines also.

STEPS:

  • Firstly, open your worksheet. The gridlines will automatically appear.

Using Keyboard Shortcut to Remove Grid

  • Now press Alt and enter W, V, G respectively. This will remove the gridlines.


3. Application of Background Fill to Remove Grid

Background Fill is also used to remove gridlines. It has a great advantage as it can remove the grid of specific cells. We will use the same dataset here.

STEPS:

  • Firstly, select the whole sheet and go to the HOME.
  • Secondly, select the Fill.

Application of Background Fill to Remove Grid

  • Then, gridlines will be removed just like the picture below.


4. Remove Grid for Multiple Worksheets in Excel

Removing gridlines for multiple worksheets is an easy task. Just follow the steps for quick solutions.

STEPS:

  • Press Ctrl on the Keyboard and select the worksheets.

Remove Grid for Multiple Worksheets in Excel

  • Now go to the VIEW tab from the ribbon and deselect Gridlines. Gridlines will not be visible in all worksheets.

Remove Grid for Multiple Worksheets in Excel


5. Excel VBA for Removing Grid

With VBA we can create a function to remove the grid from Excel. In this process, we need to follow some crucial steps.

STEPS:

  • Firstly, go to the DEVELOPER tab from the ribbon and select Visual Basics. A Microsoft Visual Basic window will appear.

Excel VBA for Removing Grid

  • Secondly, type the below code there.
Sub Remove_Grid()
Dim sheet As Worksheet
For Each sheet In Worksheets
sheet.Activate
ActiveWindow.DisplayGridlines = False
Next sheet
End Sub

Excel VBA for Removing Grid

  • Thirdly, save the code.
  • Now, go to Macros and run the code.

Excel VBA for Removing Grid

  • Finally, after running the code, the gridlines will be removed.


6. Remove Grid for Specific Cells in Excel

Removing the grid from specific cells in Excel is very important  We can use the Background Fill to do that. But we can also use the following procedure:

STEPS:

  • Firstly, select specific cells from your datasheet.

  • Secondly, right-click your mouse, and from the drop-down menu, select Format Cells.

  • Thirdly, go to the Border tab and change the color to white. Also, select Outline and Inside from Presets.

  • After following the above steps, just click ok. It will remove the grid for the selected cells.


Download Practice Book

Download the practice book.


Conclusion

We often need to remove the grid from Excel for simplification. I hope these methods will help you to remove gridlines easily. Lastly, if you have any queries or suggestions, feel free to comment below.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel projects.
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo