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...

file/page setup/sheet/rows to repeat at top

"rmp60015" wrote:

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...

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

To have them in view at all times, select A2 and WindowFreeze Panes.

For printing go to FilePage SetupSheetRows to repeat at top.

Enter $1:$1 in the dialog box.

Row 1 will print on every page.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 10:12:00 -0800, rmp60015
wrote:

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...