resize my worksheet-there is no maximize button showing

G

Guest

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

Similar Threads

Excel: Expose whole window or at least top resize handles. 1
Cannot Resize Workbook window 2
Why can't I see my entire Worksheet on the Excel screen? 7
Hard to select first worksheet tab 7
maximizing workbook 4
Can't resize windows! 3
Close / minimize / maximize ? 2
How do I make the minimize and maximize reappear on the title bar. 1

Top