View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Unable to freeze panes

Hi,

Am Sun, 24 Feb 2013 14:21:14 -0500 schrieb :

I'm missing that freezing requires two steps: One to freeze the top
row, one to freeze the columns.


to freeze rows and columns is only one step:
Select a single cell and freeze pane - the columns to the left of the
selected cell and the rows above the selected cell will be frozen.
E.g. you select C3: Columns(A:B) and Rows(1:2) will be frozen.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2