Freezing multiple panes on 1 sheet
 

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


--
merritts
------------------------------------------------------------------------
merritts's Profile: http://www.excelforum.com/member.php...o&userid=35803
View this thread: http://www.excelforum.com/showthread...hreadid=574340

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