Tip #3175 - Excel Worksheets on Demand
Printer Friendly Version | E-Mail This Tip
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!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
