Excel: Working With Multiple Windows of a Worksheet

ID: Q88682

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

In Microsoft Excel, you can open multiple windows into a worksheet (document). This allows you to access different areas of your worksheet simultaneously.

MORE INFORMATION

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

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

To open multiple windows into a worksheet:

Open your worksheet in Excel.

From the Window menu, choose New Window.

Excel opens a new window into the active worksheet.

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

To close multiple windows:

With Excel for Windows, double-click the Control-menu box in the upper-left corner of the window or press CONTROL+F4.

With Excel for the Macintosh, click the close box in the upper-left corner of the window or press COMMAND+W (COMMAND+F4 on the extended keyboard).

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

REFERENCES

"Microsoft Excel for Windows Reference Guide," version 2.1, pages 213, 245, 348

"Microsoft Excel User's Guide," version 3.0, page 215

"Microsoft Excel User's Guide 1," version 4.0, pages 34, 63-64, 250

Additional query words: duplicate

Keywords :
Version :
Platform :
Issue type :