Excel spreadsheet won't open full size.

  • Thread starter Thread starter AccountantDJ
  • Start date Start date
A

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?
 
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
 
I am having the same problem!!! Grrr.... Question: is your sheet
protected? or do you have any macros in the worksheet?
 
Yes it is password protected, but no macros.

pfidlle said:
I am having the same problem!!! Grrr.... Question: is your sheet
protected? or do you have any macros in the worksheet?
Click to expand...
 
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.
 
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...
 
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.
 
Back
Top