Excel 2016 attempts to bridge the gap between Excel for Windows and Mac.
As many of you may have noticed, the vast majority of the shortcuts mirror each other on both operating systems. With this gap shortened a bit, here are a few tips that will make your life easier in Excel for Mac 2016.
Formula Builder received a nice upgrade. Instead of remember syntax, now you can simple click Shift + F3 to pop open the Formula Builder side bar. This pop up will help you find the exact formula you'd like to insert, as well as walk you through the syntax step by step.
As mentioned above, Windows and Mac key assignments are now quite similar. Shortcuts like Ctrl+O for Open, Ctrl+F for Find and Ctrl+C for Copy now also work in the Mac version—no need to remember to press Cmd instead of Ctrl. If you want to clear the content of the selected cell or range, just press the delete key. This even works on your Mac laptops, where delete is actually the backspace key. Some popular shortcut keys are listed below; a complete list can be found here.
The new Touchbar is now supported in Office for Mac 2016!
Typing an equals sign into a cell in Excel immediately pulls up the most recently used functions in the Touch Bar. For example, with a tap (for the formula) and another tap (for a named range) in the Touch Bar, you can quickly sum a range in your spreadsheet. The Touch Bar also provides quick access to borders, cell colors and recommended charts—making it easier than ever to organize and visualize your data.
As always, please let us know if you have any questions!
Comments will be approved before showing up.