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.
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
www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;nickquot; gt; wrote ...
gt; In exel2003, how can I define a row header for a table. In other word how I
gt; can define cells A1,B1,C1 as header row for the table. I know how to do it in
gt; exel 2000 but can't find this option in 2003.
gt; I appreciate your inputs.
- Nov 18 Sat 2006 20:10
define header cells
close
全站熱搜
留言列表
發表留言