resize my worksheet-there is no maximize button showing

D

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
 
G

Gord Dibben

Sounds like the workbook is protected.

Tools>Protection>Unprotect Workbook

You may need to provide a password.


Gord Dibben MS Excel MVP
 
P

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?
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top