View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
swatsp0p swatsp0p is offline
external usenet poster
 
Posts: 1
Default Locking column names


What you want is to "Freeze" the row at the top of the sheet. To do
this, place the cell pointer in cell A2 (or the row below the last row
you want 'frozen') and from the main menu click on Window and select
"Freeze Panes".

Now, scrolling down will leave the top row visible.

Note that this can also be used to 'freeze' columns from scrolling to
the left (which is why you need to be in column A when selecting
'Freeze Panes' if you don't want any columns frozen).

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=559906