define header cells

N

nick

In exel2003, how can I define a row header for a table. In other word how I
can define cells A1,B1,C1 as header row for the table. I know how to do it in
exel 2000 but can't find this option in 2003.
I appreciate your inputs.
 
D

David McRitchie

Hi Nick,
File, Page Setup, Sheet,
Rows to Repeat at top: 1:1
and maybe depending on what you want.
Columns to Repeat at left: A:C:

If you want to do the same for display
Select cell past the top header and the left columns
i.e. cell B2 or D2 depending on one or 3 columns.
Window (menu), Freeze Panes

http://www.mvps.org/dmcritchie/excel/freeze.htm
 
Top