Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

How To Remove Gridlines In Excel

Gridlines are light grey color lines that show up between rows and columns. These lines make it easier to distinguish the content of adjacent cells. But if we design application interfaces or templates sometimes these gridlines can have a negative effect on the appearance. In this lesson I will show you how to remove these gridlines from an Excel sheet.

Here is a simple data entry application interface designed on an Excel sheet.

Sample data entry application interface

We have used a fill color and outlines for the data input area. But we can further improve the appearance if we remove the gridlines.

To remove the gridlines, first go to the “VIEW” tab of the Excel ribbon.

Go to the View tab

In the “Show” group, uncheck the “Gridlines” checkbox.

Uncheck Gridlines checkbox

This is how the application interface looks like after removing the gridlines.

Final appearance of the application interface

Contact Form


Email *

Message *