Excel spreadsheet won't open full size.

[AccountantDJ]

I saved an Excel spreadsheet and it won't open to full size. It appears as
if it is arranged horizontally. It only opens to half the screen. How can I
fix it?

 

[Shane Devenshire]

Hi,

Double-click the title bar to maximize the window and then save the file.
Close it and then open it again. See if this works.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[AccountantDJ]

I tried it and nothing happened. Any other ideas?

 

[pfidlle]

I am having the same problem!!! Grrr.... Question: is your sheet
protected? or do you have any macros in the worksheet?

 

[AccountantDJ]

Yes it is password protected, but no macros.

I am having the same problem!!! Grrr.... Question: is your sheet
protected? or do you have any macros in the worksheet?

 

[AccountantDJ]

I unprotected the worksheet and it opened full size. Then I resaved it with
password protection and now it opens full size. Problem solved. don't know
why, but it worked. hope it works for you.

 

[pfidlle]

I thought I had posted a reply yesterday as well, but I fixed the problem by
unprotecting the workbook where it was checked "protect structure and
window", and that fixed the problem. Looks like we are both back on track...

 

[Trippi]

I had similiar issue but later realised had protected my workbook as well as excel sheet. Unprotected the workbook and was able to resize the spreasheet straight away.