Microsoft KB Archive/72576

{|
 * width="100%"|

Excel: Opening a Worksheet so That it Fills the Workspace

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 2.21, 3.0

-

SUMMARY
In Microsoft Excel, the initial worksheet (Sheet1 in Windows or OS/2, or Worksheet1 on the Macintosh) always opens in a window which does not fill the workspace. There is no setting to change this.

You may use a macro to maximize Sheet1 every time Microsoft Excel is started.

MORE INFORMATION
  Type the following into a macro sheet:

     A1: =NEW(1) A2: =ARRANGE.ALL A3: =RETURN

Note: If you want to open Microsoft Excel so that Sheet1 is maximized (that is, full-screen), change line A2 to:

=FULL(TRUE) ; for version 3.0 =WINDOW.MAXIMIZE ; for version 4.0

Note: If you have a custom template (sheet.xlt for example), you will need to change line A1 to:

=OPEN(&quot;c:\excel\xlstart\sheet.xlt&quot;)

Without this change, Microsoft Excel opens a new sheet based on the default styles and not on the custom template.  Define the macro as an Auto_Open macro. If you have Microsoft Excel version 4.0, from the File menu, choose Save As. If you want, type a new name for the macro sheet. Be sure you are saving your file in the XLSTART subdirectory. Microsoft Excel will automatically add the .XLA extension. In the Save File As Type box, select the Add-In option, Choose the OK button.

If you have Microsoft Excel version 3.0, save the file as Add-In format. Do this by choosing Save As from the File menu, and selecting the Options button. You will find the Add-In option in the drop-down list. In Microsoft Excel for Windows or OS/2, place the file in the XLSTART directory. On the Macintosh, place the file in the Microsoft Excel Startup folder.

If you have Microsoft Excel 2.x for Windows, save the macro sheet. Edit the [Microsoft Excel] section of the WIN.INI file by inserting the line:

OPEN=MacrosheetName You will see the change the next time you start the Microsoft Excel program.