Excel 2007
I inherited some Excel workbooks from a prior employee who held my position
with my firm. They are multisheet workbooks, with lots of formulas, and sheet
to sheet references. That last part probably doesn't realy matter.

My problem is that the previous user somehow set the dispaly frame for the
workbook to be about two-thirds of the screen real-estate. I've got this
wonderful large screen, but cannot figure out how to click on the edge, and
drag out the display frame for a greater dispaly area. It will not allow for
expansion or contraction. The darn thing is locked, or has some form of
protection in place! It makes no difference which sheet within the workbook
is selected, it just won't allow me to change the frame display size.

I know the answer will be rudimentary, but I'm just not figuring it out.

Thanks for any suggestions. .....thegrapehunter




Any

Go to View, Click on Arrange All and clear the checks marks, if any...

But if you do not see the Maximize button then most likely your workbook is
protected and you need to ask your predecessor for the password.

Can you send the file to me so that I can see what is happening?

"The Grape Hunter" wrote:

Excel 2007
I inherited some Excel workbooks from a prior employee who held my position
with my firm. They are multisheet workbooks, with lots of formulas, and sheet
to sheet references. That last part probably doesn't realy matter.

My problem is that the previous user somehow set the dispaly frame for the
workbook to be about two-thirds of the screen real-estate. I've got this
wonderful large screen, but cannot figure out how to click on the edge, and
drag out the display frame for a greater dispaly area. It will not allow for
expansion or contraction. The darn thing is locked, or has some form of
protection in place! It makes no difference which sheet within the workbook
is selected, it just won't allow me to change the frame display size.

I know the answer will be rudimentary, but I'm just not figuring it out.

Thanks for any suggestions. .....thegrapehunter




Any