How to manage multiple windows in Excel

Article translations Article translations
Article ID: 254791 - View products that this article applies to.
This article was previously published under Q254791
Expand all | Collapse all

SUMMARY

In Microsoft Excel, you can open multiple windows into a workbook (document). By doing so, you can gain access to different areas of your workbook simultaneously.

MORE INFORMATION

Opening multiple windows into a workbook provides an easy way to view or work with different areas of your workbook simultaneously. Any changes made in any of the windows are made to the workbook.

You can save multiple windows into a workbook by saving it while multiple windows are open. To remove windows that have been saved with your workbook, close all multiple windows, and then save your document.

To open multiple windows into a workbook, follow these steps:
  1. Start Microsoft Excel and open any workbook.
  2. In Microsoft Office Excel 2007, click the View tab, and then click New Window in the Window group.

    In Microsoft Office Excel 2003 and in earlier versions of Excel, click New Window on the Window menu.
Notice that a new window displays the active workbook. You can browse to different areas of the workbook in the separate windows, and changes made in one window are evident in the others.

NOTE: The name on the title bar of each window changes to indicate that these are multiple windows of the same workbook (for example, Book1:1 and Book1:2).

To close multiple windows, click the Close button in the upper-right corner of the window or press CTRL+F4.

NOTE: When you have closed all multiple windows, the workbook name no longer displays a window number.

Excel also allows you to create custom views; a custom view gives you a great deal of flexibility in viewing and editing your workbooks.

Properties

Article ID: 254791 - Last Review: February 8, 2007 - Revision: 4.2
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbhowto KB254791

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com