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 contents (text) |
32,767 characters. Only 1,024 display in a 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 a workbook |
4,000 |
Named views in a workbook |
Limited by available memory |
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 a scenario |
32 |
Adjustable cells in Solver |
200 |
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 a workbook |
Limited by available memory |
Custom toolbar buttons |
Limited by available memory |
Number precision |
15 digits |
Largest allowed positive number |
9.99999999999999E307 |
Smallest allowed negative number |
-9.99999999999999E307 |
Smallest allowed positive number |
1E-307 |
Largest allowed negative number |
-1E-307 |
Length of formula contents |
1,024 characters |
Iterations |
32,767 |
Worksheet arrays |
Limited by available memory. Also, arrays cannot refer to entire columns. For example, an array cannot refer to the entire column C:C or to the range C1:C65536. However, an array can refer to the range C1:D65535 because the range is one row short of the maximum worksheet size and does not include the entire C or D column. |
Selected ranges |
2,048 |
Arguments in a function |
30 |
Nested levels of functions |
7 |
Number of available worksheet functions |
329 |
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:99:99 |
