close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()