Headings on Printed Tables

Summary: If you've got a table that spans multiple printed pages, you probably want to repeat a row or two of that table as a heading on each page. Here's the easy way to set up those repeating rows.

Most tables have some sort of heading which indicates what is in each column of the table. This heading can be a row or two in size, and you typically apply some sort of special formatting to the heading row (or rows). When your table gets long enough, you may be wondering how you can get your special heading rows to appear at the top of the portion of the table that appears on each new page. You do this by following these steps:

Select the rows that you are using as your headings.
Display the Layout tab of the ribbon.
In the Data group, click Repeat Header Rows.

What you see on the screen at this point depends on the view you are using. If you are using Normal view, you will notice no difference in the screen. If you are using Print Layout view, however, the headings will appear any time your table is split across pages.

Helpful Links

Newest Tips

Subscribe

Headings on Printed Tables