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 |
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 |
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 |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com