Print Gridlines and Headings in Excel

by

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.

Worked Example:   How to set or clear a print area in Excel Worksheet

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

Worked Example:   Print Excel Sheet In Landscape Or Portrait

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

Worked Example:   How to 'Center on Page' Print 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 *