Home
Search
Basics
Windows Tips
Applications
Customize
About
Every time you create a new workbook in Excel, you get a document containing three blank sheets. Do you ever use more than one ? Or, do you always use more than three ? In this Quick-Tip I’ll show you how to set Excel to create new workbooks containing the number of sheets you require, whether it’s one or ten.
Here’s How
This Quick-Tip works in both Excel 2007 and 2010 (and perhaps in some older versions as well). The only differences between the two is the different Office Buttons. In Excel 2007 the Office button is a round Windows button, where as in 2010 it’s a green tab.
- In Excel 2010, Click the Green FILE-tab
In Excel 2007, Click the Round Office Button - In Excel 2010, Choose Options in the bottom part of the left panel.
In Excel 2007, Choose Excel options in the lower right corner of the Office File Menu - Locate the following heading in the right pane:
“When creating new workbooks” - Change the value under: “Include this many sheets” from 3 to your desired number
- Click OK
That’s it, and that’s that.
About Thomas
Computer geek from the age of 7, which amounts to 30 years of computer experience. From the early days (when every computer company had their own OS) of DOS, Windows 1.0 through Seven...
In MS Excel 2003…
Tools >> Options
General TAB
Sheets in New Workbook… Default is 3… Set it to what you want…
Same goes for Excel 2000 as for 2003
In Excel 2013 we changed the default to 1 (this helps viewers a lot, especially on 1-sheet documents where the creator didn’t bother to delete sheets 2 and 3, plus the new-sheet button is easier to recognize & tap than it once was.)