Microsoft KB Archive/108081

= Microsoft Knowledge Base =

XL5: Explanation of How Items Appear in Window Menu in 5.0
Last reviewed: March 27, 1997

Article ID: Q108081

2.X 3.00 4.00 5.00 5.00c 7.00 | 2.20 3.00 4.00 5.00 5.00a

WINDOWS                      | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0, 5.0, 5.0a
 * Microsoft Excel for Windows 95, version 7.0

SUMMARY
In Microsoft Excel versions 5.0 and 7.0, the order in which files appear in the Window menu, the More Windows dialog box, and the Unhide dialog box is different from earlier versions of Microsoft Excel.

The following table shows the order in which files appear:

Microsoft        Window menu      More Windows     Unhide Excel versions   order            dialog box       dialog box 5.0, 7.0         Reverse order    Reverse order    Order of opening of opening      of opening

2.x, 3.0, 4.0,   Alphabetical     Alphabetical     Alphabetical 4.0a

MORE INFORMATION
In Microsoft Excel versions 5.0 and 7.0, files are listed in the Window menu and in the More Windows dialog box in the reverse order from the order you opened them. That is, files that you opened more recently will be listed above files that you opened earlier. In versions of Microsoft Excel earlier than 5.0, files are displayed in alphabetical order.

To illustrate this behavior, use the following example:


 * 1) In Microsoft Excel, create a new workbook (Microsoft Excel 5.0 or 7.0) or a new worksheet (versions of Microsoft Excel earlier than 5.0).
 * 2) Save the workbook/worksheet as ALPHA.XLS. Do not close the workbook/worksheet.
 * 3) Repeat steps 1 and 2 four times, saving each new workbook/worksheet as CHARLIE.XLS, ECHO.XLS, DELTA.XLS, and BRAVO.XLS (in that order). When you are finished, you should have five open workbooks or worksheets (depending on your version of Microsoft Excel).
 * 4) Choose the Window menu.

The workbooks/worksheets will appear in the following order in the Window menu:

Microsoft Excel 5.0 or 7.0  In earlier versions of Microsoft Excel ---  BRAVO.XLS                    ALPHA.XLS DELTA.XLS                   BRAVO.XLS ECHO.XLS                    CHARLIE.XLS CHARLIE.XLS                 DELTA.XLS ALPHA.XLS                   ECHO.XLS Using the above example, if you activate ECHO.XLS and create a new window for it, your Microsoft Excel version 5.0 or 7.0 Window menu displays the worksheets: BRAVO.XLS, DELTA.XLS, ECHO.XLS:1, ECHO.XLS:2, CHARLIE.XLS, and ALPHA.XLS.

Also, in Microsoft Excel versions 5.0 and 7.0, files are listed in the Unhide dialog box in order of opening. This means that files that you opened first will be listed above more recently opened files. Versions of Microsoft Excel earlier than 5.0 display files in alphabetical order.