MS 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. 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 1 and 255.)
Changing this number will not change the workbook currently open. It will effect blank workbooks opened after you make the change.
That’s it! “More or less” on command.
There are so many things in life that I wish came with this adjustment. You know: more paycheck, more mpg, less purchase price, less calories…. You get the idea.
~ April