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


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..."
1. Open Microsoft Excel. Press and hold the "Ctrl" key on your computer's keyboard and press the "O" key to start the "Open" window. Click on the first
Each MS Excel file can contain
Limited only by available memory. Kevin
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