Freezing multiple panes on 1 sheet

[merritts]

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

[Gord Dibben]

You can freeze both at the same time.

Select cell B2 and Window>Freeze 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
<[email protected]> 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

[pcargila]

I had the same question, thanks Gord

[teylyn]

pcargila,

I doubt that Gord will read that. For one, the thread is four years old, and secondly, it is an old Newsgroup thread. Gord was never a member of this forum, as far as I'm aware.