Multiple Freezes in a sheet

[amag]

Is it possible to put multiple freezes in an excel sheet?

[Jezebel]

Depends what 'freeze' means in your vocabulary. It means nothing at all in
normal Excel usage.


"amag" <amitntu@gmail.com> wrote in message
news:1132544656.124787.190210@o13g2000cwo.googlegroups.com...
> Is it possible to put multiple freezes in an excel sheet?
>

[amag]

ohh...what i meant to ask was Is it possible to put multiple freeze
panes(Alt W F) in an Excel Sheet?

[Roger Govier]

Hi

No, you can't have multiple Freeze Panes.
Two possible workarounds
Either copy the row you want to watch (totals ??) to the top row of th
screen above your header row, then with Freeze on below header, you would
have the totals visible at all times.
Or, Window>New Window then Window>Arrange Horizontal and set the 2nd
instance of the Worksheet with the rows to be watched visible just below the
working window.

Regards

Roger Govier


amag wrote:
> ohh...what i meant to ask was Is it possible to put multiple freeze
> panes(Alt W F) in an Excel Sheet?
>