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

Defining a Single Condition

Conditional formatting is a powerful tool you can use to dynamically adjust the formatting of your worksheet. This tip ...

Discover More

Determining the Number of Fonts Available

When creating a macro, you may need to figure out how many fonts are available to Word. You can do this using the FontNames ...

Discover More

Using Seek In a Macro

When processing non-document text files in a macro, you have a wide range of commands available for your use. One of those is ...

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)

Moving from Sheet to Sheet with the Keyboard

Hate to take your fingers off the keyboard? Here's how you can move from worksheet to worksheet without touching the mouse.

Discover More

Finding the Number of Significant Digits

When looking at a number, you may wonder how many significant digits it contains. The answer is not always an easy one, ...

Discover More

Conditionally Playing an Audio File

You can add audio files to an Excel worksheet, but what if you want a particular audio file to play only when a value in a ...

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 for this tip:

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 one more than 2?

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"


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.

Links and Sharing
Share