Freeze 2 horizontal panes

E

Erol

I am trying to freeze 2 panes... one limits me to go further up (which I can
do)
and the other limits me to go further up "at another lower row".

So there will be 3 windows in the excel sheet. The top window is frozen, the
middle window I can only scroll up and down until I hit the frozen pane of
upper limit and lower limit, and the bottom window can go as low as row 65536
and it can scroll up to the 2nd pane row (where ever it is) .

Is there anyway to do this? If so, which version of MS Excel do I need?
 
G

Gord Dibben

Cannot be done.

One freeze per window.

Experiment with Window>New Window and Window>Arrange>Horizontal

Each of these two windows can have frozen panes at different spots.

Maybe even 3 windows?


Gord Dibben MS Excel MVP
 
E

Erol

Thanks for the suggestion. I thought it couldn't have be done either.

But I really wanted, so my coworkers could fill the data without getting
confused with more than 1 window.

I hope next MS Excel version will have this option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top