Viewing different worksheets at the same time?

[Rob_T]

I was just wondering if it's at all possible to view different
worksheets from one workbook at the same time. I got to thinking about
this because you can split the view so that you can view different
parts of one worksheet at the same time (dragging that little bar at
the end of the scroll-bars). I'm currently having to create a load of
links between two sheets withing a workbook and it would be so much
easier if you could have both sheets on display at once.

So, is this possible?

Cheers,

Rob

 

[Bob Phillips]

Yes you can. Goto Window>New Window. Another window will open with :2 at the
end (the previous will have :1). You can then tile as required.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Rob_T]

Thanks Bob, that makes things a lot easier!

Rob

 

[Bob Phillips]

To revert, just close one of the windows as you would a workbook, with the X
icon top right.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Dave Peterson]

Just another way to close the window you don't want...

Select that window that should be closed and hit ctrl-w.