Monday, February 12, 2007

Default number of worksheets

What is the default number of worksheets in Microsoft Excel?
How many worksheets can I have in Microsoft Excel?

The default number of worksheets in a workbook is three (3).
You can have a maximum of two hundred and fifty five worksheets(255) in a workbook (though the same is limited by the available amounot of memory in your computer. Anyway, you cannot have more than 255 worksheets)

Thus, when you create a new file in Microsoft Excel, it would have three worksheets. To change the default number of worksheets when you create a new workbook,

  • Goto TOOLS->OPTIONS
  • Select the GENERAL tab
  • Under the SHEETS IN NEW WORKBOOK option, change the number of worksheets you want to have in a new workbook.
  • Click OK
The next time you create a new workbook you would have your choice of worksheets.

Note:
If you have changed the default option in Microsoft Excel, for your changes to take effect, you must restart Microsoft Excel.
This does not apply to workbooks already created.

No comments: