Multiple Freezes in a sheet

J

Jezebel

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

amag

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

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
 
Top