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.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Ask a Question

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

Guru Spotlight

Byron White

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!