Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) |