View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Anchoring Excel Cells

Select the row below and the column to the right of the static rows and
columns, then WindowsFreeze Panes

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stockwsr" wrote in message
...
Is there a way to anchor cells so that as I scroll down the same two cells
will always be at the top of the screen. Would be useful when looking at a
lot of data trying to match it up