Excel Formula Training Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You tell Excel the value to find, such as “ABC Company” and you tell Excel where to look, such as in a range of cells. You are asking Excel to find the lookup value in the lookup range. Step two, the return, is the function’s result.
This article describes the formula syntax and usage of the LEN and LENB functions in Microsoft Excel.
LEN returns the number of characters in a text string.
LENB returns the number of bytes used to represent the characters in a text string.
Important:
These functions may not be available in all languages.
LENB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LENB behaves the same as LEN, counting 1 byte per character.
The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.
LEN(text)
LENB(text)
The xxx function syntax has the following arguments:
Text Required. The text whose length you want to find. Spaces count as characters.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Data | ||
---|---|---|
Phoenix, AZ | ||
One | ||
Formula | Description | Result |
=LEN(A2) | Length of the first string | 11 |
=LEN(A3) | Length of the second string | 0 |
=LEN(A4) | Length of the third string, which includes 5 spaces | 11 |
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Data | ||
---|---|---|
Phoenix, AZ | ||
One | ||
Formula | Description | Result |
=LEN(A2) | Length of the first string | 11 |
=LEN(A3) | Length of the second string | 0 |
=LEN(A4) | Length of the third string, which includes 5 spaces | 11 |
Office for Mac that comes with an Office 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates.
Updates are available from Microsoft AutoUpdate (MAU). To use Microsoft AutoUpdate, start an Office application, such as Word, and then choose Help > Check for Updates. If you're an admin and want to update the computers in your organization with your existing software deployment tools, you can download and deploy the update packages for each application.
Note
Note: Microsoft AutoUpdate (MAU) release information has moved to the MAU Release History page.
Version 16.28 (Build 19081202)
Version 16.27 (Build 19071500)
Version 16.26 (Build 19060901)
Release Date: May 14, 2019
Version 16.25 (Build 19051201)
This release provides the following updates:
Application | Update | Security updates | Download link for update package |
---|---|---|---|
Word | See your email attachments: Your email attachments are now available in the Shared tab. | CVE-2019-0953: Microsoft Word Remote Code Execution Vulnerability | Word update package |
Excel | See your email attachments: Your email attachments are now available in the Shared tab. Coauthoring merge improvements: Coauthoring has improved the merge success rate when working with conditional formatting, cell styles, range protection, view gridlines, and cross-sheet cut/paste. | Excel update package | |
Powerpoint | See your email attachments: Your email attachments are now available in the Shared tab. Work Faster with New Shortcuts: We've got keyboard shortcuts for things like crop, send forward/send backward, and list-item promotion/demotion. | PowerPoint update package | |
Outlook | Know your contacts’ availability at a glance: See presence information for your contacts that are on Teams right within Outlook. See Key Details for Your Contacts: Select a contact's name in a message or calendar event to see their photo, phone number, email, org chart, and more. Learn More | Outlook update package |
Release Date: April 29, 2019
Version 16.24.1 (Build 19042400)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Updates bundled fonts to include new Japanese Era glyph. | Word update package | |
Excel | Updates bundled fonts to include new Japanese Era glyph. | Excel update package | |
Powerpoint | Updates bundled fonts to include new Japanese Era glyph. | PowerPoint update package | |
Outlook | Updates bundled fonts to include new Japanese Era glyph. | Outlook update package | |
OneNote | Updates bundled fonts to include new Japanese Era glyph. | OneNote update package |
Release Date: April 16, 2019
Version 16.24 (Build 19041401)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office. Get a Faster Start: Get recommendations based on your activity and what others are working on around you. Watch Your Documents Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage across the page. Learn More | Word update package | |
Excel | New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office. Calling All Macro Users: Record a macro using relative references. When you play it back, it works in relation the active cell, not the cells used for recording. Learn More Your Favorite Commands Within Easy Reach: Get quick, easy access to common actions like Find & Select, Zoom to Selection, Arrange All, and more. Find them on the ribbon. Learn More Get a Faster Start: Get recommendations based on your activity and what others are working on around you. Watch Your Worksheet Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage through the workbook. Learn More | CVE-2019-0828: Microsoft Excel Remote Code Execution Vulnerability | Excel update package |
Powerpoint | New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office. Get a Faster Start: Get recommendations based on your activity and what others are working on around you. Easily Save Embedded Media: Save audio and videos with just a Control + click. Learn More Watch your Slides Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage across the screen. Learn More | PowerPoint update package | |
Outlook | New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office. Safe Links: Support for Advanced Threat Protection (ATP) Safe Links. | Outlook update package | |
Microsoft Auto Update 4.10 | Install On Clone Feature Enhancements: For SSD devices, rolling out updates on clone for apps in use, thereby reducing the app downtime due to updates. Installation Optimizations: The update process will use parallelized cloning, so app downtime due to updates will be reduced. | Microsoft AutoUpdate update package | |
Office Suite | CVE-2019-0822: Microsoft Graphics Components Remote Code Execution Vulnerability |
Release Date: March 27, 2019
This release provides the following updates:
Application | Update | Security updates | Download link for update package |
---|---|---|---|
Outlook | Fixes an issue with removal of shared or delegated calendars. Learn more | Outlook update package |
Release Date: March 14, 2019
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Microsoft Auto Update 4.9 | Bug fixes and update installation performance improvements. | Microsoft AutoUpdate update package |
Release Date: March 12, 2019
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | **Get Their Attention with @Mentions:** Use @mentions in comments to let co-workers know when you need their input. Learn More LaTex Equation Editing: Word now supports LaTeX math syntax to create math equations. Learn More | Word update package | |
Excel | **Get Their Attention With @Mentions:** Use @mentions in comments to let co-workers know when you need their input. Learn More Discover More About Your Data: The new Ideas button looks for patterns in your data, and uses them to create intelligent, personalized, suggestions. Learn More | Excel update package | |
Powerpoint | Better Shapeshifting: Move your finger on the trackpad and watch ink flow across the screen. Learn More | PowerPoint update package | |
Outlook | Outlook update package |
Release Date: February 26, 2019
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Microsoft Auto Update 4.8 | Fixed an issue with MAU Opt Into Automatic Updates’ Prompt for MacOS 10.10 Updated to MAU ApplicationID from 'MSau03' to 'MSau04' Fixed an issue with MAU Privileged Helper for installation while another version is running | Microsoft AutoUpdate update package |
Release Date: February 20, 2019
Version 16.22.1 (Build 19022000)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Outlook | Fixed an issue with authentication for Google Accounts. Fixed an issue with calendar synchronization. | Outlook update package |
Release Date: February 12, 2019
Version 16.22.0 (Build 19021100)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More Make Your Images Accessible: When you insert a picture, Office suggests captions that can be read by people with vision impairments. | Word update package | |
Excel | Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More | CVE-2019-0669 | Excel update package |
Powerpoint | Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More Hyperlinks in Living Color: Hyperlinks aren't just blue anymore. Apply any font color you like. Learn More | PowerPoint update package | |
Outlook | Outlook update package | ||
Microsoft Auto Update 4.7 | Microsoft AutoUpdate update package | ||
Office Suite | Quickly change selected picture from the ribbon from different sources: Change Picture will allow users to change their selected picture/graphic to a picture from our Online Picture feature, Icons library, or the clipboard. |
Release Date: January 24, 2019
Version 16.21.0 (Build 19011700)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Fixed an issue with Chinese localization. Break the Language Barrier: Translate words, phrases, or the whole document to another language with Microsoft Translator. Do this from the Review tab on the ribbon. | Word update package | |
Outlook | Fixed an issue with Chinese localization. Optimize sync based on power and network status: Outlook now optimizes sync for your Exchange accounts when on battery and limited network, such as airplane wi-fi. All the Meeting Details At a Glance: Click the event in your calendar to see all the meeting details. Check out who was invited, edit your response, or join the meeting, all in one place. Learn More | Outlook update package |
Release Date: January 23, 2019
Version 16.21.0 (Build 190102303)This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Excel | Fixed a regression in character spacing when mixing unicode and non-unicode. | Excel update package |
Release Date: January 16, 2019
Version 16.21.0 (Build 190101500)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | From iPhone to Word in a Snap: Use the Apple Continuity Camera to insert a photo from your iPhone into your document. Requires macOS Mojave. Learn More Apply sensitivity labels to your documents: Apply sensitivity labels to your documents to keep them compliant with your organization's information protection policies. Learn More Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more | CVE-2019-0561: Microsoft Word Information Disclosure Vulnerability CVE-2019-0585: Microsoft Word Remote Code Execution Vulnerability | Word update package |
Excel | Collaborate with Comments: Keep the conversation going right in your spreadsheet with the built-in reply box. Learn More Apply sensitivity labels to your worksheets: Apply sensitivity labels to your worksheets to keep them compliant with your organization's information protection policies. Learn More Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more SVG Support: Insert and edit SVG's in your workbooks to add visual impact. Learn More More formatting options for Histogram, Waterfall, Treemap, Sunburst, Funnel and Map charts: You have more control of the formatting options for the new chart types by using the format pane. | Excel update package | |
Powerpoint | Print slide numbers in handouts: When you print a presentation into handouts, each slide will show an accompanying slide number. Apply sensitivity labels to your presentations: Apply sensitivity labels to your presentations to keep them compliant with your organization's information protection policies. Learn More Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more Embed a subset of the fonts: Embed only the characters used in the presentation. Learn More | PowerPoint update package | |
Outlook | Apply sensitivity labels to your messages: Apply sensitivity labels to your messages to keep them compliant with your organization's information protection policies. Learn More Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more Find Mail Fast in Your Current Mailbox: Select the Search box for quick suggestions based on your recent search history. No typing required. Learn More Adding Gmail Accounts Just Got Easier: Security improvements mean you no longer need to allow access for 'less secure apps' or set an app password in order to add your Gmail account to Outlook. Outlook for Mac now highlights search terms: Ever tried searching for something and wished Outlook would highlight your search term in the item list and preview pane? Well, wonder no more as it's here! | Outlook update package | |
Microsoft Auto Update 4.7 | The AutoUpdate daemon is now launched as part of the installation process. This eliminates confusing security dialogs that were previously shown to users. Microsoft AutoUpdate’s security features have been enhanced to support SHA256 certificates. | Microsoft AutoUpdate update package |
Note
Starting with Version 16.21, Microsoft Teams will be installed by default for new installations. For more information, see Microsoft Teams installations on a Mac.
Release Date: December 11, 2018
Version 16.20.0 (Build 18120801)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave. Preserve the Look of Your Text: Embed fonts to ensure that your document's text looks the same on every computer. No more surprises! Learn More View embedded fonts in documents: Allows fonts that have been embedded in a file to be rendered in Mac Word. Focus mode invokable status bar: In Focus mode, more easily see Word count and access zoom controls with invokable status bar. Get More with Focus Mode: We heard you! Now, Focus Mode opens at your set zoom level and also shows the page number while you scroll. | Word update package | |
Excel | Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave. | CVE-2018-8597: Microsoft Excel Remote Code Execution Vulnerability CVE-2018-8627: Microsoft Excel Information Disclosure Vulnerability | Excel update package |
Powerpoint | Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave. From iPhone to PowerPoint in a Snap: Use the Apple Continuity Camera to insert a photo from your iPhone into your slide. Requires macOS Mojave. Learn More | CVE-2018-8628: Microsoft PowerPoint Remote Code Execution Vulnerability | PowerPoint update package |
Outlook | Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave. Share your calendar: Share your calendar with family, friends, and colleagues. Open calendars shared with you in Mac, PC, or cloud versions of Outlook. Learn More Turn Off Forwarding for a Meeting: Prevent attendees from forwarding your meetings to others. Learn More Use Teams to Connect to your Meetings: Work with remote teams? Use Teams in Outlook to schedule and join online meetings. Learn More See who's coming to the meeting: Click any meeting or event in your calendar to see who plans to be there. View three time zones: Need to schedule a meeting across time zones? Add multiple time zones to your calendar to easily see everyone's availability and pick a time that works for all. Learn More | Outlook update package | |
Microsoft Auto Update 4.6 | Updated security catalogs to contain SHA-256 hashes instead of SHA-1 | Microsoft AutoUpdate update package | |
Office Suite | Your Ribbon Icons Have a New Look: Don't worry, everything works the same. Plus all of the icons look great on screens of all sizes. Learn More Updated Alt Text Pane: Make your content more accessible by adding helpful captions or even mark elements as decorative. |
Release Date: November 13, 2018
Version 16.19.0 (Build 18110915)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More | Word update package | |
Excel | Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More | CVE-2018-8574: Microsoft Excel Remote Code Execution Vulnerability CVE-2018-8577: Microsoft Excel Remote Code Execution Vulnerability | Excel update package |
Powerpoint | Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More Zoom - present your content in a non-linear way: Create an interactive table of contents with Summary Zoom, or jump to specific slides and sections with Slide Zoom and Section Zoom. Learn more Export to Video with audio narrations: Audio narrations are now included in your exported video. | PowerPoint update package | |
Outlook | Easier Email Encryption: The Encrypt button now has an Encrypt-Only option, which makes it easier to send encrypted email—inside and outside your organization. Learn more | Outlook update package | |
Office Suite | |||
Microsoft Auto Update 4.5 | - Support for Dark Mode - Bug fixe for daemon crash (Updated to Aria SDK 8.5.2.0) | Microsoft AutoUpdate update package |
Release Date: October 16, 2018
Version 16.18.0 (Build 18101400)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Word update package | ||
Excel | Collaborate with Comments: Keep the conversation going right in your spreadsheet with the built-in reply box. Learn more More 'auto' in AutoComplete: When you type a formula, the helpful AutoComplete menu will appear, showing you argument options to choose from. Now improved: VoiceOver navigation: Using VoiceOver in Excel? Move across sheets by pressing VO+U. You can enable the macOS Trackpad Commander to do this too. | Excel update package | |
Powerpoint | Make Your Images Accessible: When you insert a picture, Office suggests captions that can be read by people with vision impairments. Animation Triggers are here: You asked for it! Animation triggers aren't just for Windows anymore. Find them on the Animations tab. Learn more | PowerPoint update package | |
Outlook | Improved Search: Select the Search box for quick suggestions based on your recent search history. No typing required. Learn more | Outlook update package | |
Office Suite | CVE-2018-8432 Microsoft Graphics Components Remote Code Execution Vulnerability |
Release Date: September 11, 2018
Version 16.17.0 (Build 18090901)
This release provides the following updates:
Application | Feature updates | Security updates | Download link for update package |
---|---|---|---|
Word | Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight. Learn more Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more | Word update package | |
Excel | Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight. Learn more Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more Custom shortcuts are back: We heard you! At your request, we've brought back custom shortcut keys. Learn more | CVE-2018-8429: Microsoft Excel Information Disclosure Vulnerability CVE-2018-8331: Microsoft Excel Remote Code Execution Vulnerability | Excel update package |
PowerPoint | Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight.Learn more Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more The font you choose is the font they see: Embed your custom fonts in your files so that wherever they go, your fonts go too. Learn more | PowerPoint update package | |
Outlook | Outlook update package | ||
Microsoft AutoUpdate 4.3 | |||
Office suite | CVE-2018-8332: Microsoft Graphics Remote Code Execution Vulnerability |
Release Date: August 14, 2018
Version 16.16.0 (Build 18081201)
This release provides the following updates.
Application | Features updates | Security updates | Download link for update package |
---|---|---|---|
Word | Word update package | ||
Excel | CVE-2018-8375: Microsoft Excel Remote Code Execution Vulnerability CVE-2018-8382: Microsoft Excel Information Disclosure Vulnerability | Excel update package | |
PowerPoint | PowerPoint update package | ||
Outlook | Outlook update package | ||
Microsoft AutoUpdate 4.2 | CVE-2018-8412: Microsoft AutoUpdate Office Elevation of Privilege Vulnerability | ||
Office suite |
Release Date: July 10, 2018
Version 16.15.0 (Build 18070902)
This release provides the following updates.
Application | Features updates | Security updates | Download link for update package |
---|---|---|---|
Word | Word update package | ||
Excel | Excel update package | ||
PowerPoint | Pep up your pitch with video: Add live action to your slide with a YouTube video, and then view it without having to leave the app. Learn more | PowerPoint update package | |
Outlook | Improved security for Google accounts: Security improvements mean that you no longer need to allow access to 'less secure apps' or set an app password in order to add your Google Account to Outlook. Learn more | Outlook update package | |
Microsoft AutoUpdate 4.1 | Update to Aria SDK 8.4. Fixes memory leak issue. Changes to App Registration. Now supports Office 2019 Preview. | ||
Office suite | CVE-2018-8281: Microsoft Office Remote Code Execution Vulnerability |
Release Date: June 13, 2018
Version 16.14.1 (Build 18061302)
This release fixes an issue with the updater packages for the individual applications.
Release Date: June 12, 2018
Version 16.14.0 (Build 18061000)
This release provides the following updates.
Application | Features updates | Download link for update package |
---|---|---|
Word | Learning Tools improve readability: Give your eyes a rest. Adjust text spacing, column width, and page color. Or listen as Word reads your document aloud, highlighting text as it's read. Learn more | |
Excel | Fill data in a flash: Give Flash Fill a few examples, and it will fill your data for you. Learn more Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Learn more | |
PowerPoint | Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Learn more Hyperlinks in living colors: Hyperlinks aren't just blue anymore. Apply any font color you like. Learn more | |
Outlook | Create a signature they'll remember: Express yourself with rich font styles, colors, images, links, and more. Learn more Create and collaborate with Groups: Want to create an Office 365 Group in Outlook? No problem! Add and remove members, too. Collaboration on the Mac just got easier. Learn more | |
Microsoft AutoUpdate 4.0 |
Release Date: May 24, 2018
Version 16.13.1 (Build 18052304)
This release fixes an issue with diagnostic data settings.
Here are the download links for the update packages: Word, Excel, PowerPoint, Outlook, and OneNote.
Release Date: May 23, 2018
Version 16.13.1 (Build 18052203) *
This release includes a General Data Protection Regulation (GDPR) compliant end user notification.
*The build number for Outlook is 18052301.
Release Date: May 15, 2018
Version 16.13.0 (Build 18051301)
This release provides the following updates.
Application | Features updates | Security updates | Download link for update package |
---|---|---|---|
Word | Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Word. Learn more Insert and edit icons: Use icons to add visual impact to your document by inserting and editing one of 500 icons. Learn more Write your best resume or CV with help from LinkedIn: Resume Assistant shows you work experiences, top skills, and more for a given role. Find it on the Review tab. Learn more Accessibility built right in: Use your keyboard to access the ribbon quickly and to format the words or pictures you just inserted. | ||
Excel | Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Excel. Learn more Insert and edit icons: Use icons to add visual impact to your workbook by inserting and editing one of 500 icons. Learn more Use a timeline to filter your data: Easily filter a PivotTable by sliding the date range with a timeline filter. Learn more | CVE-2018-8147: Microsoft Excel Remote Code Execution Vulnerability CVE-2018-8162: Microsoft Excel Remote Code Execution Vulnerability | |
PowerPoint | Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving PowerPoint. Learn more Insert and edit icons: Use icons to add visual impact to your presentation by inserting and editing one of 500 icons. Learn more | CVE-2018-8176: Microsoft PowerPoint Remote Code Execution Vulnerability | |
Outlook | Customize swipe gestures: Set the swipe left and swipe right gestures to the actions you use most. Choose from Delete, Archive, Mark as Read, Flag, or None. Learn more Support for Google Calendar and Contacts: Manage your Google Calendar and Contacts without leaving Outlook.* Learn more *This feature is being rolled out to Office 365 subscribers over a period of time, so you might not see this feature right away. | ||
Microsoft AutoUpdate 4.0 |
Release Date: April 11, 2018
Version 16.12.0 (Build 18041000)
This release provides the following updates.
Application | Features updates | Security updates | Non-security updates | Download link for update package |
---|---|---|---|---|
Word | Better sharing and collaboration: Your locally synced OneDrive documents open directly from the cloud, allowing you to AutoSave, share, and collaborate easily. Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your documents to add visual interest and retain a high image quality. Learn more | |||
Excel | Better sharing and collaboration: Your locally synced OneDrive workbooks open directly from the cloud, allowing you to AutoSave, share, and collaborate easily. Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your workbooks to add visual interest and retain a high image quality. Learn more | CVE-2018-1029: Microsoft Excel Remote Code Execution Vulnerability | ||
PowerPoint | Better sharing and collaboration: Your locally synced OneDrive presentations open directly from the cloud, allowing you to AutoSave, share, and collaborate easily. Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your presentations to add visual interest and retain a high image quality. Learn more | |||
Outlook | Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your emails to add visual interest and retain a high image quality. Learn more A more actionable calendar: Click any meeting or event in your calendar to see all of the associated details. Check out who is invited, edit your response, or join the meeting, all in one place. Easier scanning of search results: Outlook highlights your search term in the item list or Preview pane. Week numbers: Week numbers are now displayed in Calendar month view and mini-calendar in the sidebar. To enable, check 'Show week numbers' in Outlook > Preferences > Calendar > Calendar options. Scheduling Skype meetings: Delegates can now schedule Skype for Business Online meetings on behalf of principals using principals' email addresses. (Skype for Business Online only. This will be enabled for Skype for Business Server 2015 in a future server update.) | Improved error handling when editing and deleting server rules. Server rules containing errors are now highlighted when first displayed in the rules list. | ||
OneNote | ||||
Microsoft AutoUpdate 3.18 | Support for the msupdate command-line tool. Learn more |
Release Date: March 19, 2018
Version 16.11.1 (Build 18031900)
This release fixes an issue where Word, Excel, and PowerPoint occasionally become indefinitely unresponsive on launch.
Release Date: March 13, 2018
Version 16.11.0 (Build 18031100)
This release provides the following updates.
Application | Features updates | Security updates | Non-security updates |
---|---|---|---|
Word | Do more with Focus Mode: Focus Mode now opens at your set zoom level and shows the page number while you scroll. | ||
Excel | CVE-2018-0907: Microsoft Office Excel Security Feature Bypass | ||
PowerPoint | Embedded fonts: Embedded fonts ensure that your presentation looks the same on every computer and people experience your content as you intend. | ||
Outlook | Tables: Insert tables in your messages and calendar events, and bring structure to your content. No more copying and pasting from other Office apps. Learn more View two time zones at once: Want to know what time it is in another part of the world? Now you can add a second time zone to Outlook . Schedule across time zones: Traveling across time zones? Create an event with different start and end time zones, and Outlook will take care of the conversion. Change text size: Increase or decrease the font size in your sidebar, message list, and reading pane. Learn more | Fix an issue, where if the default time zone for your computer observes daylight saving time (DST) and Week view is selected, you may see that all events are shifted by one hour on the calendar grid on the week when DST starts. | |
Office suite | CVE-2018-0919: Microsoft Office Information Disclosure Vulnerability |
Release Date: February 13, 2018
Version 16.10.0 (Build 18021001)
This release provides the following updates.
Application | Features updates | Non-security updates |
---|---|---|
Excel | Precision selecting: Ever selected too many cells or the wrong ones? You can now deselect extraneous cells without having to start over. Learn more Slice and dice your table data: You loved slicers for PivotTables. You can now use them in tables too to see exactly what filters you have applied. Learn more | |
PowerPoint | Shine the light on what matters: Grab the new highlighter to flag important information. Learn more | |
Microsoft AutoUpdate 3.16 | Fix an issue with UpdateCache failover to the Office Content Delivery Network (CDN). |
Release Date: January 26, 2018
Version 16.9.1 (Build 18012504)
This release addresses compatibility issues in Word and PowerPoint with some third-party fonts or in mixed-language environments.
Release Date: January 18, 2018
Version 16.9.0 (Build 18011602)
This release provides the following updates.
Application | Features updates | Security updates |
---|---|---|
Word | Edit with others in real time: Thumbnails in the upper-right corner of the window show who else is working with you in a shared document. Flag icons show where others are working and you can view changes as they type. Learn more We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu. | CVE-2018-0792: Microsoft Word Remote Code Execution Vulnerability CVE-2018-0794: Microsoft Word Remote Code Execution Vulnerability |
Excel | Collaborative editing: Work with others at the same time in your workbook. Thumbnails in the upper-right corner of the window show who else is viewing or editing the file with you. Learn more We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more More charts: Use new charts, such as funnel, sunburst and histogram, to transform your data into professional visualizations, or use the new Map chart type to transform geographic data into a map with just a few steps. More functions: Shorten the formulas you write using the new logical functions IFS function and SWITCH function. Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu. Better support for PivotTable charts: Change your filters in a PivotTable, and the chart you created will automatically adjust to show exactly what you want. Multi-threaded calculation Formulas are updated faster when values are changed, because Excel uses multiple processing threads. | |
PowerPoint | Edit with others in real time: Thumbnails in the upper-right corner of the window show who else is working with you in a shared document. Flag icons show where others are working and you can view changes as they type. Learn more We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more See what's changed: Slides that have been modified by others while you were away are highlighted. Learn more A quick start to your research: Starting from scratch is hard. QuickStarter automatically creates an outline for your topic of choice with suggested talking points and designs that make your presentation pop. Learn more Trim media: Remove unwanted content from the beginning or end of an audio or video clip. Learn more Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu. Laser pointer in Slide Show: Use your mouse as a laser pointer to draw attention to certain parts of your slide. Text Highlighter: Text highlight is now on Mac! Use text highlighter to emphasize important pieces of text. | |
Outlook | Archive or delete with just one swipe: Save time organizing your Inbox by swiping left with two fingers across the touchpad to archive an email or swiping right to delete it. | CVE-2018-0793: Microsoft Outlook Remote Code Execution Vulnerability |
Release Date: December 17, 2017
This release fixes an issue with Microsoft AutoUpdate (MAU) offering an incorrect version update.
Release Date: December 12, 2017
Version 15.41.0 (Build 17120500)
This release provides the following updates.
Application | Security updates |
---|---|
PowerPoint | CVE-2017-11934: Microsoft PowerPoint Information Disclosure Vulnerability |
Release Date: November 14, 2017
Version 15.40.0 (Build 17110800)
This release provides the following updates.
Application | Security updates |
---|---|
Word | Advisory 170020: Microsoft Office Defense in Depth Update |
Excel | CVE-2017-11877: Microsoft Excel Security Feature Bypass Vulnerability |
Release Date: October 10, 2017
Version 15.39.0 (Build 17101000)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Word | Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more. | |
Excel | Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more. | |
PowerPoint | Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more. | |
Outlook | Improved readability and accessible, too: Your email message and meeting invitation headers are now easier on the eyes. Less clutter, better keyboard navigation, and improved VoiceOver. | |
Office suite | CVE-2017-11825: Microsoft Office Remote Code Execution Vulnerability |
Release Date: September 12, 2017
Version 15.38.0 (Build 17090200)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Excel | CVE-2017-8631: Microsoft Office Memory Corruption Vulnerability CVE-2017-8632: Microsoft Office Memory Corruption Vulnerability | |
Office suite | CVE-2017-8676: Windows GDI+ Information Disclosure Vulnerability | |
Microsoft AutoUpdate 3.9.3 | Alerts users to re-install MAU when missing or broken components are detected. |
Release Date: August 15, 2017
Version 15.37.0 (Build 17081500)
This release provides the following updates.
Application | Feature updates |
---|---|
Word | Researcher: Find relevant quotes, citable sources, and images without leaving Word. Learn more Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more |
Excel | Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more |
PowerPoint | Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more |
Release Date: July 21, 2017
Version 15.36.1 (Build 17072101)
This release fixes an issue with Outlook keeping group messages up to date.
Release Date: July 11, 2017
Version 15.36.0 (Build 17070201)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Excel | Pictures in headers and footers: Customize your printed workbooks by adding images to headers and footers. | |
Outlook | Send email on your schedule: Delay the delivery of a message or choose when it will be sent. Learn more All your favorite folders in one place: Create shortcuts to all the folders you use regularly. All shortcuts are listed in Favorites at the top of your Sidebar. Learn more Format Painter: Available when creating emails, events, and tasks. | |
Office suite | CVE-2017-8501: Microsoft Office Memory Corruption Vulnerability |
Release Date: June 16, 2017
Version 15.35.0 (Build 17061600)
This release fixes an issue where OneNote crashes when creating a new page with templates.
Release Date: June 13, 2017
Version 15.35.0 (Build 17061000)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Word | CVE-2017-8509: Microsoft Office Remote Code Execution Vulnerability | |
Outlook | Spend less time writing emails: Create an email template and reuse it later to save time. Learn more Request Read Receipts and Delivery Notifications: Get notified when your important email messages have been delivered to and opened by recipients. Learn more Easier account setup: Now, when you add an Exchange or Gmail account, settings are updated for you. Just provide your username and password, and you are good to go. Learn more |
Release Date: May 16, 2017
Version 15.34.0 (Build 17051500)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Word | Modern backgrounds for Focus Mode: Choose from Twilight or Polar Night backgrounds, when you're in Focus Mode on the View tab. Learn more Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more | |
Excel | Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more | |
PowerPoint | Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more | |
Outlook | Groups: View your top 10 groups, and read or reply to group conversations directly from the Groups folder. Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more | |
Office suite | CVE-2017-0254: Microsoft Office Memory Corruption Vulnerability |
Release Date: May 9, 2017
This release provides the following updates.
Application | Non-security updates |
---|---|
Microsoft AutoUpdate 3.9.1 | - Fix a critical issue that prevents automatic update notifications when 'Automatically Check' is selected. - Fix an issue where AutoUpdate crashes on OS X 10.10. - Fix an issue where apps won't launch if an update is pending. Important: If you updated to Microsoft AutoUpdate 3.9.0, and you have your AutoUpdate settings set to 'Automatically Check,' then you will need to manually update to Microsoft AutoUpdate 3.9.1 by using either of the following methods: - Go to Help > Check for Updates, and then choose Check for Updates. - Go to Help > Check for Updates, and then select Automatically Download and Install. |
Release Date: April 11, 2017
Version 15.33.0 (Build 17040900)
This release provides the following updates.
Application | Feature updates | |
---|---|---|
Microsoft AutoUpdate | - Support for Suite Delta Updates, which will reduce the monthly update size by 50%. - Support for MAU self-updates, where MAU can update itself without requiring admin credentials. | This version of MAU isn't available to download. |
Release Date: March 14, 2017
Version 15.32.0 (Build 17030901)
This release provides the following updates.
Application | Feature updates | Security updates |
---|---|---|
Excel | Microsoft Security Bulletin MS17-014: Security Update for Microsoft Office (3217868) | |
Outlook | Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.) Translator add-in: Translate email without leaving Outlook. Just turn on the Translator add-in to translate with a single tap. Choose from 60 languages. Learn more Install the add-in from the Office Store Access more features right from your Inbox: Add-ins for Outlook let you create tasks with Wunderlist, track email responses with Boomerang, and more. Learn more | |
Office suite | Microsoft Security Bulletin MS17-014: Security Update for Microsoft Office (3217868) |
Release Date: February 16, 2017
Version 15.31.0 (Build 17021600)
This release provides the following updates.
Application | Feature updates | Non-security updates |
---|---|---|
Word | Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.) | |
Excel | Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.) | |
PowerPoint | Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.) | |
Microsoft AutoUpdate | Version number updated to 3.8.4. |
Release Date: January 11, 2017
Version 15.30.0 (Build 17010700)
This release provides the following updates.
Application | Feature updates | Non-security updates |
---|---|---|
Word | Additional focus mode choices, including Oak, Mahogany, and Graphite. For Office 365 subscribers only. Learn more | Fix various performance issues, such as typing or scrolling lags and slow performance when editing a large document. |
Microsoft AutoUpdate | Additional logging and troubleshooting capabilities. | Version number updated to 3.8.3. |
Release Date: December 15, 2016
Version 15.29.1 (Build 16121500)
This release fixes an issue with opening or saving files in Word, Excel, or PowerPoint when the first part of the file path contains spaces or certain characters.
Release Date: December 13, 2016
Version 15.29.0 (Build 16120900)
This release provides the following updates.
Application | Feature updates | Non-security updates | Security updates |
---|---|---|---|
Word | Retain your document fidelity, with working hyperlinks, when converting to PDF. Learn more Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more | ||
Excel | Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more | Fix an issue where, when using Data Validation, if you enter text into the error message box, Excel crashes. | Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068) |
PowerPoint | Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more | ||
Office suite | Support for three additional languages: Greek, Hungarian, and Slovak | Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068) | |
Microsoft AutoUpdate | - Version number updated to 3.8.2. - Improved reliability and minor bug fixes. | Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068) |
Release Date: November 17, 2016
Version 15.28.0 (Build 16111700)
This release fixes an issue with Outlook and public folders on Exchange Server 2010.
Release Date: November 15, 2016
Version 15.28.0 (Build 16111501)
This release fixes an issue with the update packages for the individual applications.
Release Date: November 15, 2016
Version 15.28.0 (Build 16111300)
This release provides the following updates.
Application | Feature updates | Non-security updates | Security updates |
---|---|---|---|
Word | New grammar support for Czech, Hungarian, Korean, Norwegian, Polish, Russian and Turkish. | Fix an issue where Word fails to save documents when Excel spreadsheets with certain border content is embedded into the document. | Microsoft Security Bulletin MS16-133: Security Update for Microsoft Office (3199168) |
Excel | Fix a long-running issue where Excel fails to save changes on certain enterprise storage configurations such as NetApp FAS units. Excel now adopts the same file saving pattern as Word. | Microsoft Security Bulletin MS16-133: Security Update for Microsoft Office (3199168) | |
PowerPoint | View interactive summaries and automatic navigation links that were created using the Zoom command in PowerPoint 2016 for Windows. | Fix an issue where images don't render and are replaced with an error referring to rID#. | |
Outlook | Find and fix accessibility issues that occur when composing messages or invitations by using the Accessibility Checker. Learn more | Fix an issue with automatic language detection when composing emails. | |
Office suite | - Significant improvements for users with accessibility needs. - Microsoft Error Reporting can be configured to save the last crash log to disk (defaults write com.microsofterrorreporting IsStoreLastCrashEnabled -bool TRUE). - Better activation message for E1/K1 users. No longer suggests to users that an error occurred and welcomes them to the view-only experience. - Installer and updater file name format change. For example, Microsoft_Office_2016_15.28.16111300_Installer.pkg instead of Microsoft_Office_2016_15.28.0_161113_Installer.pkg. | ||
Microsoft AutoUpdate | Includes a new option to automatically detect, download, and install updates. | - Version number updated to 3.8.1. - Fix an issue where MAU can crash when older versions of Microsoft Silverlight are installed, specifically when Silverlight is registered with a null LCID. - Fix an issue where MAU can crash when using the ManifestServer preference. - Microsoft AU Daemon bundle display name changed to 'Microsoft Update Assistant.' - MAU XML feed for 2016 apps no longer include a Triggers dictionary and relies on 'Update Version' for version detection. - MAU now shows the complete version string in the app update window. For example, 15.28.16110300 instead of just 15.28. |