Canot 'Size' Excel

[Terry]

Help!

For some obscure (to me) reason I cannot re-size Excel. I can 'Size'
individual Windows within Excel but not Excel itself. 'Size' is greyed out
in the top left menu button. Every other program seems OK. I have tried
repairing to no avail. Is there some obscure setting I've missed? I use
Excel 'sized' (as opposed to full screen) a lot and its a pain not being
able to size it.

Any help much appreciated

Thanks

Terry

 

[Jerry Baker]

Help!

For some obscure (to me) reason I cannot re-size Excel. I can 'Size'
individual Windows within Excel but not Excel itself. 'Size' is greyed out
in the top left menu button. Every other program seems OK. I have tried
repairing to no avail. Is there some obscure setting I've missed? I use
Excel 'sized' (as opposed to full screen) a lot and its a pain not being
able to size it.

I saw this just the other day and it was caused by checking the "window"
option when protecting the workbook. Unprotect the workbook and it will
go away.

 

[Terry]

Thanks Jerry.

However, this problem affects all excel work books, including new.
Protection is off so that is not the problem. Any other suggestions?

Terry

 

[Bill Sharpe]

Help!

For some obscure (to me) reason I cannot re-size Excel. I can 'Size'
individual Windows within Excel but not Excel itself. 'Size' is greyed out
in the top left menu button. Every other program seems OK. I have tried
repairing to no avail. Is there some obscure setting I've missed? I use
Excel 'sized' (as opposed to full screen) a lot and its a pain not being
able to size it.

Any help much appreciated

Thanks

Terry

I see the grayed "size" button too when Excel is full screen.

"Restore", though, is not grayed out. Clicking that reduces the Excel
window and then "Size" is available at least on my version of Excel. Are
you saying that there are no choices other than close on the top left
icon menu?

Bill

 

[Terry]

Bill - thanks for response.

I confused things when mentioning top left button I now realise, so lets
stick to top right, the centre button between _ and X; whichever symbol it
shows, the window is maximized; when clicked the title bar 'shudders' but
the window stays maximized even though the symbol changes. Also, when the
symbol shows a 'single sheet' ie sized (but the window is still maximised),
back to top left and click on size (not greyed out) then I do get the double
mouse pointer - but it does not change to a single arrow at the edge of the
screen and hence the edge cannot be dragged. Hope that is now a bit clearer
than mud! I am trying to avoid a total remove and re-install as I've just
spent some time altering all the defaults to my preferences and re-doing
micros having just set this all up on a new system.

Terry

 

[Bill Sharpe]

Bill - thanks for response.

I confused things when mentioning top left button I now realise, so lets
stick to top right, the centre button between _ and X; whichever symbol it
shows, the window is maximized; when clicked the title bar 'shudders' but
the window stays maximized even though the symbol changes. Also, when the
symbol shows a 'single sheet' ie sized (but the window is still maximised),
back to top left and click on size (not greyed out) then I do get the double
mouse pointer - but it does not change to a single arrow at the edge of the
screen and hence the edge cannot be dragged. Hope that is now a bit clearer
than mud! I am trying to avoid a total remove and re-install as I've just
spent some time altering all the defaults to my preferences and re-doing
micros having just set this all up on a new system.

Terry

Try this approach:
Click on the top left button, choose size.
Hit the right or left arrow button on the keyboard.
You then should be able to drag the right or left edge of your window
with the mouse.
It appears that your sized window has somehow been adjusted to be as big
as your maximized window, which is why your title bar 'shudders' but
doesn't change size when you switch between max and sized windows.
Alternately, see if you can position the cursor in the lower right
corner of your window, where it should turn into a diagonal double-arrow
that you can drag to make the window smaller.

Bill