View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default freezing rows and columns

Suppose you want the top row and column A frozen - you put your cursor
in B2 and then click on Window | Freeze Panes.

So, position cursor one row below and one column to the right of the
areas that you want frozen.

Hope this helps.

Pete

On Apr 28, 10:08*am, duckie wrote:
how do i freeze rows and columns at the same time