Microsoft has released Office 2016 for Mac – a full set of Office programs for Macintosh OS X computers. There’s updated programs for Word, Excel, PowerPoint, Outlook and OneNote.
First of all, go to File Options Quick Access Toolbar. After that, from “Choose commands from” select “Commands Not in the Ribbon”. Now, select “Strikethrough” from the list and add it to the QAT. The toolbar is not created by VBA. It was attached to the workbook in an earlier version of Excel using the steps outlined in http While the proper solution is detaching the toolbar from the workbook, I'm not sure how that is done in Excel 2007. As a workaround, a macro can be used to delete the toolbar.
All the new programs support Mac goodies like Retina display, Full Screen and Multi-touch. Overall, there’s little surprising or truly new in Office 2016 for Mac. The ‘new’ features boasted by Microsoft are really features from Office for Windows that have finally made it to Office for Mac. For example the Design tab, threaded comments in Word.
Excel’s formula builder, external data connections and ‘new’ PivotTable Slicers. Outlook’s push mail, conversation view and mail preview. All these things and more will be very familiar to users of Office 2010/2013/2016 for Windows. Also brought ‘Into line’ is the interface which is more consistent with Office for Windows and the various phone/tablet apps. Office 2016 times two There’s now two ‘Office 2016’ products. One for Mac and the upcoming Office 2016 for Windows. That’s a nuisance because, until now, we’ve been able to tell Mac and Windows versions of Office apart simply by the ‘year’ – for example Office 2011 always meant the Mac version because there was no ‘2011’ Office for Windows.
Install Office 365 customers (personal, student or organization) can go to their My Account page, choose Office 2016 for Mac. There’s a 1.1GB download, then installation. Stand-alone, single purchase Office 2016 for Mac will be available in September.
One advantage of the Office 365 subscription/rental is that you can switch between Windows and Mac without cost. If you’re thinking of switching to a Mac computer, you can simply download and install Office for Mac without paying more. Ribbon comparison The Word Home ribbon looks much the same in Word 2016 for Windows (top) and Word 2016 for Mac (bottom). The Styles gallery is a little different in Word 2016 for Mac. There are left/right buttons to scroll through the styles plus a down arrow to display a full list.
Quick Access Toolbar There is no Quick Access Toolbar (QAT) in Office 2016 for Mac. At least not like Office for Windows. You might think those buttons above the tabs are a QAT. Unlike the Office for Windows QAT, the Mac equivalent isn’t configurable at all. There’s no way to add more buttons or menus. Cloud connections No surprise that there’s direct connections to OneDrive and OneDrive for Business accounts, but disappointingly not Dropbox or Box. To enable an OneDrive connection, click on the ‘File’ button on the top row.
Click on your account icon at the top of the File menu, then the plus sign next to ‘Connected Services’. Then choose OneDrive or OneDrive for Business.
Hopefully more on this list in future. There’s always the option to include other cloud storage options by installing the sync software separately then opening documents from the synced copy. Here’s a look at some of the ribbons in Office 2016 for mac a more detailed view than Microsoft is providing. Note that the top buttons (File, Save, Undo, Redo) aren’t customizable like the Office for Windows equivalent ‘Quick Access Toolbar’. Word 2016 for Mac.
The Design tab, familiar to users of Word 2013 for Windows is now available for Mac users: There’s a Developer Tab and tools for Word and Excel. Turn on from Preferences View Document Compatibility Office 2016 for Mac is almost fully document compatible with Office for Windows and other Office apps. For many common purposes, you can open an Office document, worksheet or presentation in any Microsoft Office program. If the program strikes something it can’t deal with (like the Equation Editor) then it should ignore that part but still save it back to the edited document. Microsoft calls this ’round tripping’ of Office documents. Like many Microsoft promises, ’round tripping’ was dynamite in demos but less than perfect in the real world. Over the years ’round tripping’ has gradually become more reliable.
Font embedding still missing There’s one missing part of Office 2016 for Mac that makes document compatibility very difficult. We regularly hear complaints about Word for Mac documents that look wrong when opened in Word for Windows. They are complaints that Microsoft does hear with convenient selective deafness. We’ve talked before about – or rather the lack of it in Word for Mac. Word 2016 for Mac still lacks the essential ability to include fonts within the document.
A document formatted in Word for Mac can look quite different when opened in Word for Windows because the same fonts aren’t being used. Word for Windows users can avoid that with the Save option ‘Embed fonts in the file’ but that’s missing from Word for Mac. Excel 2016 for Mac PowerPoint 2016 for Mac PowerPoint 2016 for Mac gets it’s own Animation pane, just like it’s big brother Windows program. Outlook 2016 for Mac Unified Inbox Outlook 2016 for Mac has a ‘unified’ Inbox where the contents of multiple email accounts can be merged into a single view. This defaults on and might suit you.
Others will want to turn the unified Inbox off because the email accounts are for different parts of your life (e.g. Personal, Work, Hobby etc.). Go to Outlook Preferences General Group similar folders, such as Inboxes, from different accounts. Outlook 2016 for Mac also has Conversation view. It’s not as compact as Outlook 2013/2016 for Windows, taking up the reading pane.
Some people don’t like and Office-Watch.com was once among them. However we’ve come around and now use the view constantly. Corporate users will greatly miss the Ignore button – still missing from Outlook 2016 for Mac.
Ignore tells Outlook to send past and future Conversation messages to the Deleted Items folder. A handy way to skip past in-house email exchanges that you can live without. OneNote 2016 for Mac OneNote for Mac has most of the features you’ll need. But it can’t embed videos and searching isn’t as complete at Windows users will be used to.
Video Transcript In this section we’re going to look at the Quick Access Toolbar which is a toolbar I’ve pointed out a couple of times before. It’s in the top left hand corner of the main window and it’s used as the name implies for quick access to a small number of commands. Now by default you will see a small selection of commands displayed there. Let me just hover over the ones here. There’s a Save, an Undo Underline.
Now the reason it says Undo Underline is because the last thing that I did on this sheet was to underline something and therefore to do an Undo that’s the thing I would be undoing. In fact if I click on the little dropdown to the right there it’s got a list of the last few things that I’ve done. So I can either Undo one of them or I could go back and Undo more than one of them. It’s not highlighted at the moment but there is a Redo button which will be available if I’ve undone something I’ll be given the option to redo it if I change my mind. There’s then the Touch/Mouse Mode button that we’ve used earlier in the course and then a couple of other buttons. If I click on the dropdown at the right it gives me a list of the available buttons.
And the ones that are ticked are the ones that are currently visible. If I wanted to say show an Open button as a Quick Access button, if I just click on Open that’s available.
If I decided that I wasn’t going to be regularly switching between Touch and Mouse Mode I could make the Touch/Mouse Mode button invisible as well. So that’s a very simple way of customizing what’s shown in the Quick Access Toolbar.
Now if we go back to that menu you notice at the bottom there is a command there, Show Below the Ribbon. Some people prefer to have the Quick Access Toolbar below the Ribbon. One of the reasons is that if you’re doing something where you’ve set up some Quick Access Commands rather than have to move the cursor across the Ribbon to get at your commands putting the Quick Access Toolbar just above the workbook, the worksheet that you’re working on, makes it a slightly less onerous task going up to the commands. Let me just show you what happens. Show Below the Toolbar puts the Quick Access Toolbar there. And then when you’re working on a worksheet you can very quickly and easily get to the Quick Access Toolbar.
And of course it’s very straightforward to put it back above the Ribbon again. Another very simple customization, let me click on that again, is to go down to where it says More Commands. And you may recall me saying in the previous section that I’ll give you a very quick demonstration of customization of the Quick Access Toolbar. It’ll give you some clues about customization of the main Ribbon. Now at the moment if you look on the right you can see the commands that are currently shown: Save, Undo, Redo, Quick Print, Print Preview, and Print Open.
One thing you can do is to change the sequence of those. So supposing I wanted to put Open to the right of Save. If I select Open and use this little up arrow here, Move Up, put it into the position to the right of Save, that’s below it in the list there, click on OK. If you look at the Quick Access Toolbar now you can see that Open is to the right of Save. So you can change the sequence of the commands like that. And the other thing you can very easily do is to add a Command to it.
So let’s suppose that I wanted to add the Command to make something Bold to that. If I look at the list on the left which has a list of popular commands I can look for the one I want which is the Bold command. I can’t see it there so let me just look down at, I know it’s on the Home Tab and in fact there it is, Bold. If I select Bold and click on Add it’ll actually be added to the Quick Access Toolbar. So let me click OK and as you can see I’ve now got a Bold command on the Quick Access Toolbar.
Now that’s a very straightforward example of customization. If you feel like trying to customize the Ribbon I’ll leave that to you at the moment. After you’ve been using Excel 2016 for a while and particularly if you’re going to do some kind of routine repetitive jobs it’s a good idea to take a look at what’s on the Quick Access Toolbar and work out if a little bit of customization there may help you to do the job that you’re trying to do. And just one or two other very quick points here. If you are customizing the Quick Access Toolbar or in fact if you’re customizing the Ribbon there is a Reset button on each page in Excel Options. So if it all goes horribly wrong or you want to go back to where it used to be there is a Reset button, Reset Default Settings.
And in the case of the Quick Access Toolbar you can actually associate a specific Quick Access Toolbar layout with a specific document. So if you’d worked out which commands you need to work on a particular document and you want to set the Quick Access Toolbar up in that way just for that document if you look above the list on the right you’ve got two options there For All Documents or just for in this case the document that’s currently open which is Demo 1.xlsx. So if I made this selection here for a customization every time I open that document my Quick Access Toolbar will take on that custom layout. So that’s it on the Quick Access Toolbar. I’ll see you in the next section.