In Excel 2007, gridlines don't appear on a printed worksheet or workbook by default. This article explains how you can make the gridlines appear in your printed worksheets.
- Select the worksheet or worksheets that you want to print.
How to select worksheets
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.
- On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
Note If the check boxes in the Sheet Options group appear dimmed, it may be because you have a chart, image, or other object selected on the worksheet. If you cancel that selection, you'll be able to use the check boxes.
- Click Microsoft Office Button , and then click Print.
Keyboard shortcut You can also press CTRL+P.
- In the Print dialog box, click OK.
After you select the Print check box, you may want to take the following steps:
- Preview the gridlines To see how the gridlines will print, press CTRL+F2 to open the Print Preview window. Gridlines are designed to print only around actual data in a worksheet. If you want to print gridlines around empty cells as well, you must set the print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) to include those cells. Alternatively, you can apply borders around the cells instead. To learn more about these options, see Define or clear a print area on a worksheet or Apply or remove cell borders on a worksheet.
- Troubleshoot printing issues with gridlines If gridlines don't show up when you print your worksheet, or if you can't see them in the Print Preview window, make sure that the Draft quality check box is not selected. The Draft quality check box appears on Sheet tab in the Page Setup dialog box. To quickly access the Page Setup dialog box, press ALT+P, S, P.
If gridlines still don't print successfully, there may be an issue with your printer driver. In this case, you can try downloading the latest driver from the printer manufacturer's Web site. As a last resort, you can apply borders around the cells that you want to print. For more information, see Apply or remove cell borders on a worksheet.
Top of Page