Problem with Adding extra sheets to Excel Workbook

My Excel only has the option of adding 3 sheets per workbook. I need more
than that. Is there any way I can add more than the 3 allowable sheets to my
workbook?

Are you saying the Insert/Worksheet does not work for you?

On Mon, 4 Oct 2004 19:21:03 -0700, LueBailey
wrote:

My Excel only has the option of adding 3 sheets per workbook. I need more
than that. Is there any way I can add more than the 3 allowable sheets to my
workbook?

Click Tools Options General tab

Change the default number "3" to a higher number
in the box for "Sheets in new workbook"
(Think the number has to be between 1 - 255)

Click OK

The next new workbook opened will have
your pre-set number of sheets
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"LueBailey" wrote in message
...
My Excel only has the option of adding 3 sheets per workbook. I need more
than that. Is there any way I can add more than the 3 allowable sheets to
my
workbook?

Three sheets is simply the default number that XL automatically starts with.
You can have XL *start* with as many as 255 sheets, although that's *not*
the maximum. You could manually add as many as you wish, since there is
*no* limit to the number of sheets a WB can contain, within the limits of
your machine memory.

Go to:
Tools Options General tab,
And set the *starting* number of sheets that you wish.

Individual sheets can easily be added by right clicking on a sheet tab and
choosing "Insert".

You can also add an icon to your toolbar, so that a simple click will add
another sheet.
Right click in the toolbar and choose "Customize".
Under the "Commands" tab, in the left window, click on "Insert".
Then, in the right window, click on the "WorkSheet" icon, and drag it to
your toolbar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"LueBailey" wrote in message
...
My Excel only has the option of adding 3 sheets per workbook. I need more
than that. Is there any way I can add more than the 3 allowable sheets to
my
workbook?

You can add how many sheet you want (until memory resources run out),
select all sheets (from the first sheet hold down shift and click the last
sheet tab)
right click any sheet and select insert and double click worksheet, that
will give
you 6 sheets, now repeat, that will give you 12. If you want to change the
default
do toolsoptionsgeneral and increase "Sheets in new workbook"

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"LueBailey" wrote in message
...
My Excel only has the option of adding 3 sheets per workbook. I need more
than that. Is there any way I can add more than the 3 allowable sheets to
my
workbook?