In this article, I will try to give a complete overview of how to edit gridlines in Excel. This article will comprise the procedures for adding, removing, changing, and printing gridlines in Excel worksheets and charts.
An Excel gridline is the faint gray edge around each cell in the worksheet. In addition to making it easier to read the data, these gridlines help to distinguish between the cells. Unlike borders, where you can change color, width, style, etc., gridlines offer limited options for changing their appearance. Let’s learn in detail in the following sections.
Download Practice Workbook
You can download the practice workbook from here.
Removing Gridlines in Excel Worksheets
- In order to remove the gridlines in Excel worksheets, go to the View tab and uncheck the Gridlines option.
Showing Gridlines in Specific Area in Worksheet
- If you want to have gridlines in a specific area of a worksheet, select that specific area first.
- Then, go to the Home tab and select All Borders from the Borders option.
- After that, go to the View tab and uncheck the Gridlines.
- Thus, we will have gridlines only in a specific area.
Changing Color of Gridlines in Excel
- To change the color of gridlines in Excel, select the entire worksheet just by clicking the small triangle at the top-left corner of the worksheet.
- Then, go to the File tab.
- Next, go to Options.
- Go to the Advanced tab from the Excel Options wizard.
- Pick a color from the Gridline Color option which is under the Display options for this worksheet group.
- Thus, the color of the gridlines will get changed.
Printing Gridlines in Excel
- Normally, the gridlines do not get printed.
- In order to print the gridlines, go to the page Layout tab and check the Print box under the Gridlines option.
Controlling Chart Gridlines in Excel
Removing Chart Gridlines
- Select the chart first. The Chart Elements option will appear in the right-top corner.
- Uncheck the Gridlines box from the Chart Elements option.
Showing Single or Multiple Gridlines in Excel Chart
- In order to have single-type gridlines, select the chart first.
- Then go to the right-top corner and click on the Chart Elements option.
- Now go to the Gridlines option and pick any one type of gridline (i.e. Primary Minor Horizontal) from the available ones.
- To have multiple-type gridlines, select as many types of gridlines as you want from the Gridlines option and all of them will be applied to the chart.
Things to Remember
- The change in gridline color is only applicable to the selected sheet. The rest of the sheets will have the default color of gridlines.
- The editing of the gridlines does not affect the cell formatting.
- The gridlines are different from the borders in Excel.
In this article, I have tried to give a complete overview of how to edit gridlines in Excel. This includes how to show/remove, change color, and print gridlines of sheets and some modifications of chart gridlines. I hope this article will be helpful for you. For any further questions, please comment below. You can also visit our site for more Excel-related articles.
Frequently Asked Questions
1. How do I change the spacing between gridlines in Excel?
In order to change the spacing between gridlines in Excel, click on the small triangle at the top-left corner of the worksheet to select the entire sheet. Then, put the cursor on the worksheet area and right-click on the mouse. From the available option, pick the Row Height… option and input your desired spacing between gridlines.
2. Do the gridlines get printed while printing?
By default, the gridlines do not get printed while printing. To print the gridlines, go to the page Layout tab and check the Print box under the Gridlines option.
3. Is it possible to apply gridlines to a certain area?
No, we can not apply gridlines to a certain area in Excel. But we can use the All Borders option from Border Styles to the selected area and then remove the gridlines. This will show borders to only that selected region which can be considered as gridlines for that particular area.