View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Freezing multiple panes on 1 sheet

You can freeze both at the same time.

Select cell B2 and WindowFreeze Panes.

Row 1 and Column A will be become frozen.

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


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 15:06:18 -0400, merritts
wrote:


Hi,

I am hoping to make both the column and row headers scroll with the
user but i can only freeze one or the other. Any suggestions?

Thanks