You got it:-) Regardless of how Absolute Referencing is applied in a formula such as your example, Column references do not change when copying into the same Column, Row references do not change when copying into the same Row. Learn how to use Microsoft Excel for the Mac to create, format, review, and share spreadsheets. Understand the user interface of Microsoft Excel for the Mac to efficiently navigate and utilize all the features of the application. Excel for Mac now supports Power Query refresh for many data sources, as well as query creation through VBA. Authoring in the Power Query Editor is not supported yet.
Version (as of 8/1/2019) | 2019 |
Platform | |
License | Commercial |
Category | Productivity |
Rating: |
Main Features
Microsoft Excel for Mac is a widely used spreadsheet program that is part of the Microsoft Office suite. It allows you to organize, analyze, manipulate, and visualize data.
Excel provides workbooks that are divided by tabbed worksheets that can be edited independently. Contained within each worksheet is a grid of cells, which can be formatted in a variety of ways. Excel allows you to perform basic tasks, such as sorting data and creating simple formulas. The program also comes with advanced capabilities, such as Sparklines for detecting trends within your data, VBScript macro scripting, and PivotTables for summarizing your data. Excel saves workbooks in the Office Open XML (OOXML) .XLSX format, while still supporting the older .XLS format.
The spreadsheet application provides thousands of online templates that are available for download within the user interface. This gives users many different options for out-of-the-box styling, formatting, and mathematical computation, allowing them to focus on the data rather than extensive amounts of time on presentation. For example, financial templates can be downloaded by home or business users for tracking income, expenses, and transactions, as well as for automatically generating summary graphs. Excel also provides rich tools for visualizing data such as bar charts, line graphs, pie charts, and scatter plots, as well as more complex ones for more in-depth analysis.
Excel is a great program for managing your data. It provides advanced data organization and analysis tools and is an industry-standard spreadsheet program. Microsoft Excel for Mac is a great choice for organizing, analyzing, manipulating, and visualizing your data.
Supported File Types | |
---|---|
.CRTX | Office 2007 Chart Template File |
.CSV | Comma Separated Values File |
.DQY | Excel Query File |
.EFTX | Office 2007 Theme Effect File |
.MHT | MHTML Web Archive |
.MHTML | MIME HTML File |
.ODC | Office Data Connection File |
.ODS | OpenDocument Spreadsheet |
.PRN | Lotus 1-2-3 Formatted Text File |
.SLK | Symbolic Link File |
.THMX | Office 2007 Theme File |
.TSV | Tab Separated Values File |
.UDCX | Universal Data Connection File |
.UDF | Excel User Defined Function |
.XL | Excel Spreadsheet |
.XLA | Excel Add-In File |
.XLAM | Excel Open XML Macro-Enabled Add-In |
.XLB | Excel Toolbars File |
.XLC | Excel Chart |
.XLK | Excel Backup File |
.XLL | Excel Add-In File |
.XLM | Excel Macro |
.XLR | Works Spreadsheet |
.XLS | Excel Spreadsheet |
.XLSB | Excel Binary Spreadsheet |
.XLSHTML | Microsoft Excel HTML Spreadsheet |
.XLSM | Excel Open XML Macro-Enabled Spreadsheet |
.XLSMHTML | Microsoft Excel MIME HTML Spreadsheet |
.XLT | Excel Template |
.XLTHTML | Microsoft Excel HTML Spreadsheet Template |
.XLTM | Excel Open XML Macro-Enabled Spreadsheet Template |
.XLTX | Excel Open XML Spreadsheet Template |
.XLV | Excel Visual Basic Module |
.XLW | Excel Workspace File |
.XML | XML File |
Additional Related File Formats | |
---|---|
.DATA | Analysis Studio Offline Data File |
.DBF | Database File |
.DEL | Delimited ASCII File |
.DEX | Excel Spreadsheet |
.DIF | Data Interchange Format |
.DOC | Microsoft Word Document |
.GRA | Microsoft Graph File |
.HTM | Hypertext Markup Language File |
.IIF | Intuit Interchange Format File |
.IQY | Internet Query |
.OLB | OLE Object Library |
.RDF | Report Definition File |
.RELS | Open Office XML Relationships File |
.RLE | Run Length Encoded Bitmap |
.SKV | Semicolon Separated Values File |
.TAB | Tab Separated Data File |
.TDL | Tab Delineated Format File |
.TSV | Tab Separated Values File |
.TXT | Plain Text File |
.WK1 | Lotus Worksheet |
.WK2 | Lotus 2 Worksheet |
.WK3 | Lotus 3 Worksheet |
.WK4 | Lotus 4 Worksheet |
.WK5 | Lotus 5 Worksheet |
.WKS | Lotus 1-2-3 Spreadsheet |
.WKS | Works Spreadsheet |
.WQ1 | Quattro Pro for DOS Spreadsheet File |
.XLW | Excel Workbook |
Updated: August 1, 2019
-->Office for Mac that comes with a Microsoft 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals who are deploying Office for Mac to the users in their organizations.
Note
The following table lists the most current packages for the Office suite and for the individual applications. The Office suite includes all the individual applications, such as Word, PowerPoint, and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. The install package is used if you don't have the application already installed, while the update package is used to update an existing installation.
To view release notes, see Release notes.
Version 16.42 (20101102)
Application | Download links | SHA-256 hash for install package |
---|---|---|
Office suite (with Teams) | Install package | 8AC425F0E31869B32C323F4349FB48E9B1C3A114B77EA68897D97C50D9B8BECB |
Office suite (without Teams) | Install package | 5FA1084BD240BF10FAAF94D908492939807EAD8E014582DCB2ADE7ECC484276B |
Word | Install package Update package | 21C54A78343B106A93FFD176130DEB9A6C9154F56EB58446FC27192D1E191995 |
Excel | Install package Update package | 2235E4FE0741CE013777E2B6811AD9EFF738F9A724860FBA0DFD31976BF96E62 |
PowerPoint | Install package Update package | EAF6B82C2042BD4D026779CEB4A58E0B92C8E320A9797C77CA3A588FD94B19EB |
Outlook | Install package Update package | 566A1BD7AD446FCDD31156EBCA3FBD7F8F8BB2EFBCC8F3217CB55AA16A586420 |
OneNote | Update package | Not applicable |
The following table provides release history information and download links for Office for Mac. The table is ordered by release date, with the most recent release date listed first. The build date is listed in parentheses, in a YYMMDD format, after the version number. All releases after August 22, 2016 are 64-bit only. All releases prior to August 22, 2016 are 32-bit only.
Note
Download links are only provided for the most recent releases.
Release date | Version | Install package | Update packages |
---|---|---|---|
October 13, 2020 | 16.42 (20101102) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
September 15, 2020 | 16.41 (20091302) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
August 11, 2020 | 16.40 (20081000) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
July 14, 2020 | 16.39 (20071300) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
June 16, 2020 | 16.38 (20061401) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
May 12, 2020 | 16.37 (20051002) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
April 21, 2020 | 16.36 (20041300) | Office suite (with Teams) Office suite (without Teams) | |
April 14, 2020 | 16.36 (20041300) | Word, Excel, PowerPoint, Outlook, OneNote | |
March 10, 2020 | 16.35 (20030802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
February 11, 2020 | 16.34 (20020900) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
January 14, 2020 | 16.33 (20011301) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
December 10, 2019 | 16.32 (19120802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
November 12, 2019 | 16.31 (19111002) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
October 15, 2019 | 16.30 (19101301) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
September 18, 2019 | 16.29.1 (19091700) | Word, Excel, PowerPoint | |
September 10, 2019 | 16.29 (19090802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
August 13, 2019 | 16.28 (19081202) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
July 16, 2019 | 16.27 (19071500) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
June 11, 2019 | 16.26 (19060901) | ||
May 14, 2019 | 16.25 (19051201) | ||
April 16, 2019 | 16.24 (19041401) | ||
March 27, 2019 | 16.23.1 (19032603) | ||
March 12, 2019 | 16.23.0 (19030902) | ||
February 20, 2019 | 16.22 (19022000) | ||
January 24, 2019 | 16.21 (19011700) | ||
January 16, 2019 | 16.21 (19011500) | ||
December 11, 2018 | 16.20 (18120801) | ||
November 13, 2018 | 16.19 (18110915) | ||
October 16, 2018 | 16.18 (18101400) | ||
September 11, 2018 | 16.17 (18090901) | ||
August 14, 2018 | 16.16 (18081201) | ||
July 10, 2018 | 16.15 (18070902) | ||
June 13, 2018 | 16.14.1 (18061302) | ||
June 12, 2018 | 16.14.0 (18061000) | ||
May 24, 2018 | 16.13.1 (18052304) | ||
May 23, 2018 | 16.13.1 (18052203) | ||
May 15, 2018 | 16.13.0 (18051301) | ||
April 11, 2018 | 16.12.0 (18041000) | ||
March 19, 2018 | 16.11.1 (18031900) | ||
March 13, 2018 | 16.11.0 (18031100) | ||
February 13, 2018 | 16.10.0 (18021001) | ||
January 26, 2018 | 16.9.1 (18012504) | ||
January 18, 2018 | 16.9.0 (18011602) | ||
December 12, 2017 | 15.41.0 (17120500) | ||
November 14, 2017 | 15.40.0 (17110800) | ||
October 10, 2017 | 15.39.0 (17101000) | ||
September 12, 2017 | 15.38.0 (17090200) | ||
August 15, 2017 | 15.37.0 (17081500) | ||
July 21, 2017 | 15.36.1 (17072101) | ||
July 11, 2017 | 15.36.0 (17070200) | ||
June 16, 2017 | 15.35.0 (17061600) | ||
June 13, 2017 | 15.35.0 (17061000) | ||
May 16, 2017 | 15.34.0 (17051500) | ||
April 11, 2017 | 15.33.0 (17040900) | ||
March 14, 2017 | 15.32.0 (17030901) | ||
February 16, 2017 | 15.31.0 (17021600) | ||
January 11, 2017 | 15.30.0 (17010700) |