Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Unable to resize worksheet window in Excel 2010

One of my Excel 2010 workbooks 'suddenly' (no doubt as a result of something I did but I have no idea what triggered this) resized it's worksheet window (see attached image).

I've tried fiddling with Views and Workspace etc. but can't figure out how to return that workbook to it's normal default behaviour.

How can get my worksheet workspace back to it's normal, fully expanded, view?
Excel 2010 Worksheet Window Shrunk
0
qeng
Asked:
qeng
  • 2
1 Solution
 
Wilder1626Commented:
hi

what happen if you double click on the bare. see below picture
re size
0
 
Wilder1626Commented:
You can also do: View > Window > Arrange AllTile.
0
 
ProfessorJimJamCommented:
Have you tried, via the ribbon, View > Window > Arrange All > Tile.

 If the min/max/close buttons are not available then the workbook has the Stucture protected.
 Review > Protect Workbook.
0
 
qengAuthor Commented:
Wilder1626, I had tried those and neither suggestion was resizing the worksheet window.

ProfessorJimJam:  correct, I had protected the Structure.  What is weird is that I don't seem to get predictable behaviour from enabling that function.  I had protected the structure a while back and worked with the spreadsheet for a few hours before it displayed the window resizing.  It does seem that removing the Project Workbook restores the worksheet window.  Re-protecting the workbook with the structure option enabled doesn't shrink the window back down oddly enough.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now