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

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 ...

Discover More

Stopping Enter from being Pressed In a Form

If you create a form using Word, chances are good that you don't want a user to mess up the layout of the form by ...

Discover More

Word Styles and Templates

Styles are at the heart of Word's formatting power. Understanding how to use styles can greatly increase your ability to ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (menu)

Inserting the User's Name in a Cell

Need to understand who is using a particular workbook? There are a number of ways you can find out, as discussed in this tip.

Discover More

Setting the Calculation Default

Excel can recalculate your worksheets either automatically or manually. The default is to calculate them automatically, ...

Discover More

Inserting Cells

When developing worksheets, you often need to make room in your existing information for new information. One of 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. Maximum image size is 6Mpixels. 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 three more than 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.