Add/Remove Gridlines in Excel (5 Simple Ways)

The faint horizontal and vertical gray lines in Excel worksheets are known as gridlines. These horizontal and vertical lines intersect and make the cells that we see in the spreadsheets. The purposes of these cells or gridlines are to present the data in a more organized way so that the readers may easily comprehend it.

Adding and removing these gridlines is a prevalent task in Excel. Gridlines are visible by default in Excel, but there are certain situations where the user needs to get rid of them or, in some cases, add them where the sheet or workbook might come from another person who didn’t use gridlines. In this article, I have addressed all the popular ways to add or remove gridlines in Excel.

5 Ways to Add or Remove Gridlines in MS Excel

Because gridlines are added by default, I concentrated on removing them in these solutions. You may also use these methods to re-add gridlines if they have been removed.

1. Using the Fill Color tool

The Fill Color tool in Excel can be used to remove the gridlines by filling the cells with white color. Follow these steps to apply this solution:

  1. Select the cell or cells you want to remove the gridlines from.Selecting the data
  2. Go to Home and select the Fill Color tool under the Font.Selecting the Fill Color tool
  3. Select the WHITE color from the drop-down menu of the Fill Color.Selecting white color from the Fill Color tool

It will fill the cells with white color, making the cells invisible.

2. Altering the color of the gridlines

You can also remove the gridlines by changing the color of the gridlines to white. Follow these steps to apply this solution:

  1. Go to File > Options.Selecting the Options button
  2. Select Advanced from the Excel Options.
  3. Scroll down to the Display option for this worksheet.
  4. Select the worksheet you want to remove the gridlines from.
  5. Now, Select the WHITE color from the Gridline color option’s drop-down menu and click OK.Selecting white color for the gridlines

It will change the gridline’s color to white, making them invisible.

[Note: This method applies to the whole worksheet. Specific cells can’t be selected.]


3. Using the “Format Cell” option

This method applies the same technique as the Fill Color tool method. Follow these steps to apply this solution:

  1. Select the cell or cells you want to remove the gridlines from.Selecting the data
  2. Right-click on it and select the Format Cell option from there.Selecting Format Cells option
  3. A new window named Format Cell should appear. Select the Border tab from there.
  4. Select the WHITE color from the Color option’s drop-down menu.
  5. Select both the Outline and Inside option and click OK.Selecting white color

It will fill the cells with white color, making the cells invisible.

4. Using the “View” option

Follow these steps to apply this solution:

  1. Go to Page Layout.
  2. Find the Gridline section under Sheet Options.
  3. Uncheck the View checkbox.Unchecking View checkbox

Or,

  1. Go to View.
  2. Find the Gridline checkbox under the Show section.
  3. Uncheck the checkbox.Unchecking Gridline checkbox

It will hide the gridlines of the worksheet.

[Note: These methods apply to the whole worksheet. Specific cells can’t be selected.]

5. Remove gridlines using VBA

Excel has a programming language known as VBA (Visual Basic for Application). You can add a code snippet in VBA for removing gridlines. Using this method, you can remove gridlines from every worksheet in the workbook. You can use it for multiple workbooks as well.

Follow these steps to apply this solution:

  1. Go to the Developer tab. (Developer tab is not visible by default. Check the next section for enabling the Developer tab.)
  2. Select the Visual Basic option.Selecting Visual Basic option
  3. A new window should appear for VBA. Double-click on the ThisWorkbook option from the left side.
  4. Now, Copy the following code and paste it.

Sub Hide_Gridlines()

Dim ws As Worksheet

‘hide gridlines in a workbook

For Each ws In Worksheets

ws.Activate

ActiveWindow.DisplayGridlines = False

Next ws

End Sub

  1. Run the code by pressing F5 or clicking the Run.Running the the VBA code

It will remove the gridlines from all the worksheets in the workbook. This method is very handy for working with workbooks that have a large number of spreadsheets.

Steps for enabling Developer option:

  1. Go to File > Options.Selecting the Options button
  2. Select Customized Ribbon from the Excel Options.
  3. Check the Developer checkbox under the Main Tabs section and click OK.Enabling the Developer option

This will enable the Developer option.

Conclusion

Unlike borders, there is not much customization available for gridlines. You may add, remove, and modify the color of it. Although this article mainly focuses on the removal option, I have also tried to cover the other aspects. I hope you find the solution you were looking for. Please leave a comment if you have any suggestions or questions. Thank you.

Chinmoy Mondol

Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo