Need help with header (I think?)

R

rmp60015

I am creating an ongoing directory list of names, addresses, etc. (organized
by last name). At the top of each page, I would like to automatically have
as the first row a description of each column for the page. For example, on
every page, at the top, I would like to have "Last Name" (in column 1),
"First Name" (in column 2), "Phone Number" (in column 3), etc. I am new to
Excel - is this called a header, or is there another option for having this
row of categories automatically appear at the top of every page? This is
especially important for me because when I add to the list, I do not want the
row of categories at the top to change position on the page and get moved
down on the page - in other words, the row of categories/column descriptions
would always remain at the top of each page, even when I add a name &
information to the page. Big thanks for anyone's help on this...
 
G

Gord Dibben

On your sheet these descriptions in row 1 are known as Titles.

To have them in view at all times, select A2 and Window>Freeze Panes.

For printing go to File>Page Setup>Sheet>Rows to repeat at top.

Enter $1:$1 in the dialog box.

Row 1 will print on every page.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top