View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Anchoring Excel Cells

If the cells you want to anchor are at or very near the top, you can use
Freeze Panes (just go to the cell that is one row beneath and one column to
the right of the cells you wish to anchor then go to menu Window--Freeze
Panes.

If, however, the cells you wish to see are somewhere in mid-worksheet, get
the cells at or near the top of your view, click in a cell just below them,
then go to menu Window--Split. This will give you a 2nd view of your same
worksheet.
--
John C


"stockwsr" wrote:

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