How to use ExcelOctober 9, 2024

    Print Gridlines and Headings in Excel

    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.

    Check Print under Gridlines and Print under Headings

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

    Print Preview

    Written by

    Jason Howie

    Founder, FormulasHQ

    A formula nerd with a passion for numbers and equations. Writes about Excel, Google Sheets, VBA, regex, and Salesforce formulas — for people who spend their day in spreadsheets.

    Try FormulasHQ →
    ← All articles