Excel Tip: Place Column and Row Titles on Multiple Pages

Blogger
Share this content
0

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!

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.