Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Print Gridlines and Headings in Excel

Print gridlines (the horizontal and vertical lines on your worksheet) and row/column headers (1, 2, 3 etc. and A, B, C etc.) to make your printed copy easier to read.

To print gridlines and headings in Excel, execute the following steps.

1. On the Page Layout tab, in the Sheet Options group, check Print under Gridlines and check Print under Headings.

Also See:   Print Headers and Footers in Excel

2. On the File tab, click Print for a print preview.

Leave a Reply

Your email address will not be published. Required fields are marked *