How to Remove Gridlines in Excel for Specific Cells (2 Methods)

Excel has horizontal and vertical gray lines called Gridlines. Gridlines separate one cell from another. Here’s an overview of what a table looks like without gridlines.

Gridlines removed from specific cells in Excel

Method 1 – Removing Gridlines from Specific Cells Using Format Cells in Excel

Steps

Select the entire range of cells from which you want to remove the gridlines.

Selection of Specific Cells in Excel to Remove Gridlines from Them

Go to the Home tab.

The Home Tab in Excel

Choose the Format Cells option from the Format dropdown. This opens the Format Cells dialog box.

Format Cells Dialog Box in Excel to Remove Gridlines from Specific Cells

From the Border tab in the dialog box, choose white from the Theme Colors in the Color field.

Changing Gridline Color to White to Make Them Hidden in Excel

The selected cells will look as follows.

Gridlines Removed from Specific Cells Using Cell Formatting

Method 2 – Hiding Gridlines from Specific Cells in Excel Using Background Fill

Steps

Select the cells from which you want to hide the gridlines.

Selection of Specific Cells in Excel to Remove Gridlines from Them

From the Home tab, click on the Fill Color tool.
Choose the fill color as white from the Pattern Color box.

Changing Background Fill Color of Specific Cells to White to Hide the Gridlines

This removes gridlines from the selected cells.

Gridlines Hidden from Specific Cells in Excel using Fill Color

How to Remove Gridlines from Excel Worksheets and Workbooks

Single Worksheet:

Go to the worksheet.
From the Page Layout tab, uncheck the checkbox for Gridlines.

Remove Gridlines fron an Entire Worksheet Using the Page Layout & the View tabs

Alternatively:

Select the arrow at the starting point of row and column headers. This will select the entire worksheet.
Change the fill color to white using the fill color tool.

Remove Gridlines from an Entire Worksheet by Changing the Background Color to White

Another alternative:

Go to File and then to Options.
From the Advanced tab, scroll down to Display options for this worksheet.
In the dropdown, choose the worksheet you want to modify.
Uncheck the box for Gridlines or change the Gridline color to white.

Hide Gridlines from a Particular Worksheet using the Advanced Settings in Excel

Multiple Worksheets or Entire Workbook:

Holding the SHIFT key, select the last worksheet tab. This will select all of the worksheets.
Follow any of the above methods to remove gridlines from them altogether.

Remove Gridlines from All or Multiple Worksheets