Printing gridlines and row and column headings often makes it easier to read data in your spreadsheet.
These features are not, however, automatically enabled in Excel. This article shows you how to enable both features in Excel 2007.
How to Print Gridlines and Headings in Excel
Note: For help with this example, see the image to the right.
- Open a worksheet that contains data or quickly add data to the first four or five columns and rows.
- Click on the Page Layout tab.
- Check the Print box under Gridlines on the ribbon in order to activate the feature.
- Check the Print box under Headings in order to activate this feature as well.
- Click on the print preview button on the Quick Access Toolbar in order to preview your worksheet before printing it.
- Dotted lines should outline the cells containing data in print preview.
- As well, the row numbers and column letters of the cells containing data should be also be visible in print preview.
Related Articles
