Home |
Search |
Today's Posts |
#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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing multiple worksheets
4.5 years later and this post helped me out with exactly what I wanted to know
Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |