Excel: Cannot Page Through Multiple Windows of Same Document

Last reviewed: November 30, 1994
Article ID: Q82083
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SUMMARY

When in a Microsoft Excel version 4.0 Workbook, you can page through bound and unbound documents by selecting the Paging button on the lower right side of the Workbook Window. If, however, you have multiple windows of the same document, you will not be able to page through the different windows.

MORE INFORMATION

The particular window displayed when paging to a document with multiple windows will either be window number one or the last one that was displayed within the Workbook. This functionality is best illustrated with the following example.

Example

  1. From the File menu, choose New. Select Worksheet and choose OK.

  2. From the File menu, choose New. Select Workbook and choose OK.

  3. Choose the Add button on the Workbook. Select the new worksheet and choose OK.

  4. Choose the Next Page button in the lower right corner. The worksheet will now be active.

  5. From the Window menu, choose New Window. You will now see window number two for the document, designated "SHEET1:2" (without quotation marks) in Microsoft Excel for Windows. In Microsoft Excel for the Macintosh, this will be designated "WORKSHEET1:2".

  6. Choose the Next Page button. You will now be returned to the Workbook.

  7. Choose the Next Page button once more and you will be returned to SHEET1:2 in Windows or WORKSHEET1:2 on the Macintosh. The second window view was the last displayed for the document.

If you were to now select window number one from the Window menu, page to the Workbook and back to the document, you would see SHEET1:1 or WORKSHEET1:1 displayed. At this point, you will not be able to access the second window view from the Window menu or by paging. The only way to display the second window view is to unbind the document and then save and open it as a separate file. All of the window views that were created will be saved with the document.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.0 4.00
KBCategory:
KBSubcategory:


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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.