Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel should allow you to tile sheets within a workbook.
I use Excel 2003. Often I am working on several worksheets within a workbook
and moving data between the sheets. If I could view them in a tile arrangement, like I can mutiple workbooks, it would be much easier to keep up with what I'm doing and to move them more quickly. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
Ann -
You can: Window-Arrange-Click on 'Tiled' -- Regards, Dave "Ann Shafer" wrote: I use Excel 2003. Often I am working on several worksheets within a workbook and moving data between the sheets. If I could view them in a tile arrangement, like I can mutiple workbooks, it would be much easier to keep up with what I'm doing and to move them more quickly. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
|
|||
|
|||
Hi Ann-
David is on the right track re tiling multiple workbooks, but not for multiple sheets in a book. First, in the opened workbook, go to WindowNew Window as many times as necessary. Then go to WindowArrange, select Tiled and check the box for 'Windows of Active Workbook' (although I don't think that check is necessary if you only have one file open). You can then work as you describe with a different area/sheet displayed in each window, and if you save the file that is how it will reopen. Custom Views and Range Names come in particularly handy if you need rapid adjustments to preset positions. BTW- If not familiar with it you might play around with the Split feature, although it pertains to only _one_ sheet as opposed to multiple sheets. HTH |:) "Ann Shafer" wrote: I use Excel 2003. Often I am working on several worksheets within a workbook and moving data between the sheets. If I could view them in a tile arrangement, like I can mutiple workbooks, it would be much easier to keep up with what I'm doing and to move them more quickly. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
hot to access deleted information in excel sheets | Excel Discussion (Misc queries) |