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.

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 KBSubcategory: Additional reference words: 3.0 3.00 4.0 4.00 4.0a 4.00a 5.0 5.00 location 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: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.