font size must be between 1 and 409 excel

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

Font size must be between 1 and 409 excel