ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   define header cells (https://www.excelbanter.com/excel-discussion-misc-queries/66244-define-header-cells.html)

nick

define header cells
 
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.

David McRitchie

define header cells
 
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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"nick" wrote ...
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.






All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com