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:
- 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).
- Save the workbook/worksheet as ALPHA.XLS. Do not close the workbook/worksheet.
- 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).
- 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.
KBCategory: kbusage Last reviewed: March 27, 1997 |