excel stats
Feature Maximum limit
------- -------------
Open workbooks Limited by available memory and system
resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Length of cell 32,767 characters. Only 1,024 display in a
contents (text) cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is
3 sheets)
Colors in a workbook 56
Cell styles in 4,000
a workbook
Named views in Limited by available memory
a workbook
Custom number formats 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
Scenarios Limited by available memory; a summary report
shows only the first 251 scenarios
Changing cells in 32
a scenario
Adjustable cells 200
in Solver
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 3 in a single sort; unlimited when using
sequential sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in Limited by available memory
a workbook
Custom toolbar buttons Limited by available memory