Stephen

Excel has always had this function so you're mistaken in your statement that

"only open workbooks can be arranged in this way" .

With Sheet1 active, hit WindowNew Window.

Now select Sheet2 and WindowArrangeTiled

Both worksheets 1 and 2 will be visible.

You can do this for as many sheets as you wish.


Gord Dibben MS Excel MVP


On Thu, 19 Jan 2006 06:28:01 -0800, Stephen "Flanders" <Stephen
wrote:

If using more than one worksheet, it would be helpful if these open
worksheets could be arranged (e.g. tiled) within the workbook window. At
present only open workbooks can be arranged in this way, which assumes the
user will always be using more than one workbook at a time. Many users store
data on a number of worksheets and use other worksheets for calculation
within the same workbook.

----------------
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...et.f unctions