View Single Post
  #4  
Old September 2nd, 2005, 02:29 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

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