ID: Q111088
In the versions of Microsoft Excel listed above, the state in which a window is opened is based on the state of the last window that was closed. Because of this behavior, you may find that files that were saved in a restored state are opened in a maximized state, and vice versa.
Whether or not a window is maximized when you open it is an attribute of the Microsoft Excel workspace. An exception to this is if the workbook's window has been protected.
This behavior is different from earlier versions of Microsoft Excel for Windows.
In Microsoft Excel when a file is open, the window will appear in one of two states:
In this state The window occupies this portion of the screen
-------------------------------------------------------------------
Maximized The entire application window. The filename appears
in the title bar as "Microsoft Excel - BOOK1.XLS."
Restored Some portion smaller than the entire application
window. The filename appears as "BOOK1.XLS."
If a file opens in a maximized view, you can restore it by choosing Restore from the document control menu or by pressing CTRL+F5. The window will return to its last saved size.
If a file opens restored but should open maximized, maximize the window by choosing Maximize from the Document control menu or by pressing CTRL+F10. The window for the file (and all other open windows) will be maximized.
To protect the workbook's window, follow these steps:
1. On the Tools menu, point to Protection and then click Protect Workbook.
2. If you would like to prevent people from unprotecting this workbook,
type a password.
4. If you typed a password in step 2, you will be prompted to reenter the
password. Type the password again and click OK.
Version : WINDOWS:97,7.0,7.0a,5.0,5.0c
Platform : WINDOWSLast Reviewed: January 7, 1999