how many worksheets per file?

**manickmj1** · 09-06-2008, 08:19 PM

Sorry I could not find this anywhere...How many worksheets can you put in one file?

**mdbct** · 09-06-2008, 08:38 PM

I believe starting with Excel 2k it is a many as your system memory can handle

Do a search in the Help for "spreadsheet limits" to see all sorts of limits
For the number of worksheets:

Limited by available memory and system resources

**se1429** · 09-07-2008, 03:31 AM

Hi,

The maximum number allowed is 255 sheets per workbook.

See how to change the defaults here:
http://www.exceldigest.com/myblog/20...lt-worksheets/

Regards.

**mudraker** · 09-07-2008, 07:44 AM

255 is the maximum number of sheets that can be set in the Tools menu > options > Grneral Tab for when a new workbook is created by using the File Munu > New option.

You can add more than 255 sheets using the Insert Menu > Worksheets

as mdbct replied

Limited by available memory and system resources

**shg** · 09-07-2008, 01:19 PM

I'd think carefully about workbook design before adding a lot of worksheets.

A good rationale for having mutiple sheets is that the sheets contain entirely different types of data.

A bad rationale is that they constain the same type of data for different days, months, people, ....

**vikslen** · 05-31-2012, 06:17 PM

How do you ensure you can see all tabs if you have a lot of sheets?

**arlu1201** · 06-01-2012, 02:30 AM

Vikslen,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.