Microsoft Excel 2013 and 2016 Maximum Limits and Specifications
Applies to: Microsoft Excel 2013 and 2016 for Windows
For 2013 or 2016 users, you may also want to check out key new features in our related overviews:
Microsoft Excel 2016 version overview
Microsoft Excel 2013 version overview
Looking for Microsoft Excel training courses?
Excel Worksheet and Workbook Maximum Limits and Specifications
Worksheet size: Maximum of 1,048,576 rows and 16,384 columns
Open workbooks: Limited by available memory and system resources
Sheets in a workbook: Limited by available memory (default is 1 sheet)
Names in a workbook: Limited by available memory
Windows in a workbook: Limited by available memory
Panes in a window: Maximum of 4 panes
Named views in a workbook: Limited by available memory
Zoom range: Maximum of 400 percent (minimum is 10 percent)
Undo levels: Maximum of 100 undo levels
Linked sheets: Limited by available memory
Column width: Maximum of 255 characters
Row height: Maximum of 409 points
Page breaks: Maximum of 1,026 horizontal and vertical
Number of characters that a cell can contain: Maximum of 32,767 characters
Characters in a header or footer: Maximum of 255 characters
Maximum number of line feeds per cell: Maximum of 253 lines
Colors in a workbook: Maximum of 16 million colors (32 bit with full access to 24 bit color spectrum)
Unique cell formats/cell styles: Maximum of 64,000
Fill styles: Maximum of 256
Line weight and styles: Maximum of 256
Unique font types: Maximum of 1,024 global fonts available for use or 512 per workbook
Number formats in a workbook: Maximum between 200 and 250, depending on the language version of Excel installed
Hyperlinks in a worksheet: Maximum of 66,530 hyperlinks
Scenarios: Limited by available memory (a summary report shows only the first 251 scenarios)
Changing cells in a scenario: Maximum of 32 changing cells
Adjustable cells in Solver: Maximum of 200 adjustable cells
Custom functions: Limited by available memory
Reports: Limited by available memory
Sort references: 64 references in a single sort; unlimited when using sequential sorts
Fields in a data form: Maximum of 32 fields
Workbook parameters: Maximum of 255 parameters per workbook
Items displayed in filter drop-down lists: Maximum of 10,000 items
Noncontiguous cells that can be selected: Maximum of 2,147,483,648 cells
Excel Calculation Maximum Limits and Specifications
Number precision: 15 digits
Smallest allowed negative number: -2.2251E-308
Smallest allowed positive number: 2.2251E-308
Largest allowed positive number: 9.99999999999999E+307
Largest allowed negative number: -9.99999999999999E+307
Largest allowed positive number via formula: 1.7976931348623158e+308
Largest allowed negative number via formula: -1.7976931348623158e+308
Length of formula contents: Maximum of 8,192 characters
Internal length of formula: Maximum of 16,384 bytes
Iterations: Maximum of 32,767 iterations
Worksheet arrays: Limited by available memory
Selected ranges: Maximum of 2,048 ranges
Arguments in a function: Maximum of 255 arguments
Nested levels of functions: Maximum of 64 nested levels
User defined function categories: Maximum of 255 categories
Number of available worksheet functions: Maximum of 341 functions
Size of the operand stack: Maximum of 1,024
Cross-worksheet dependency: Maximum of 64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency: Limited by available memory
Area dependency: Limited by available memory
Area dependency per worksheet: Limited by available memory
Dependency on a single cell: Maximum of 4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks: Maximum of 32,767
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:59:59
Excel Charting Maximum Limits and Specifications
Charts linked to a worksheet: Limited by available memory
Worksheets referred to by a chart: Maximum of 255 worksheets
Data series in one chart: Maximum of 255 data series
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: Limited by available memory
Excel PivotTable and PivotChart Report Maximum Limits and Specifications
PivotTable reports on a sheet: Limited by available memory
Unique items per field: Maximum of 1,048,576 unique items
Row or column fields in a PivotTable report: Limited by available memory
Report filters in a PivotTable report: Maximum of 256 filters (may be limited by available memory)
Value fields in a PivotTable report: Maximum of 256 value fields
Calculated item formulas in a PivotTable report: Limited by available memory
Report filters in a PivotChart report: Maximum of 256 filters (may be limited by available memory)
Value fields in a PivotChart report: Maximum of 256 value fields
Calculated item formulas in a PivotChart report: Limited by available memory
Length of the MDX name for a PivotTable item: Maximum of 32,767 characters
Length for a relational PivotTable string: Maximum of 32,767 characters
Items displayed in filter drop-down lists: Maximum of 10,000 items
Excel Shared Workbook Maximum Limits and Specifications
Users who can open and share a shared workbook at the same time: Maximum of 256 users
Personal views in a shared workbook: Limited by available memory
Days that change history is maintained: Maximum of 32,767 days (default is 30 days)
Workbooks that can be merged at one time: Limited by available memory
Cells that can be highlighted in a shared workbook: Maximum of 32,767 cells
Colours used to identify changes made by different users when change highlighting is turned on: Maximum of 32 colours (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook: 0 (zero) as tables are not permitted in shared workbooks
Excel Data Model Maximum Limits and Specifications
Memory storage and file size for Data Model workbooks in 32-bit environment: Maximum is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook and add-ins that run in the same process. A data model's share of the address space could run up to 500 to 700 megabytes (MB), but could be less if other data models and add-ins are loaded.
Memory storage and file size for Data Model workbooks in a 64-bit environment: No specific limits on file size. Workbook size is limited only by available memory and system resources.
Excel 2016 uses the Large Address Aware functionality that lets 32-bit Excel 2016 consume twice the memory when users work on a 64-bit Windows operating system.
Adding tables to the Data Model increases the file size. If you don't plan to create complex Data Model relationships using many data sources and data types in your workbook, uncheck the Add this data to the Data Model box when you import or create tables, pivot tables or data connections.
ADDITIONAL RESOURCES
Contact us to discuss any of our custom options.
Check out our blog for more Excel tips, tricks and shortcuts.
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Custom training
Register now for a public scheduled course or contact us to discuss custom on-site or off-site training options.
Related Excel courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Visual Basic for Applications (VBA) | Introduction
You may like
Excel XLOOKUP Function (Overview, Syntax + Formula Examples)
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
How to Use Go to Special in Excel to Find, Select, Replace and Format Data
You can use Go To Special in Excel to quickly find and select cells of a specific type within your worksheet. It only selects cells in the current worksheet, not the entire workbook. Go To Special also searches within the selected range if a range has been selected. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting. After you select multiple cells with Go To Special, you can enter data in the selected cells by pressing Ctrl + Enter or by applying formatting.
How to Lock Cells in Excel (3 Ways)
It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …
How to Stop or Control Green Error Checking Markers in Excel
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
How to Password Protect Your Excel Worksheets and Workbooks
You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.
You may also like
3 Ways to Insert or Type the Euro Symbol in PowerPoint (€)
You can insert the euro sign or symbol (€) in a PowerPoint presentation using built-in PowerPoint commands or keyboard shortcuts (Alt code or AutoCorrect shortcuts).
How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint
In 2021 and 365 versions of Word, Excel and PowerPoint, you now have the ability to hide or unhide the Quick Access Toolbar. So if your Quick Access Toolbar seems to have disappeared, it may simply be hidden. In 2021, Microsoft also removed Undo and Redo / Repeat from the Quick Access Toolbar and moved these commands to the Home tab in the Ribbon.
5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)
You can insert or type the square root symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The square root symbol or radical sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides. You can use an Alt code shortcut, a Math AutoCorrect entry or create an AutoCorrect entry as a custom shortcut.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca