Specifications and limits for Excel 2011

Workbook and sheet specifications

Feature	Maximum
Open workbooks	Limited by available memory and system resources
Sheet 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 (only 1,024 can be displayed in a cell; all 32,767 can be displayed in the formula bar)
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Unique cell formats/cell styles	32,735
Named views in a workbook	Limited by available memory
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Cell indent levels	250
Conditional formats	Limited by available memory
Number formats in a workbook	Limited by available memory
Names in a workbook	Limited by available memory
Windows in a workbook	Limited only by system resources
Panes in a window	4
Linked sheets	Limited by available memory
scenario	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Sort references	64 in a single sort; unlimited for sequential sorts
Undo levels	16
Fields in a data form	100
Workbook parameters	255 parameters per workbook
Filter drop-down lists	10,000 entries
Custom toolbars in a workbook	Limited by available memory
Custom toolbar buttons	Limited by available memory

Calculation specifications

Feature	Maximum
Number precision	15 digits
Largest allowed positive number	9.99999999999999E+307
Largest allowed positive number via formula	1.7976931348623158e+308
Largest allowed negative number	–9.99999999999999E+307
Largest allowed negative number via formula	–1.7976931348623158e+308
Smallest allowed positive number	2.2251E–308
Smallest allowed negative number	–2.2251E–308
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Sheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Size of the operand stack	1,024
Cross-sheet dependency	64,000 sheets that can refer to other sheets
Area dependency	8,000 cells that can depend on a single area
Area dependency per sheet	64,000 areas that can depend on a single sheet
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, when 1904 date system is used)
Latest date allowed for calculation	December 31, 9999
Largest amount of time that can be entered	9999:59:59

PivotTable report specifications

Feature	Maximum
PivotTables on a sheet	Limited by available memory
Unique items per field	1,048,576
Row or column fields in a PivotTable	Limited by available memory
Report filters in a PivotTable	256 (can be further limited by available memory)
Value fields in a PivotTable	256
Calculated item formulas in a PivotTable	Limited by available memory
Length for a relational PivotTable string	32,767
Items displayed in filter drop-down lists	10,000

Charting specifications

Feature	Maximum
Charts in a workbook	255
Charts linked to a sheet	Limited by available memory
Sheets referenced by a chart	255
Data series in one chart	255
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	256,000
Maximum number of font types in a chart	255
Line styles	8
Area patterns (screen display)	18
Total area pattern and color combinations (color display)	56,448
Pattern and color combinations (color printer)	56,448 (the actual number depends on your printer and its software)

Shared workbook specifications

Feature	Maximum
Users who can open and share a shared workbook at the same time	256
Personal views in a shared workbook	Limited by available memory
Days that change history is maintained	32,767 (the default is 30 days)
Workbooks that can be merged at the same time	Limited by available memory
Cells that can be highlighted in a shared workbook	32,767
Colors used to identify changes that are made by different users when change tracking is turned on	32 (each user is identified by a separate color; changes that are made by the current user are highlighted with blue)