Microsoft Excel 2010 Maximum Limits and Specifications

Applies to: Microsoft Excel 2010 for Windows

Below is a list of Microsoft Excel 2010 maximum limits and specifications.

You may also want to check out the following resources with key new features for each version:

Microsoft Excel 2016 Version Overview

Microsoft Excel 2013 Version Overview

Microsoft Excel 2010 Version Overview

Looking for Microsoft Excel training courses?

VIEW EXCEL COURSES >

Excel Worksheet and Workbook Maximum Limits and Specifications

Open workbooks: Limited by available memory and system resources

Worksheet size: 1,048,576 rows by 16,384 columns

Column width: 255 characters

Row height: 409 points

Page breaks: 1,026 horizontal and vertical

Total number of characters that a cell can contain: 32,767 characters

Characters in a header or footer: 255 characters

Maximum number of line feeds per cell: 253 lines feeds

Sheets in a workbook: Limited by available memory (default is 3 sheets)

Colors in a workbook: 16 million colors (32 bit with full access to 24 bit color spectrum)

Named views in a workbook: Limited by available memory

Unique cell formats/cell styles: 64,000 cell formats/cell styles

Fill styles: 256 fill styles

Line weight and styles: 256 weights and styles

Unique font types: 1,024 global fonts available for use; 512 per workbook

Number formats in a workbook: Between 200 and 250, depending on the language version of Excel installed

Names in a workbook: Limited by available memory

Windows in a workbook: Limited by available memory

Hyperlinks in a worksheet: 66,530 hyperlinks

Panes in a window: 4 panes

Linked sheets: Limited by available memory

Scenarios: Limited by available memory; a summary report shows only the first 251 scenarios

Changing cells in a scenario: 32 changing cells

Adjustable cells in Solver: 200 adjustable cells

Custom functions: Limited by available memory

Zoom range: 10 percent to 400 percent

Reports: Limited by available memory

Sort references: 64 in a single sort; unlimited when using sequential sorts

Undo levels: 100 levels

Fields in a data form: 32 fields

Workbook parameters: 255 parameters per workbook

Items displayed in filter drop-down lists: 10,000 items

Noncontiguous cells that can be selected: 2,147,483,648 cells

Excel Calculation Maximum Limits and Specifications

Number precision: 15 digits

Smallest allowed negative number: -2.2251E-308

Smallest allowed positive number: 2.2251E-308

Largest allowed positive number: 9.99999999999999E+307

Largest allowed negative number: -9.99999999999999E+307

Largest allowed positive number via formula: 1.7976931348623158e+308

Largest allowed negative number via formula: -1.7976931348623158e+308

Length of formula contents: 8,192 characters

Internal length of formula: 16,384 bytes

Iterations: 32,767

Worksheet arrays: Limited by available memory

Selected ranges: 2,048 ranges

Arguments in a function: 255 arguments

Nested levels of functions: 64 nested levels

User defined function categories: 255 categories

Number of available worksheet functions: 341 functions

Size of the operand stack: 1,024

Cross-worksheet dependency: 64,000 worksheets that can refer to other sheets

Cross-worksheet array formula dependency: Limited by available memory

Area dependency: Limited by available memory

Area dependency per worksheet: Limited by available memory

Dependency on a single cell: 4 billion formulas that can depend on a single cell

Linked cell content length from closed workbooks: 32,767

Earliest date allowed for calculation: January 1, 1900 (January 1, 1904, if 1904 date system is used)

Latest date allowed for calculation: December 31, 9999

Largest amount of time that can be entered: 9999:59:59

Excel Charting Maximum Limits and Specifications

Charts linked to a worksheet: Limited by available memory

Worksheets referred to by a chart: 255 worksheets

Data series in one chart: 255 data series

Data points in a data series for 2-D charts: Limited by available memory

Data points in a data series for 3-D charts: Limited by available memory

Data points for all data series in one chart: Limited by available memory

Excel PivotTable and PivotChart Report Maximum Limits and Specifications

PivotTable reports on a sheet: Limited by available memory

Unique items per field: 1,048,576 items

Row or column fields in a PivotTable report: Limited by available memory

Report filters in a PivotTable report: 256 (may be limited by available memory)

Value fields in a PivotTable report: 256 value fields

Calculated item formulas in a PivotTable report: Limited by available memory

Report filters in a PivotChart report: 256 (may be limited by available memory)

Value fields in a PivotChart report: 256 value fields

Calculated item formulas in a PivotChart report: Limited by available memory

Length of the MDX name for a PivotTable item: 32,767

Length for a relational PivotTable string: 32,767

Items displayed in filter drop-down lists: 10,000 items

Shared Workbook Specifications and Limits

Users who can open and share a shared workbook at the same time: 256 users

Personal views in a shared workbook: Limited by available memory

Days that change history is maintained: 32,767 (default is 30 days)

Workbooks that can be merged at one time: Limited by available memory

Cells that can be highlighted in a shared workbook: 32,767 cells

Colors used to identify changes made by different users when change highlighting is turned on: 32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)

Excel tables in a shared workbook: 0 (zero)

Note: A workbook that contains one or more Excel tables cannot be shared.

ADDITIONAL RESOURCES

Microsoft Excel 2016 and 2013 Maximum Limits and Specifications

Frequently Asked Questions (FAQs)

Contact us to discuss any of our custom options.

Check out our blog for more Excel tips, tricks and shortcuts.

Public courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.

Do you need more information? Contact us!

To request this page in an alternate format, contact our staff.

^ Back to top

Microsoft Excel training courses in Toronto. with instructor creating a virtual graph.

You may like

How to Use Conditional Formatting in Excel to Highlight Dates Before Today (3 Ways)

How to Use Conditional Formatting in Excel to Highlight Dates Before Today (3 Ways)

You can use conditional formatting in Excel to highlight cells containing dates before today or within a date range before the current date. In a worksheet, you can use conditional formatting to highlight selected cells by filling them with a color based on rules or conditions. This type of formatting is helpful if you want to highlight past due dates such as invoices that are 30, 60 or 90 days overdue.

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Lock the Position of a Slicer in Excel

How to Lock the Position of a Slicer in Excel

Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.

You may also like

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest