Problem with Adding extra sheets to Excel Workbook

L

LueBailey

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?
 
M

Max

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
 
R

RagDyer

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!
==============================================


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?
 
P

Peo Sjoblom

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 tools>options>general and increase "Sheets in new workbook"

--
Regards,

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top