Scrolling two worksheets at same time


Posted by Adrian on October 12, 2001 4:37 AM

Hi,

Does anyone know how to open up two seperate worksheets, arrange them side by side and then enable the ability to scroll down both sheets using only one of the worksheet scroll bars. I have seen this done in the past but cannont find out how to do it anywhere else.

All help appreciated!
Adrian...



Posted by Dan on October 12, 2001 4:55 AM

:I have seen this done in the past but cannont find out how to do it anywhere else.

Are you sure that what you saw was two different worksheets, or one worksheet split in two panes? When using large worksheets, a common method of dislaying data in two parts of the worksheet is to split the window in two planes. It would look and act as you described.

I'm not saying that it isn't possible, but I haven't seen it before.