View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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