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


--
Rob_T
------------------------------------------------------------------------
Rob_T's Profile: http://www.excelforum.com/member.php...fo&userid=4952
View this thread: http://www.excelforum.com/showthread...hreadid=541013

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>
>
> --
> Rob_T
> ------------------------------------------------------------------------
> Rob_T's Profile:
http://www.excelforum.com/member.php...fo&userid=4952
> View this thread: http://www.excelforum.com/showthread...hreadid=541013
>

Thanks Bob, that makes things a lot easier!

Rob


--
Rob_T
------------------------------------------------------------------------
Rob_T's Profile: http://www.excelforum.com/member.php...fo&userid=4952
View this thread: http://www.excelforum.com/showthread...hreadid=541013

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)

"Rob_T" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Thanks Bob, that makes things a lot easier!
>
> Rob
>
>
> --
> Rob_T
> ------------------------------------------------------------------------
> Rob_T's Profile:
http://www.excelforum.com/member.php...fo&userid=4952
> View this thread: http://www.excelforum.com/showthread...hreadid=541013
>

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

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



Rob_T wrote:
>
> Thanks Bob, that makes things a lot easier!
>
> Rob
>
> --
> Rob_T
> ------------------------------------------------------------------------
> Rob_T's Profile: http://www.excelforum.com/member.php...fo&userid=4952
> View this thread: http://www.excelforum.com/showthread...hreadid=541013

--

Dave Peterson