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.
REFERENCES
Online Help, version 5.0, Macro Function Contents "User's Guide 1," version 4.0, pages 72, 196, 250 "Function Reference," version 4.0, pages 26, 286, 457-459 "User's Guide," version 3.0 for Windows and OS/2, pages 32, 215-217 "User's Guide," version 3.0 for the Macintosh, pages 26, 207 "Function Reference," version 3.0, pages 16, 159-160
KBCategory: kbusage Last reviewed: September 12, 1996 |