Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Seeing Excel's Program Window.

Seeing Excel's Program Window

by Allen Wyatt
(last updated February 2, 2017)

4

Have you ever opened Excel, only to be greeted by a program window that was obviously too big for your screen? For example, you may see only the top left portion of the program window, with Excel's title bar missing off the top of the visible screen. Typically such a condition crops up when, for whatever reason, you decrease the resolution at which the Windows screen is displayed. For instance, if you had been viewing your screen at 1024 x 768 and you decrease your screen resolution to 800 x 600. When you later try to open Excel, it may appear off the top of the screen because it is "larger" than the available space on the desktop.

The first solution that springs to mind is that you can simply switch back to the higher resolution, open Excel and make the window smaller, and then switch back to the lower resolution. If this is not possible for some reason, then you must select a different way to accomplish the task.

One method you can try is by using the window controls. Since you cannot see them (they are accessible through the Control menu at the upper-left corner of the program window) because they are off the screen, you must use the keyboard. Follow these steps:

  1. Press Alt+Spacebar. This displays the Control menu (even if you cannot see it).
  2. Press the letter R; the Excel window is restored to its "in between" size.
  3. Press Alt+Spacebar to again display the Control menu.
  4. Press the letter X; the Excel window is maximized.

You might think that the last two steps would revert Excel back to its oversized condition. Instead, it forces Excel to calculate the correct size of the desktop and to set the maximum window size accordingly. If you would rather use the mouse than the keyboard, you can follow these steps:

  1. Right-click on the Excel task on the task bar. Windows displays a Context menu.
  2. Choose Restore from the Context menu. The Excel window is restored to its "in between" size.
  3. Again right-click on the Excel task on the task bar. Windows again displays a Context menu.
  4. Choose Maximize from the Context menu.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2079) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Seeing Excel's Program Window.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Quickly Copying Styles

You can easily use regular editing techniques to copy styles from one document to another. Here's how to make quick work of ...

Discover More

Searching for Multi-Byte Hex Codes

Need to find a character for which you only know the hex code? There are a few ways you can search for the information, as ...

Discover More

Removing Dashes from ISBN Numbers

ISBN numbers are used to denote a unique identifier for a published book. If you remove the dashes included in an ISBN, you ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (menu)

Determining Your Version of Excel

Want to find out exactly what version of Excel you are using? Here's how to get to the info.

Discover More

Editing the Custom Spelling Dictionaries

Excel provides spell-checking capabilities on the text you enter in a worksheet. It utilizes the same dictionaries and custom ...

Discover More

Floating Information in a Frozen Row

You can freeze information in rows or columns using one of the built-in features of Excel. As you move up or down in the ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 2 + 1?

2017-01-19 16:55:43

bruce quinn

I started having this problem all the time after having no problems with the same setup (a Win10 laptop+2 screens) for months. As another tip mentions, WindowsKey+UpArrow was the fastest fix.

Sometimes it would also open with a giant (3" high) box for "Enter Function" but this could be easily dragged smaller.


2013-05-29 08:49:47

Andrew McQuillen

Hi Sheldon,
Can you explain in al little more depth what you mean in your comment. I am constantly working on an excel sheet on one pc and displaying it in meetings on another pc both with different resolutions. it would be really handy not to have to keep resizing all the charts each time i open it up.
Thanks
Andrew


2013-05-26 20:53:02

sheldon hopkins

Of course you could also set the screen resolution, and the screen size with VBA commands in the module thisworkbook: workbook open and never have to worry about it again, and, by the way, use a different screen size for each worksheet in the workbook @!@@!


2013-05-25 16:43:14

Alvaro Sanchez

A simple keyboard shortcut:
"Windows Key" + "Up Arrow" = maximices the current window
"Windows Key" + "Left Arrow" = sets the current window to left half of the screen (or the right half with the "Right Arrow"


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.