Asked by: Wendy Martin Arroyo
asked in category: General Last Updated: 14th June, 2020

How do you create custom gridlines in Excel?

Click anywhere on the chart to which you want to add chart gridlines. On the Layout tab, in the Axes group, click Gridlines. Do one or more of the following: For horizontal gridlines, click Primary Horizontal Gridlines, and then click the option that you want.

Click to see full answer.


Just so, how do I format individual grid lines in Excel?

ANSWER: Right click on a gridline, and select format axis. Find the box that says "Horizontal line crosses at:" and enter the value of the gridline you want to format differently than the others [for example, 100 for the graph above].

Also Know, how do I format one grid in Excel? Open the Format Grid Lines dialog box in one of the following ways:

  1. Ribbon: On the Format tab, in the Features group, open the Grid drop-down menu, point to the gridline type that you want to format, and select More Grid Lines Options.
  2. Right-Click Menu: Right-click a gridline, and select More Grid Lines Options.

Keeping this in consideration, how do I add minor gridlines in Excel?

Add minor gridlines in an Excel chart

  1. Click the chart to activate the Chart Tools, and click Design > Add Chart Element > Gridlines > Primary Major Horizontal to remove the original gridlines.
  2. Go on to click Design > Add Chart Element > Gridlines > Primary Minor Horizontal.

How do I add gridlines in Excel 2016?

To show gridlines: On the Layout tab, under View, select the Gridlines check box. Note: Gridlines cannot be customized. To change the width, color, or other attributes of the lines around cells, use border formatting. To hide gridlines: On the Layout tab, under View, clear the Gridlines check box.

11 Related Question Answers Found

What are major and minor gridlines?

How do I darken gridlines in Excel?

How do I get rid of gridlines?


How do I remove the lines from an Excel spreadsheet?

How do I change the color of one line in Excel chart?