Display or hide chart gridlines - Microsoft Support
Add or format gridlines. To make the data in a chart easier to read, you can display horizontal and vertical chart gridlines that extend across the plot area of the chart. You can also display depth gridlines in 3-D charts.
Add or remove series lines, drop lines, high-low lines, or up …
You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. If you no longer want to display the lines or bars, you can remove them. New to formatting charts in Excel?
Show or hide gridlines on a worksheet - Microsoft Support
Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Gridlines are always applied to the whole worksheet or workbook, …
Change how rows and columns of data are plotted in a chart
After you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis. However, you can quickly change the way that worksheet rows and columns are plotted in the …
Display or hide chart gridlines - Microsoft Support
Add or format gridlines. To make the data in a chart easier to read, you can display horizontal and vertical chart gridlines that extend across the plot area of the chart. You can also display depth gridlines in 3-D charts.
Change the color, style, or weight of a line - Microsoft Support
You can change the look of a line shape by changing its color, line style, or weight. If you are using Excel, Outlook, Word, or PowerPoint, you can apply a predefined Quick Style to quickly change the look of your line. What do you want to do?
Print gridlines in a worksheet - Microsoft Support
By default, gridlines don't appear on a printed Microsoft Excel worksheet or workbook. This article describes how you can make the gridlines appear in your printed worksheets. Select the worksheet or worksheets that you want to print.
Change the color of gridlines in a worksheet - Microsoft Support
By default, gridlines are displayed in worksheets using the color that is assigned to Automatic. To change the color of gridlines, you can use the following procedure. Select the worksheets for which you want to change the gridline color. Click File > Excel > Options.
Align or arrange objects - Microsoft Support
To more easily align objects, you can snap your objects to a grid line that runs through the vertical edges, horizontal edges, and centers of other objects. The line becomes visible only when you drag an object near another object. Click View > Guides >Snap to Grid.
Show or hide gridlines on a worksheet - Microsoft Support
By default, gridlines are displayed in worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet by clicking Gridline color under Display options for this worksheet ( File tab, Options , Advanced category).
Turn the snap to grid and snap to object options on or off in Excel
To snap shapes or other objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape. Gray highlighting indicating the option is selected turns on.