Microsoft KB Archive/103511

= Microsoft Knowledge Base =

Excel: Cannot Change Size of New Windows
Last reviewed: September 12, 1996

Article ID: Q103511

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 version 3.0
 * Microsoft Excel for the Macintosh version 4.0

SUMMARY
In Microsoft Excel, there is no way to control the size of windows that are created by choosing New Window from the Window menu, by using the NEW.WINDOW macro command, or, if you are using Microsoft Excel version 4.0, by double-clicking a document name in the Workbook Contents screen.

To control the size or position of a new window, and to resize and arrange your windows, choose Arrange (Microsoft Excel version 4.0 or 5.0) or Arrange All (Microsoft Excel version 3.0) from the Window menu. If you are using a macro, use the WINDOW.MOVE and WINDOW.SIZE (Microsoft Excel version 4.0 or 5.0) or ARRANGE.ALL commands to resize and arrange your windows.

MORE INFORMATION
When you save a document in Microsoft Excel, unless any of the document's windows are maximized, the size and position of each window in that document is also saved. If any of the windows are maximized, their last size before maximization is saved.

However, if you close a window and then re-create the window by choosing New Window from the Window menu, by using the NEW.WINDOW macro command, or by double-clicking an entry in the Workbook Contents screen of a workbook, the new window that is created will appear in a default position and size.

There is no way to change the default position or size: creating a template will not change the size of new windows. The default window position and size is automatically determined by Microsoft Excel. This is by design.