E-Mail:
Author Avatar

Prevent Excel From Generating Three Worksheets

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.

One Comment

[…] Prevent Excel From Generating Three Worksheets […]

What Do You Think?

 


Anti-Spam Image

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense hard-earned information back to the community, stake a claim on your very own Lockergnome blog today! You can write about anything - no matter the topic. Sign-up to start blogging!