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.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.0 7.00
Keywords : kbusage
Version : 2.X 3.00 4.00 5.00 5.00c 7.00 |
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.