Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Remove Specific Gridlines in Excel (2 Useful Ways)

If you are looking for how to remove specific gridlines in Excel, then you are in the right place. In our practical life, we often need to use Excel where we need to remove gridlines of specific cells for different purposes. In this article, we’ll try to discuss how to remove specific gridlines in Excel.


Download Practice Workbook


2 Ways to Remove Specific Gridlines in Excel

There are a couple of easy ways to remove gridlines in Excel. To show this, we have made a dataset named Dataset to Remove Gridlines. The dataset is like this.

how to remove specific gridlines in excel

Let’s see how we can remove specific gridlines in Excel.


1. Using Format Cells Option

We can remove gridlines using the Format Cell option.

  • Firstly, select the cells whose gridlines we want to remove. In this case it is B4:D15

how to remove specific gridlines in excel, using Format Cells

  • Secondly, go to Home > choose Cells > select Format > pick Format Cells.

how to remove specific gridlines in excel, using Format Cells

  • Eventually, a Format Cells window will appear.
  • Thirdly, go to Border > follow the steps shown in the picture chronologically.
  • Fourthly, click OK.

how to remove specific gridlines in excel, using Format Cells

Consequently, we’ll see that the gridlines of the specified cells are removed like this.

how to remove specific gridlines in excel, using Format Cells

Read More: How to Remove Gridlines from Table in Excel (2 Examples)


2. Utilizing No Border Feature

Using the No Border option from the Font box in the Home tab is another way to remove gridlines.

  • Firstly, select the specific cells of B5:D15.

how to remove specific gridlines in excel, using No Border

  • Secondly, go to Home > click on the border icon in the Font box > choose No Border.

 using No Border

Consequently, the gridlines will be removed from the specific cells like this.

 using No Border

Read More: How to Remove Gridlines in Excel Pivot Table (with Easy Steps)


Remove Gridlines from Worksheets

We can remove gridlines from the entire worksheet very easily.

  • Firstly, select the icon located in the top-left corner of the worksheet shown in the picture below.
  • Eventually, by doing this we have selected all the cells in the worksheet.

from worksheet

  • Secondly, go to Home > choose the border icon from the Font box > select No Border.

from worksheet

Eventually, the gridlines of all the cells are removed like this.

from worksheet

Read More: How to Remove Gridlines in Excel When Printing (6 Easy Ways)


Conclusion

We can easily remove gridlines from specific cells of all the cells of the worksheet very easily if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.


Related Articles

Towhid

Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo