Excel Gridlines

1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9

How to remove a grid in Excel completely and partially

The Excel workspace is a table that consists of columns, rows, and cells. Visually everything is displayed as an entire grid. In some tasks when creating document forms or for creating special templates and interfaces, the grid interferes and needs to be removed.

Hiding the sheet grid

In all new versions of Excel, starting from 2007, the gridlines can be disabled from the toolbar: «VIEW». In the «Show» section you need to uncheck the «Gridlines» option.

There are two more ways to remove the grid Excel table:

Program settings. «FILE»-«Options»-«Advanced»-«Display options for this worksheet:» remove the checkmark from the option «Show gridlines».
Press the combination of hot keys CTRL + A to select all the cells in the sheet. On the tab of the «HOME» tool bars, select the «Theme Colors» tool and specify the white color. To return the gridlines, you must select everything again and change it from white to «No Fill». This method will remove the grid in any version of Excel.

The second way is interesting because it can partially (selectively) remove the gridlines.

You need to select not a whole sheet, but the ranges in those areas of the document where you want to remove the Excel grid. The truth for beauty will need to change the extreme boundaries of cells. The default colour code for the cells of the grey background gridlines is:

RGB (218, 220, 221);
HTML #DADCDD.

Note. The cell borders change in the «Format Cells» dialog box on the «Borders» “Borders” tab, and press CTRL + SHIFT + F (or CTRL + 1) to call it.

Excel Gridlines

Gridlines in Excel can be activated from the Excel Option’s Advanced tab. Therefrom, the Display option for the worksheet, check the box of Gridlines. We can also select the color of the gridlines we want in Excel worksheets. Once we print the sheet or see the print preview of any worksheet, we will see the gridlines for the data that is ready to print. We do not have to insert the lines by own self. This helps when we frequently want to print the data or share the data with other people in a different format.

In excel, we can find the gridlines under the “VIEW” menu and also in the “PAGE LAYOUT” menu.

Excel functions, formula, charts, formatting creating excel dashboard & others

Gridlines in VIEW menu:

The option for gridlines is under the View menu in Excel; for adding or removing gridlines in a sheet, as shown in the screenshot below.

Gridlines in Page Layout menu:

In Microsoft Excel, we can find the gridlines option under the page layout menu to add or remove the gridlines in a sheet while taking a printout, shown in the below screenshot.

How to Add and Remove Gridlines in Excel?

Gridlines in Excel is very simple and easy. Let’s understand the working of Gridlines in Excel with some examples.

You can download this Gridlines Excel Template here – Gridlines Excel Template

Example #1

In this example, we will see how to add and remove Excel gridlines for the specific sheet. If we open a new workbook, we can notice that all the sheets will contain grid lines which are shown below.

We can see that the entire sheet contains light grey lines, which separate this as rows and columns. We can edit and add thick borders to these gridlines, or we can remove the gridlines by disabling the gridlines option by following the below steps.

First, select the entire blank sheet. Go to the view menu, where we can find the gridlines option. We can see that the checkmark has been enabled for the gridlines option. Remove the checkmark for the gridlines so that the entire sheet gridlines will be removed.

Result:

In the below screenshot, we can see that gridlines have been removed, and it shows plain white paper where we can take a printout without grid lines. Similarly, we can bring back the grid lines for the sheet by enabling the gridlines option in the View menu or the page layout menu.

Example #2

Adding Gridline to the specific sheet

Let’s consider the below example, which shows the expenses data, which contains rows and columns as shown below.

In the above screenshot, we can see that grid lines separate the expenses sheet by rows and columns; we can add or remove the grid lines by following the below steps.

First, select the data.

Go to the home menu and add a border to the gridline, as shown below.

Once we click on the borders, the selected data will be filled with borders, as shown below.

We can see that expenses data has been filled with borders that give a good view, but the outer sheet contains gridlines; we can hide the outer part of the grid lines by following the below steps.

First, select the entire sheet as shown below.

Go to the View menu, where we can find the gridlines option. Remove the checkmark for the grid line option as shown below.

In the above screenshot, we can see that the gridlines option has been disabled, which removes the grid line for the full sheet of the outer part, which is shown as the screenshot in the below result.

Result:

In the below screenshot, we can see that the outer part of the sheet has no grid lines, and only the specific row and column has the grid lines border. This kind of view will make the sheet to view the data in a professional way.

Example #3

Adding Color to the Excel Gridlines

In this example, we will see how to add color to the grid lines by following the below steps.

First, open a new workbook. We will get a sheet with gridlines in a light grey color. Go to the Home menu, where we can find the Border under the font group and get the list of border styles shown below. Choose a line color from the border list.
Once we click on the line color, we will get the standard and theme color for color selection, as shown below.

Choose a specific line color; for example, we will choose green.
Go to the same border option and click “Draw Border Grid”, which is shown below.

Now draw the border grid in the specific area where we will get the grid border in the selected green color.

Result:

The screenshot below shows that the grid line has been filled with green for the specific rows and columns.

Example #4

Print Gridlines in Excel

In this example, we will see how to add and remove grind lines while printing the data. Consider the below example, which shows expenses data which is shown below.

Now we can add or remove print gridlines by following the below steps.

First, select the entire worksheet. Go to page layout. In page layout where we can see the grid lines under the “Sheet Option” Group
Enable the Gridlines by check-marking the print option shown in the screenshot below.

Use CTRL+P or go to the File menu and give a print. Once we give print, we will get the below print options dialog box which is shown below.

In the print option, we can see the preview on the right-hand side, where we can see the gridlines with light dotted lines which are highlighted below.

Hit the print button to get the print with grid lines, and in the same way, we can hide the print gridlines by disabling it or removing the tick mark from the checkbox.

Things to Remember About Gridlines in Excel

In Excel, we can easily remove the gridlines by removing the checkbox in the view menu.
You can add or remove gridlines in Excel using the keyboard shortcut ALT+W+V+G.

Excel Gridlines

How to remove a grid in Excel completely and partially

Hiding the sheet grid

Excel Gridlines

How to Add and Remove Gridlines in Excel?

Example #1

Example #2

Example #3

Example #4

Things to Remember About Gridlines in Excel

Recommended Articles

Related posts: