Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Id like to freeze the first row for headers and freeze the very b. | Charts and Charting in Excel | |||
Why does freeze panes work on one sheet but not on another in sam. | Excel Worksheet Functions | |||
Freezing panes | Excel Worksheet Functions |