Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Disappearing Status Bar

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: Disappearing Status Bar.

Catherine uses keystrokes where she can (instead of the mouse) and she seems to periodically hit a key combination which makes the status bar disappear. She has yet to discover what the keystroke combination is or how to get the status bar back without shutting Excel down and restarting.

Getting the status bar back without restarting Excel is easy. All you need to do is follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the View tab is selected. (See Figure 1.)
  3. Figure 1. The View tab of the Options dialog box.

  4. Make sure the Status Bar check box is selected.
  5. Click on OK.

The keystroke that is resulting in the status bar being turned off is a bit more problematic. There are a few things to check here. First, you should check to see if there are any macros that are in your system that, while running, turn off the status bar. It is possible that the macros may have shortcut keys associated with them, and you are triggering the macro without even knowing it.

If there are no macros, then it is most possible that you are pressing, in sequence, Alt+V, S. This This opens the View menu and toggles the check mark for the status bar. It is also possible that you are pressing Alt+V, U, which puts Excel into full-screen mode. This means that the worksheet takes up the maximum possible space on the screen. In this mode the status bar is not displayed. You can get out of this viewing mode by simply pressing Esc at any time.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9143) 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: Disappearing Status Bar.

Related Tips:

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 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:

Michael (Micky) Avidan    02 May 2015, 06:24
@jimwohlfarth,
If you'll bother to read the WHOLE tip above you'll see a paragraph that states (and I quote:)
"...This tip (9143) 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:..." (end of quote)
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL
jimwohlfarth    01 May 2015, 12:05
my version of excel does not have that view. The view above appears to be from a much older version of excel. I'm using MS Office Professional plus 2010. When I select Options there is no mention of "tools".
 
 

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.