Excel Workbooks and Worksheets

G

Gilles Desjardins

You can ask for 255 sheets as a maximum default BUT you can actually add as
many as you want manually, based upon the RAM you have on your computer.
HTH

Gilles
 
R

Richard Choate

This is only limited by available memory, per Excel help.
Richard Choate

How many worksheets can be in a workbook?
 
G

Gord Dibben

Don

From Help>Index "specifications"(no quotes)>Worksheet and Workbook
Specifications you will find that the number of worksheets in a workbook is
limited by your available memory.

The default number is 3. I believe the most you can set under
Tools>Options>General "sheets in new workbook" is 255.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

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

Similar Threads

Visio to Excel 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Conditional Format Entire Workbook 1
Sharing workbooks limitations - Merged Cells 12
Need Help with Macro Security 1
Link one worksheet in a workbook to another worksheet in same work 1
excel 2010 + copy array 3
Password protect new workbooks from template 0

Top