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
|
|||
|
|||
Can I tile worksheets within a workbook, like one tiles workbooks.
It would often be very convenient to have two or more sheets from the same
workbook displayed at the same time (tiled). One can do this with workbooks, but I cant seem to find a way to do it with worksheets within a workbook. |
#2
|
|||
|
|||
WindowNew window. Tile these and one set up with one sheet and one
another. Two views of the same file. To close, close one window with the 'close' button, maximise the remaining one and save -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Tovarish_Dad" wrote in message news It would often be very convenient to have two or more sheets from the same workbook displayed at the same time (tiled). One can do this with workbooks, but I cant seem to find a way to do it with worksheets within a workbook. |
#3
|
|||
|
|||
Just to add to Nick's reply...
When you do window|arrange, make sure you check that "windows of active workbook" checkbox (well, if that's what you want). And I use this to close the windows I don't want: ctrl-w (the activewindow will close). I find it easier than looking for the correct X. Tovarish_Dad wrote: It would often be very convenient to have two or more sheets from the same workbook displayed at the same time (tiled). One can do this with workbooks, but I cant seem to find a way to do it with worksheets within a workbook. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do I arrange multiple worksheets from the same workbook | skytags | General Discussion | 2 | April 28th, 2005 06:46 PM |
How do i group worksheets inside a workbook into subgroups? | Legatha | Worksheet Functions | 3 | March 19th, 2005 01:51 AM |
Viewing Worksheets withing One Workbook | cagedbirdflies | New Users | 1 | February 22nd, 2005 11:09 PM |
linking info across worksheets within single workbook | Lynda | New Users | 1 | October 25th, 2004 08:53 PM |
Copy a column into many worksheets in a workbook. | Lisa | Worksheet Functions | 1 | December 9th, 2003 08:13 PM |