Internal length of formula: Maximum of 16,384 bytes Length of formula contents: Maximum of 8,192 characters Smallest allowed positive number: 2.2251E-308 Smallest allowed negative number: -2.2251E-308 Noncontiguous cells that can be selected: Maximum of 2,147,483,648 cells Excel Calculation Maximum Limits and Specifications Items displayed in filter drop-down lists: Maximum of 10,000 items Workbook parameters: Maximum of 255 parameters per workbook Sort references: 64 references in a single sort unlimited when using sequential sortsįields in a data form: Maximum of 32 fields Scenarios: Limited by available memory (a summary report shows only the first 251 scenarios)Ĭhanging cells in a scenario: Maximum of 32 changing cellsĪdjustable cells in Solver: Maximum of 200 adjustable cellsĬustom functions: Limited by available memory Hyperlinks in a worksheet: Maximum of 66,530 hyperlinks Number formats in a workbook: Maximum between 200 and 250, depending on the language version of Excel installed Unique font types: Maximum of 1,024 global fonts available for use or 512 per workbook Unique cell formats/cell styles: Maximum of 64,000 Maximum number of line feeds per cell: Maximum of 253 linesĬolors in a workbook: Maximum of 16 million colors (32 bit with full access to 24 bit color spectrum) Number of characters that a cell can contain: Maximum of 32,767 charactersĬharacters in a header or footer: Maximum of 255 characters Page breaks: Maximum of 1,026 horizontal and vertical Linked sheets: Limited by available memory Zoom range: Maximum of 400 percent (minimum is 10 percent) Named views in a workbook: Limited by available memory Windows in a workbook: Limited by available memory
Names in a workbook: Limited by available memory Sheets in a workbook: Limited by available memory (default is 1 sheet) Open workbooks: Limited by available memory and system resources Worksheet size: Maximum of 1,048,576 rows and 16,384 columns Excel Worksheet and Workbook Maximum Limits and Specifications
0 kommentar(er)
