Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a worksheet saved which is larger than the Excel 2007 "workarea".

This means when I open the worksheet I cannot access the corners of the worksheet to reduce the size and the worksheets title bar area (with move,size,minimise etc) is hidden beneath the ribbon , even if I remove the ribbon , I still can't see the title bar.

share|improve this question

3 Answers 3

"Right-click" on Excel's icon on the task bar. This will bring up a menu. Click on "move" and then use your arrow keys to reposition the window.

share|improve this answer

Also, you can press Alt+Spacebar to get the program's context menu (similar to clicking on the icon in the upper-right of the window.

Then pressing left & right will go through the entire program's menus, but (depending on the program) can also go to the individual worksheet's context menu. If you get there you can then go down to "resize", which will give you the 4-arrows resize icon for the worksheet itself (not the main program window). Then press the down key, and the right key (which will let you resize the lower-right corner). Then use the mouse to resize the worksheet.

Then press enter (or click the left button) to finish resizing. This helps with windows are larger than the screen and you're unable to resize them.

Finally, go back to the original author, and swap their incredibly huge high-res screen with a more sane one. You'll never have this problem again :)

share|improve this answer

Go to View on the ribbon and select Arrange All then OK. Does that restore the window size to something accessible?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.