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
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:
Post a Comment