Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i apply labels (or category names) to columns?
I would like to be able to define categories for the columns that I am
working with. To explain, on a worksheet at the top of the A, B,C,D columns, in row 1 i have put category names. Now, if i gow down in rows beyond the limit of the screen, and i can no longer see row one, i can not see my category names any more. Thus, as a solution, i would either like for row 1 to be visible no matter if i am lookint at row 231 OR i would like to see actual names in place of column A, B, C, etc. Can anyone help me? Thanks, Justin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i apply labels (or category names) to columns?
Freeze row 1: click on row 2, go to Windows--Freeze pane and then scroll
down. Your column headings remain in view. Dave -- Brevity is the soul of wit. "Justin H." wrote: I would like to be able to define categories for the columns that I am working with. To explain, on a worksheet at the top of the A, B,C,D columns, in row 1 i have put category names. Now, if i gow down in rows beyond the limit of the screen, and i can no longer see row one, i can not see my category names any more. Thus, as a solution, i would either like for row 1 to be visible no matter if i am lookint at row 231 OR i would like to see actual names in place of column A, B, C, etc. Can anyone help me? Thanks, Justin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i apply labels (or category names) to columns?
Select A2 and WindowFreeze Panes.
This will leave row 1 in view as you scroll down the sheet. Gord Dibben MS Excel MVP On Wed, 18 Oct 2006 12:20:02 -0700, Justin H. <Justin wrote: I would like to be able to define categories for the columns that I am working with. To explain, on a worksheet at the top of the A, B,C,D columns, in row 1 i have put category names. Now, if i gow down in rows beyond the limit of the screen, and i can no longer see row one, i can not see my category names any more. Thus, as a solution, i would either like for row 1 to be visible no matter if i am lookint at row 231 OR i would like to see actual names in place of column A, B, C, etc. Can anyone help me? Thanks, Justin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Understanding Range Names and Labels | Excel Discussion (Misc queries) | |||
Word address labels to Excel Columns | Excel Discussion (Misc queries) | |||
how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |