Sometimes you open Excel to find that it’s bigger than your screen and you can’t move your document to correct the problem. Your scroll bars are missing, your menu is floating somewhere in the the stratosphere. Now what? Here are some solutions:
1)If you can see the expand/collapse buttons – on a Mac they are red, yellow and green dots in the upper left, and and in Windows, on the right: 
Click the middle button in Windows or the green one on Mac. This will – counterintuitively – shrink the window to fit inside a frame.
2) If that doesn’t work, try changing the screen resolution. You can do that by choose Start, Control Panel, then Display. (Mac: System Preferences under the apple, then Display). The higher the resolution, the smaller the Excel window. Close and reopen Excel.
3) If none of those work and you’re in Windows, try this tip from Seeing Excel’s Program Window (Microsoft Excel):
Reset the window size with command keys:
Press Alt+Spacebar. This displays the Control menu (even if you cannot see it).
Press the letter R; the Excel window is restored to its “in between” size.
Press Alt+Spacebar to again display the Control menu.
Press the letter X; the Excel window is maximized.
If you would rather use the mouse than the keyboard, you can follow these steps:
Right-click on Excel in the task bar
Choose Restore from the menu that pops up. The Excel window returns its “in between” size.
Again right-click on Excel in the task bar.
Choose Maximize from the menu that pops up
I’m afraid I have no idea how to do this on a Mac. If you know, write in here or enter a comment:
Required fields are marked *.
