Excel Worksheets on Demand
Ever notice that an Excel workbook opens with many worksheets? (I believe my program was initially set somewhere around 10 sheets).
Have you ever wished that a new workbook would open with more worksheets? Less?
Yep, you’ve got it. There’s a way to change the default number of worksheets. It’s another one of those, “That was so easy, why didn’t I know about that before”? items.
To start with, we will need to go to the trusty old Tools menu, then choose Options.
Once the Options window comes up, go to the General tab.
Halfway down the window, you should find “Sheets in new workbook:” with a data box to the right.
Simply set the number of sheets you want each blank workbook to begin with and click OK. (My program told me that the number had to be between one and 255).
Changing this number will not change the workbook you already have open. It will only affect blank workbooks opened after you make the change.
That’s it! It’s either more or less on demand.
There are so many things in life that I wish came with this adjustment. You know, more paychecks, more mpg, less purchase prices, less calories, etc. You get the idea!