Not quite "Freeze Panes".....
I need to compare two lists by eye, one short and one long and it would be
really helpful if I could get the columns to move independantly (so I can drag and drop one value from row 225 to row 30 and have them "on the same page") so I don't have to scroll between rows. It is like freezing panes, but where they are disconnected in term of scrolling, so I can scroll down one side of the spreadsheet while the other side stays put. Any idea if/how I can do this? |
Hi,
You probably need the New Window feature. Go to Window - New Window then arrange the 2 windows. Note the :1 and :2 after doing this. You can have as many new windows as you want Thanks a lot, Hari India "chris" wrote in message ... I need to compare two lists by eye, one short and one long and it would be really helpful if I could get the columns to move independantly (so I can drag and drop one value from row 225 to row 30 and have them "on the same page") so I don't have to scroll between rows. It is like freezing panes, but where they are disconnected in term of scrolling, so I can scroll down one side of the spreadsheet while the other side stays put. Any idea if/how I can do this? |
All times are GMT +1. The time now is 06:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com