Viewing multiple worksheets
 

How can i view 3 worksheets in the same workbook, tiled side by side in the
excel window? Is this possible?

Lets assume your current file is Book1

Do window / new window and you will now see that Book1 has become Book1:1
and you also have a Book1:2. Do it again and you will also see a Book1:3.

Now do Window / Arrange and tick Vertical and also the 'Windows of active
workbook' bit

Now just select the required sheet in each window

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"rmellison" wrote in message
...
How can i view 3 worksheets in the same workbook, tiled side by side in
the
excel window? Is this possible?

Many thanks!

"Ken Wright" wrote:

Lets assume your current file is Book1

Do window / new window and you will now see that Book1 has become Book1:1
and you also have a Book1:2. Do it again and you will also see a Book1:3.

Now do Window / Arrange and tick Vertical and also the 'Windows of active
workbook' bit

Now just select the required sheet in each window

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"rmellison" wrote in message
...
How can i view 3 worksheets in the same workbook, tiled side by side in
the
excel window? Is this possible?

And when you're tired of having all those windows open, select one you want to
close and hit ctrl-w.

Save the workbook the way you like--it'll open that way next time.

rmellison wrote:

Many thanks!

"Ken Wright" wrote:

Lets assume your current file is Book1

Do window / new window and you will now see that Book1 has become Book1:1
and you also have a Book1:2. Do it again and you will also see a Book1:3.

Now do Window / Arrange and tick Vertical and also the 'Windows of active
workbook' bit

Now just select the required sheet in each window

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"rmellison" wrote in message
...
How can i view 3 worksheets in the same workbook, tiled side by side in
the
excel window? Is this possible?




--

Dave Peterson

Viewing multiple worksheets
 

4.5 years later and this post helped me out with exactly what I wanted to know

Thanks!