Gridlines help give you visual cues when you're formatting in Office. You can align shapes and other objects in your PowerPoint slides and Word documents, and distinguish between cell boundaries in and sections of your spreadsheets and workbooks in Excel.

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, …

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. For more information, see Select one or …

Gridlines help give you visual cues when you're formatting in PowerPoint. To turn on or off the Gridlines, go to the View tab and select the Gridlines checkbox. The default horizontal and vertical gridlines make a grid of one-inch squares.

To make the data in a chart that displays axes easier to read, you can display horizontal and vertical chart gridlines. Gridlines extend from any horizontal and vertical axes across the plot area of the chart. You can also display depth gridlines in 3-D charts.

Gridlines are designed to print only around actual data in a sheet. If you want to print gridlines around empty cells as well, you must set the print area to include those cells. Alternatively, you can apply borders around the cells instead.

If you remove the table borders, you can show table gridlines to help you see where each cell is located. Showing or hiding table gridlines shows or hides gridlines for every table in your document. Unlike table borders, you can't print table gridlines with your document.

The grid helps you position and align shapes on the drawing page. Set how far apart the gridlines are, change the measurement units they show, or hide them.

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.

A variable grid, which shows more precise gridlines at higher magnifications, is helpful in most drawings. Select View > More. In the Ruler & Grid box, select Fine, Normal, or Coarse for Grid spacing Horizontal and Grid spacing Vertical.