Microsoft Excel 2013 and 2016 Maximum Limits and Specifications

Applies to: Microsoft Excel 2013 and 2016 for Windows

Below is a list of Microsoft Excel 2013 and 2016 maximum limits and specifications.

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?

VIEW EXCEL 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

Microsoft Excel 2010 Maximum Limits and Specifications

Frequently Asked Questions (FAQs)

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 1 Yonge Street, Suite 1801 (Toronto Star Building), 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 onsite training or an online course on a date that's convenient for you.

Excel limits and specifications represented by a man using Excel.

You may like

How to Use Conditional Formatting in Excel to Highlight Dates Before Today (3 Ways)

How to Use Conditional Formatting in Excel to Highlight Dates Before Today (3 Ways)

You can use conditional formatting in Excel to highlight cells containing dates before today or within a date range before the current date. In a worksheet, you can use conditional formatting to highlight selected cells by filling them with a color based on rules or conditions. This type of formatting is helpful if you want to highlight past due dates such as invoices that are 30, 60 or 90 days overdue.

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

You may also like

How to Loop a PowerPoint Slide Show to Repeat Automatically

How to Loop a PowerPoint Slide Show to Repeat Automatically

You can set up a PowerPoint slide show lo loop or replay automatically. A looping presentation can be used at events, trade shows or even in a reception area in an office. The easiest way to set up a slide show to loop is to apply automatic transitions and then configure Slide Show settings.

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 | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest