What is the maximum number of worksheets available in an Excel workbook?

Answer

Excel 2010 does not have a specific maximum number of worksheets available in a workbook. The maximum number is limited by the amount of available memory in a system. The default setting is three sheets.

Excel does have limitations in other areas. For instance, the maximum worksheet size is 65,536 rows by 256 columns. Columns are no wider than 255 characters. The text in an individual cell must not exceed 32,767 characters. Fifty-six font colors are accessible in a workbook, and 4,000 different cell styles are available. A worksheet is allowed no more than 66,530 hyperlinks.

The “undo” function cancels out up to 16 levels of work.

Q&A Related to "What is the maximum number of worksheets available..."
With Excel 2007, there are three default worksheets that open with a new worksheet. The total number of worksheets possible in a single Excel 2007 workbook are limited only by the
http://wiki.answers.com/Q/How_many_worksheet_on_wo...
1. Use multiple worksheets when creating spreadsheets for several related groups of information. 2. Don't use multiple worksheets if your spreadsheets aren't related - create a new
http://www.ehow.com/how_11795_decide-worksheets-wo...
In Excel are worksheets that make a workbook and by default
http://www.chacha.com/question/how-many-worksheets...
Right from the help file: Program workspace specifications Feature Specification Maximum number of custom toolbars in a workbook Limited by available memory Maximum number
http://www.experts-exchange.com/Software/Office_Pr...
Explore this Topic
An Excel Workbook is a file in the Excel application that can used to enter and store related data. These workbooks usually contain many worksheets and they often ...
A collection of worksheets in excel is called a workbook. Usually, each workbook in Excel contains three pages or worksheets. The workbooks may also comprise a ...
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2014 Ask.com