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.
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
- Secondly, go to Home > choose Cells > select Format > pick Format Cells.
- Eventually, a Format Cells window will appear.
- Thirdly, go to Border > follow the steps shown in the picture chronologically.
- Fourthly, click OK.
Consequently, we’ll see that the gridlines of the specified cells are removed like this.
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.
- Secondly, go to Home > click on the border icon in the Font box > choose No Border.
Consequently, the gridlines will be removed from the specific cells like this.
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.
- Secondly, go to Home > choose the border icon from the Font box > select No Border.
Eventually, the gridlines of all the cells are removed like this.
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.