Excel: Just one sheet by default, please


Why do I need three worksheets automatically generated when I create a new workbook? I don’t. I see so many workbooks with “Sheet1” full of data while “Sheet2” and “Sheet3” are sitting there sad and empty. As an auditor, I need to spend my precious minutes checking those other two sheets just to make sure there is nothing I wouldn’t want in a locked-down audit file. Plus, creating a new sheet when needed is easy enough that Excel should really only give you one to start with.

If you share my frustration, here is how to make Excel only provide one sheet by default:

  1. Go to Office Button –> Excel Options.
  2. Under popular, you should see an option for “Include this many sheets.” Change this to 1.
    Excel_Options-2011.05.23-15.53.37
Advertisements
  1. #1 by US Accounting Firms on October 13, 2011 - 12:52 am

    Its really awesome informative article, I just doing bookmark of this post.

  2. #2 by Jordan on October 11, 2012 - 3:22 pm

    Yay – Thanks for the tip!

  3. #3 by Chris on February 1, 2013 - 8:58 am

    I shared your frustration…until today…Many thanks.

  4. #4 by http://easyinteriordesign.devhub.com/ on February 12, 2013 - 11:10 pm

    I personally speculate why you labeled this specific posting,
    “Excel: Just one sheet by default, please CPA Tech Tips”.

    Regardless I really loved it!Thanks,Kenneth

  5. #5 by http://Www.innatbowmanshill.com on April 19, 2013 - 11:53 pm

    Exactly how long did it acquire u to create “Excel:
    Just one sheet by default, please | CPA Tech Tips”? It offers quite a bit of beneficial details.
    Thank you ,Diego

  6. #6 by Www.Crosscountrybiketrip.com on April 20, 2013 - 8:31 am

    Thanks for composing “Excel: Just one sheet by default, please | CPA
    Tech Tips”. I actuallywill really be back for even more
    reading through and commenting here soon enough.
    Many thanks, Garland

  7. #7 by http://Www.24Notes.org/ on April 20, 2013 - 3:42 pm

    “Excel: Just one sheet by default, please | CPA Tech Tips” ended up being a wonderful post, can’t help but wait to read through a lot more of
    ur posts. Time to waste a little time on-line lol.
    Many thanks -Danae

  8. #8 by Russ on August 17, 2013 - 1:47 pm

    I appreciate it for posting “Excel: Just one sheet by default, please | CPA Tech Tips”.
    I reallywill really be back for alot more browsing and writing comments soon enough.
    Many thanks, Elsie

  9. #9 by Austin on February 12, 2014 - 9:23 am

    The purpose of the blog should be entirely clear as your idea of the target audience.
    Creating blog titles that will get indexed by search engines, and read by people.

  10. #10 by Jeremy on June 12, 2014 - 3:10 pm

    Thanks!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: