resize my worksheet-there is no maximize button showing

[dj95]

how do i resize a worksheet to fit the window. for some reason there are no
minimize/maximize buttons showing on it and also you can't click and drag
from either side or top/bottom to enlarge it

 

[Gord Dibben]

Sounds like the workbook is protected.

Tools>Protection>Unprotect Workbook

You may need to provide a password.


Gord Dibben MS Excel MVP

 

[PAF]

I, too, am having this problem on my newly converted Excel 2007 worksheets.
Does anyone know how to resolve this, or what causes it to happen?

 

[RVD]

Office 2007 Excel Spreadsheet Window Size
I had the same problem. Hope this works as easily for you as it did for me.
1. Click on the "Review" Tab
2. Click on the "Protect Workbook" Icon
3. Uncheck "Protect Structure and Windows" option
This automatically unlocked my workbook and resized it to fit the screen.
Good Luck