Print with or without cell gridlines

To make a printed worksheet or workbook easier to read, you can print the worksheet or workbook with gridlines displayed around the cells.

1. Select the worksheet or worksheets that you want to print.

   How to select worksheets

   To select	Do this
   A single sheet	Click the sheet tab. If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.
   Two or more adjacent sheets	Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
   Two or more nonadjacent sheets	Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
   All sheets in a workbook	Right-click a sheet tab, and then click Select All Sheets on the shortcut menu .

   Tip When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

2. On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.

   

3. Click Microsoft Office Button , and then click Print.

   Keyboard shortcut You can also press CTRL+P.

Note Worksheets print faster if you print without gridlines.

See also:

• Preview worksheet pages before printing
• Print a worksheet or workbook