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:

Go to Office Button –> Excel Options.
Under popular, you should see an option for “Include this many sheets.” Change this to 1.

This entry was posted on May 23, 2011, 3:55 pm and is filed under Excel. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

#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 by Jordan on October 11, 2012 - 3:22 pm

Yay – Thanks for the tip!

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

I shared your frustration…until today…Many thanks.

#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 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 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 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 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 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 by Jeremy on June 12, 2014 - 3:10 pm

Thanks!!!!