Prevent Excel From Generating Three Worksheets

Posted by on Sep 20, 2006 | 4 Comments

By default, when you launch Excel, it opens with three worksheets. This is likely fine if you generally create workbooks with multiple worksheets. However, if this is not the case for you and you normally only work with one worksheet, you can change the default behavior. In other words, you can tell Excel to only open one worksheet. The exact steps for doing so are outlined below.

To configure Excel to open a single worksheet:

  1. Within Excel, click Options from the Tools menu.
  2. Select the General tab.
  3. Use the up and down arrows beside the Sheets in new workbook option to change the value to 1.
  4. Click OK.

Now each time you open a new workbook, there will only be one worksheet.

  • Pingback: Useful Shortcuts For Excel | Technology Blog

  • Carson Coots

    Will see how it goes…

  • http://www.facebook.com/profile.php?id=100000943363550 Amine Shady

    I don’t like these kind of apps !

  • http://twitter.com/KodeSource Doug McFarlane

    I waste most of my time posting comments in forum threads.