There will be times that displaying the gridlines and column/row headings is necessary. One may want to show how the spreadsheet is laid out in the printed version and having the gridlines and headings enabled will help in this matter. In addition, one may want to make reference to certain cells in a printed spreadsheet and having the column/row headings enabled will allow others to locate those cells.

To enable the gridlines, follow the directions below:

• Click on File in the menu bar and select Page Setup.
• Make sure that the Sheet tab is showing (if not, click on that tab).
• Click on the square box next to the Gridlines option to enable that feature.

 

• Click the OK button to accept the changes.
• Your spreadsheet will now print with the gridlines like the graphic below.

 To add the column/row headings to the printed spreadsheet, perform the following:

• Click on File in the menu bar and select Page Setup.
• Make sure that the Sheet tab is showing (if not, click on that tab).
• Click on the square box next to the Column and Row Headings option to enable that feature.

• Click the OK button to accept the changes.
• Your spreadsheet will now print with the gridlines like the graphic below.