Excel Gridlines (Table of Contents)
Gridlines in Excel
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 gridlines which we want to see 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 quite 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.
Gridlines in VIEW menu:
The option for gridlines in excel can be found under the View menu, where we can add or remove the gridlines in a sheet which is shown in the below screenshot.
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 print out, shown in the below screenshot.
How to Add and Remove Gridlines in Excel?
Gridlines in excel are very simple and easy. Let’s understand the working of Gridlines in Excel with some examples.
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.
In the below screenshot, we can see that gridlines have been removed, and it shows like white plain paper where we can take a printout without grid lines. In a similar way, we can bring back the grid lines for the sheet by enabling the gridlines option in the View menu or in the page layout menu.
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 separates 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.
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.
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 font group, where we will get the list of border styles which is shown below. Choose 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 the specific line color; for example, we will choose the line color as 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.
In the below screenshot we can see that grid lines has been filled with green color for the specific rows and column.
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, which is shown in the below screenshot.
- 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 so that we will get the print with grid lines, and in the same way, we can hide the print gridlines by disabling it or by removing the tick mark from the checkbox.
Things to Remember About Gridlines in Excel
- In excel, we can remove the gridlines easily by just removing the checkbox in the view menu.
- Gridlines in excel can be added or removed by using the keyboard shortcut ALT+W+V+G
This has been a guide to Gridlines in Excel. Here we discuss how to add and remove excel gridlines along with practical examples and a downloadable excel template. You may also look at these suggested articles to learn more –