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 derfloh 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
Joined
Nov 16, 2000
Messages
28
Location
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.
 
Try View / Full Screen from the menu.
 
Check here:

FAQ68-2377
 
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............
 
That was it! Thanks for your help!
 
Glad we could get you sorted.

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

Part and Inventory Search

Sponsor

Back
Top