If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Viewing multiple worksheets
How can i view 3 worksheets in the same workbook, tiled side by side in the
excel window? Is this possible? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Viewing multiple worksheets
4.5 years later and this post helped me out with exactly what I wanted to know
Thanks! |
#6
|
|||
|
|||
I have Excel 2000, and Word 2003. I also have two monitors to view multiple
files. In Word I can view multiple documents at the same time, such as one document on one monitor and another on the other. In Excel, however, I am unable to view two documents (worksheets) in the same way as above. Is this because it is the 2000 version or is there a view feature I can select for this? Thanks
__________________
Payroll check calculator |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the quickest method to insert & name multiple worksheets . | clyonesse | Worksheet Functions | 8 | September 20th, 2005 10:55 PM |
fax multiple worksheets | volleyman | Worksheet Functions | 0 | March 30th, 2005 05:51 PM |
Print all charts in a workbook (multiple worksheets) | aewsaws | Charts and Charting | 3 | December 31st, 2004 11:31 AM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Consolidating info from multiple Worksheets | Al | Worksheet Functions | 1 | April 22nd, 2004 07:30 PM |