Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel sheet lost maximize button

Status
Not open for further replies.

hangmeup

Technical User
Nov 16, 2000
28
US
I have a large multi-page Excel 2002 worksheet which is acting strange. It only covers half the open screen and the maximize button is gone. This happened since my last save. Any ideas on how to fix?

Thanks!
 
Is the "X" button still there? Or have you accidentally shrunk the frame (try setting your cursor on the right hand edge of the frame and hold/drag the frame larger)
 
No, minimize and close are gone also. It also won't let me expand the size with the mouse. All the range names, formulas and data are OK.
 
If the workbook has been protected with Tools / Protection / Protect Workbook (With Protect Windows Checked), you will have no buttons as you describe.

Try Tools / Protection / Unprotect Workbook (You may need a password)

Regards
Ken............
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top