Viewing multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 :-)
------------------------------­------------------------------­----------------
 
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 :-)
------------------------------­------------------------------­----------------
 
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.
 
4.5 years later and this post helped me out with exactly what I wanted to know

Thanks!
 
Back
Top