Excel Gridlines (Table of Contents)
Gridlines in Excel
In Microsoft excel gridlines are mostly used to view and print the data in separate rows and columns. In excel if we open a new workbook we can see that sheet contains horizontal and vertical grey color which separates rows and columns. We can view or hide the grid lines in excel by enabling or disabling the grid line in the view menu.
In Excel Grid lines make the sheet to display the data in row and column wise in a professional manner so that it is very useful for the end user to print the specific print area data.
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 where we can add or remove the gridlines in a sheet while taking print out which is 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 gridlines which is shown below.
We can see that the entire sheet contain light grey lines which separate this as row and columns. We can edit and add thick borders to these grid lines or we can remove the gridlines by disabling the grid lines option by following the below steps.
- First, select the entire blank sheet. Go to view menu where we can find the gridlines option. we can see that the check mark has been enabled for the gridlines option. Remove the check mark 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 print out without grid lines. In a similar way, we can bring back the grid lines for the sheet by enabling the grid lines option in view menu or in page layout menu.
Adding Gridline to the specific sheet
Let’s consider the below example which shows the expenses data which contains row and column 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 home menu and add a border to the grid line as shown below.
- Once we click on the borders the selected data will be filled with borders as shown below
Now we can see that expenses data has been filled with borders which gives a good view but the outer sheet contain gridlines we can hide the outer part of the grid lines by following the below steps as follows.
- First, select the entire sheet as shown below.
- Go to View menu where we can find the gridlines option. Remove the check mark for grid line option as shown below.
- In the above screenshot, we can see that grid lines 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 grid lines in a light grey color. Go to Home menu where we can find the Border under font group where we will get the list of border style 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 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 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 downloadable excel template. You may also look at these suggested articles to learn more –