View Single Post
  #3   Report Post  
CyberTaz
 
Posts: n/a
Default

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