Excel Tip: Place Column and Row Titles on Multiple Pages

You can lock in column and row headings so that they repeat page after page and you won't have to reenter them at the top of each page. Follow these steps to set up repeating headings:

First, choose file, Page Setup from the menus, and click on the Sheet tab.

To assign rows that will repeat at the top of each page:

Click in the Print titles area of the Page Setup/Sheet screen.

Click on the row number of the row from your worksheet that contains the column titles that should repeat. You can drag through multiple row numbers if your titles fill more than one row.

To assign columns that will repeat at the left of each page:

1. Click in the Columns to repeat at left area of the Page Setup/Sheet screen.

2. Click on the column letters for the columns that contain the titles that you want to repeat on your worksheet.

Click OK when all titles have been set.

View more helpful tips!


Already a member? log in here.

Editor's Choice