In Excel 2016 for Mac version 15.19.1, the Solver add-in will now allow you to select cell references again. To update to the latest version, open Excel then go to Help and Check for Updates.
Was a long time coming, but it brings plenty of new features and better feature parity with the Windows version than ever. Microsoft has done a lot to streamline the experience, with a customizable, collapsible Ribbon as well as cross-platform keyboard shortcuts, but with any major Office update, there’s bound to be a learning curve. These tips for, Excel, Outlook, and should come in handy, and if you’re stumped about anything specific, let us know in the comments., with a wider release coming in September. If you need access to your files from anywhere, Office 2016’s built-in OneDrive & SharePoint integration makes cloud storage simple. To save to your OneDrive or SharePoint account, click the Online Locations button in the lower-left corner of a Save dialog box. Choose your existing account from the list, or click the Plus button to add another location.
What's the difference? Glad you asked. OneDrive is a consumer product for cloud storage, like iCloud Drive. Aimed more at businesses, SharePoint acts like an intranet, letting teams share and collaborate on files. The redesigned Ribbon in Office 2016 unifies the look and functionality across all platforms.
It also takes up a lot of space, and can be pretty cluttered. If you need some extra screen real estate, hide the Ribbon by clicking on the small arrow on the far right side.
Click the arrow to display the Ribbon again. You can also show or hide the Ribbon by clicking on the currently active tab. Of course, you can put Office 2016 apps into full-screen mode by clicking the green full-screen button in the upper-left corner of any window. Outlook offers some excellent tools to quickly drill down to just the messages that matter right now. From Outlook’s Home tab, the Filter button quickly displays only certain messages, such as mail received today, this week, or this month. You can also filter for messages with attachments, unread emails, and several others.
One of our favorite features is the ability to filter by category. —you’ll need to split senders into relevant groups, but once you do, you can separate out messages from your boss, family, or whatever other group you need at the touch of a button.
Helen Bradley - MS Office Tips, Tricks and Tutorials I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald. If your Recent files list disappears from your Mac, here’s how to put it back Word on my Mac doesn’t have a recently opened files list but Excel does. Turns out the feature was disabled (or perhaps it was never enabled). Whatever the reason, it wasn’t there and I wanted it to be accessible.
Lucky for me it is just a preference setting. Click the Word button, click Preferences and then General. Look for the Track Recently Opened Documents option and enable it.
Set the number of documents to track and click Ok. Now you can open a recently opened file like you expect to be able to do.