Viewing multiple worksheets

R

rmellison

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

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
R

rmellison

Many thanks!

Ken Wright said:
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 :)
------------------------------­------------------------------­----------------
 
D

Dave Peterson

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.
 
S

standard_guy

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

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top