Thread: freeze
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default freeze

Select B2 and WindowFreeze Panes.

The rule for freezing is.........rows above and columns left of the selected
cell will be frozen.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 13:41:01 -0800, Terry
wrote:

Hi I would like to know how can I freeze the first column and first line at
same time

I need the first line to freeze and the first colunm. But when I go to cel
1A and click freeze..it freeze 6 lines....and the screen get very limited to
navigate

thanks
Teresa