Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Seeing Excel's Program Window

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.

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.

Related Tips:

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!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Andrew McQuillen    29 May 2013, 08:49
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
sheldon hopkins    26 May 2013, 20:53
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 @!@@!
Alvaro Sanchez    25 May 2013, 16:43
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"
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.