ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   resize my worksheet-there is no maximize button showing (https://www.excelbanter.com/excel-discussion-misc-queries/124937-resize-my-worksheet-there-no-maximize-button-showing.html)

dj95

resize my worksheet-there is no maximize button showing
 
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

resize my worksheet-there is no maximize button showing
 
Sounds like the workbook is protected.

ToolsProtectionUnprotect Workbook

You may need to provide a password.


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 15:58:02 -0800, dj95 wrote:

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



PAF

resize my worksheet-there is no maximize button showing
 
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?

"dj95" wrote:

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


rvd

resize my worksheet-there is no maximize button showing
 
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

"PAF" wrote:

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?

"dj95" wrote:

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



All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com