How to Print Gridlines in Excel

You can specify rows and columns to repeat on each printed page. You can also select whether you want to print cell gridlines and row and column headings.

Print Row or Column Titles 

The Print Titles command allows you to designate certain rows and columns to repeat on every printed page.

  1. Click the Page Layout tab.
  2. Click the Print Titles button.
    Print Titles, Gridlines, and Headings
  3. Click in either the Rows to repeat at top or Columns to repeat at left field.
  4. Select the row or column you want to print on each page.
  5. Click OK when you’re finished.
    Print Titles, Gridlines, and Headings

Print Gridlines and Headings 

The letters and numbers that serve as the row and column headings don’t print by default. Neither do the worksheet gridlines. You can turn them on for printing if needed.

  1. Click the Page Layout tab.
  2. Click the Print Titles button.
    Print Titles, Gridlines, and Headings
  3. Under Print, click the Gridlines check box to show or hide gridlines.
  4. Select the Row and column headings check box to show or hide row and column headings.
  5. Click OK when you’re finished.
    Print Titles, Gridlines, and Headings
Excel Cheat Sheet

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.