Home
Microsoft

Office 2016 for Mac - January 2018 Release details

 

On January 18th, 2018, Microsoft released Office 2016 for Mac Version 16.9.18011602 in 27 languages. Our Office International team was responsible for translating this release. You will see the following features when you update to it:

 

In 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.
  • Support for Google Calendar and Contacts: No need to move between apps! Manage your Google Calendar and Contacts without leaving Outlook.

In 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 presentation. Flag icons show where others are working, and you can view changes as they type.
  • AutoSave Changes are saved automatically for 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.
  • See what's changed: Slides that have been modified by others while you were away are highlighted.

PPT See whats changed.png

  

  • Trim media: Remove unwanted content from the beginning or end of an audio or video clip in your presentation.
  • 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 a certain part of your slide.

 

In 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.

excel collaborative editing.png

 

 

  • AutoSave Changes are saved automatically for worksheets 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.

Excel autosave.png

 

 

  • 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 and SWITCH.
  • Quickly access your sites and groups: Quickly find worksheets 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.

 

In 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.

Word edit with others in real time.png

 

 

  • AutoSave Changes are saved automatically for documents 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.
  • Quickly access your sites and groups: Quickly find documents stored in your frequently used sites and groups in the Open menu.

 


For more information on this release please have a look at the What's New in Office 365 for Mac section here. If you ever have translation suggestions that you think Office 2016 for Mac better, then please start a conversation here and we will look into it.
 
Office 2016 for Mac ships in the following 27 languages:

 

  1. Arabic
  2. Chinese (Simplified)
  3. Chinese (Traditional)
  4. Czech
  5. Danish
  6. Dutch
  7. English
  8. Finnish
  9. French
  10. German
  11. Greek
  12. Hebrew
  13. Hungarian
  14. Indonesian
  15. Italian
  16. Japanese
  17. Korean
  18. Norwegian (Bokmal)
  19. Polish
  20. Portuguese
  21. Portuguese Brazilian
  22. Russian
  23. Slovak
  24. Spanish
  25. Swedish
  26. Thai
  27. Turkish
3 Comments
Occasional Visitor

Hello, I just updated to the latest Mac excel. I have a few issues:

 

1) Selecting only visible cells: I used to select data and use CMD+SHIFT+* to select only visible cells, but now I haven't been able to use this function

2) Transpose data: I used to use the transpose formula and now it is not working. I used CMD+SHIFT+ENTER and it isn't working

 

Is these just happening to me, how can I fix it?

Microsoft

Hi @Thomas Mogollon, If you have not done so already please report them both through the Smiley (Tell us what we can do better) on the top right of the application. That way it will definitely get looked at by the relevant team!

 

We also want to help and figure out if this is a known issue or something has been changed recently. After a preliminary look in the Office 2016 for Mac bug database we could not find anything related to this being worked on currently. So we can get a repro of the problem ....can you please confirm?

-what the exact version of Office 2016 for Mac (Excel) you are on?

-what is your OS version?

-what language you are using?

 

We can then follow up with the relevant team involved to ensure they are looking at it. 

Regards,

Stafford 

Occasional Visitor

Hello Stafford, thank you for your answer, I will report it on the Smiley.

 

- My current version of excel is 16.9 (180116)

- OS version MacOS High Sierra version 10.13.3

- Language English

 

I just found out that I can use CONTROL+SHIFT+ENTER to make the transpose function work, but I haven't been able to find out how to select visible cells only using the keyboard in a desired range