What Is the Maximum Number of Worksheets Available in an Excel Workbook?
Last Updated Apr 6, 2020 3:28:59 PM ET
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.
More From Reference
What Is the Financial Independence, Retire Early Movement — and Has the Pandemic Changed It?
4 Investing Lessons We Can Learn From Warren Buffett's Stock Portfolio
Here's How a Pre-IPO Investment Helps You Fund Startups
Where to Buy Cryptocurrency: A Guide for Beginners
The Question of Congressional Term Lengths and Limits
PPP Loan Forgiveness Requirements for Small Businesses