Worksheets in a workbook

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

How many worksheets can I have in a workbook?

Worksheets in a workbook

There is no limit on the number of worksheets you can have in an Excel 2000 workbook. The default is three and the most you can set as the default is 256, however the only limiter is the memory and system resources of your PC.

To modify the number of default worksheets in a workbook, select Tools, Options, choose the General tab and select the number you require from the Sheets in new workbook section.



Nobody has commented on this tip yet. Be the first.


URL: (optional)


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!

Guru Spotlight
Jennifer Mathes, Ph.D.