No Worksheet Appears in Microsoft Excel

When you open a workbook in Microsoft Excel, you cannot see the file. There appears only a gray screen, even if (sometimes) you can see a formula in the formula bar!

This can happen for several reasons:

  • Least likely is that your workbook has hidden sheets, such as with a personal.xls file. So, just go to FormatàSheetàUnhide.

  • Excel isn't really opening your workbook at all. Go to ToolsàOptions, General tab. Uncheck Ignore Other Applications.

  • The worksheet has gotten hidden within the application window. Go to WindowàArrange, and hit OK.

Note how the closing buttons appear now...

So double-click the title bar of the workbook...

And now notice how the closing buttons appear...

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved