Compare Excel 2016 for Mac with Excel 2013 for Windows The following feature list is not comprehensive, but it will give ...

Compare Excel 2016 for Mac with Excel 2013 for Windows

The following feature list is not comprehensive, but it will give you an idea of how Excel 2016 for Mac compares with Excel 2013 for Windows.

● Feature is supported
◌ Feature is not supported

Feature	Feature action/button	Excel for Mac	Excel for Windows
Entering and formatting data	Conditional formatting Data validation AutoComplete Flash Fill	● ● ● ◌	● ● ● ●
Pictures	Inserting pictures from File Inserting online pictures from within Excel Inserting screen clippings from within Excel	● ◌ ◌	● ● ●
Filters	Filter Advanced filter Timeline filter	● ● ◌	● ● ●
Formulas	Formula Builder Functions * AutoComplete Evaluate Formula Watch Window	● ● ● ◌ ◌	● ● ● ● ●
Add-Ins	Analysis Toolpak Solver	● ●	● ●
Data analysis	PivotTables PivotTable slicers Table slicers Charts PivotCharts	● ● ◌ ● ◌	● ● ● ● ●
External data	Connect to a SQL Server database with an ODBC driver installed with Excel Connect to other ODBC data sources ** Import data from a text file Import data from a web query Import a file from FileMaker	● ● ● ● ●	● ● ● ● N/A
Macros	Recording macros Running macros	● ●	● ●
Printing	Page Layout view Page Break Preview view Print to PDF	● ◌ ●	● ● ●
Keyboard shortcuts	key shortcuts Control key shortcuts Function key shortcuts Alt key shortcuts Ability to customize shortcuts	● ● ● ◌ ◌	N/A ● ● ● ●

* Excel 2016 for Mac includes all functions that are in Excel 2013 for Windows, except for WEBSERVICE, FILTERXML, and ENCODEURL.

** In Excel 2016 for Mac, this requires downloading an ODBC driver.