Question

Q: Cannot resize Excel window This thread is locked from future replies

I have an Excel document which cannot be resized.  This document has a frozen pane

-The resolution of the window is ridiculously tiny

-When I put my cursor over the lower right drag area to resize, my cursor changes.  When I drag and then release, window stays the same

-The green OSX maximize window button on the top left corner is disabled

-In the View tab, it is locked on Normal. 

-When I try to switch to Page Layout, I get a message that frozen pane will be removed.   I click yes, and the document remains in Normal mode

-The option to remove the frozen pane is disabled

-All the Window -> Arrange options from the menu do nothing

-When I go into full screen mode, Excel covers my screen but my document remains tiny.

Any ideas?

Answer

A:

Hi,

What ChKrBTB said is right (or at least worked for me), though in my version of Excel it was under Tools > Protection > Unprotect Workbook.

The Review tab in the ribbon which offers Protect functionality did not seem to do anything that was going to help, though on recreating the problem, the Protect Workbook had a grey background. My recreation of the problem appears that the Workbook was created, with at least Protect Window selected, which locked in the size and such.

Cheers!

Did this solve your problem?

Sorry this didn't help.

28 people were helped by this reply



 
Question Info

Views: 6459 Last updated: February 21, 2018 Applies to: