Edit Gridlines in Excel (Add, Remove, Change, and Print)

Get FREE Advanced Excel Exercises with Solutions!

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.

Removing Gridlines in Excel


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.

Removing Gridlines in Excel


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.

Setting Borders for Specific Area

  • After that, go to the View tab and uncheck the Gridlines.
  • Thus, we will have gridlines only in a specific area.

Showing Gridlines for 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.

Select the Entire Worksheet

  • Next, go to Options.

Clicking the Options Command

  • 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.

Defining Gridlines Color

  • Thus, the color of the gridlines will get changed.

Changing Color of Gridlines in Excel


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.

Printing Gridlines in Excel


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.

Removing Chart Gridlines


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.

Inserting Single Pattern Chart Gridlines

  • 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.

Inserting Multiple Pattern Gridlines


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.

Conclusion

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.


Edit Gridlines in Excel: Knowledge Hub


<< Go Back to Gridlines | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo