Excel 2007 - freeze multiple panes?

S

stew

I am not really sure what to call this or if it's even possible, can you
freeze a row, then while scrolling down have the frozen row be replaced by
another row that will be frozen and so on?

For example:
I freeze row 5 which has column headers. As I scroll down the spreadsheet I
reach row 100, which has different column headers. Can the headers be
replaced so now row 100 is frozen? But at the same time once I scroll back
up above row 100 it would resort back to the headers in row 5....
 
G

Gord Dibben

No

I would add a new window and arrange them horizontally

Each window would have the top row frozen.

Involves switching windows but does the trick.


Gord Dibben MS Excel MVP
 

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