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

Here’s an overview of removing the gridlines from a dataset.

Removing Gridlines in Excel

Download the Practice Workbook

Removing Gridlines in Excel Worksheets

  • Go to the View tab and uncheck Gridlines.

Removing Gridlines in Excel

Showing Gridlines in a Specific Area in the Worksheet

  • Select the specific area.
  • Go to the Home tab and select All Borders in Borders.

Setting Borders for Specific Area

  • Go to the View tab and uncheck Gridlines.

This is the output

Showing Gridlines for Specific Area

Changing the Color of Gridlines in Excel

  • Select the entire worksheet by clicking the small triangle at the top-left corner.
  • Go to the File tab.

Select the Entire Worksheet

  • Select Options.

Clicking the Options Command

  • Go to the Advanced tab in Excel Options.
  • In Display options for this worksheet, choose a color in Gridline Color.

Defining Gridlines Color

This is the output.

Changing Color of Gridlines in Excel

Printing Gridlines in Excel

  • Go to Page Layout and check Print in Gridlines.

Printing Gridlines in Excel

Controlling Chart Gridlines in Excel

Removing Chart Gridlines

  • Select the chart.
  • In Chart Elements, uncheck Gridlines.

Removing Chart Gridlines

Showing Single or Multiple Gridlines in Excel Chart

To display single-type gridlines:

  • Select the chart.
  • In Chart Elements, go to Gridlines and choose a type of gridline (Primary Minor Horizontal).

Inserting Single Pattern Chart Gridlines

To display multiple-type gridlines:

  • Select the types of gridlines you want in Gridlines.

Inserting Multiple Pattern Gridlines

Things to Remember

  • The change in gridline color is only applicable to the selected sheet. The other sheets will display the default color.
  • Editing gridlines does not affect cell formatting.

Frequently Asked Questions

How do I change the spacing between gridlines in Excel?

Click the small triangle at the top-left corner of the worksheet to select the entire sheet. Place the cursor on the worksheet area and right-click. Select Row Height… and enter your spacing.

Is it possible to apply gridlines to a specific area?

No, you can not apply gridlines to an area only.

Edit Gridlines in Excel: Knowledge Hub

<< Go Back to Gridlines | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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