All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Send a document sharing link from Microsoft Office
The Share pane in modern Office is fine within an organization or with people who are familiar with document collaboration. But what if you want to share a document link with more detail in the email or using a non-email method like Instant Messaging? Well, you want to get just a link to your document […]
Fixing Office, OneDrive document sign-in problems
Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage. Can’t Sign-in A very common […]
Make an Excel PivotTable with multiple or nested rows
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just drag a second item down […]
Make your first Two-dimensional PivotTable in Excel
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This time we’ll make a more […]
Get the new Crayola color, Bluetiful, now in Microsoft Office
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office color palette regardless of Crayola […]
Why bother with Excel PivotTables?
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables but before that she’ll of […]
Reduce the disk space used by Outlook for Mac
Outlook for Mac is a disk space hog but the macOS has a way to recover some of that. Mac computers can have relatively small hard drives like 128GB or 265GB which Outlook 2016 for Mac can gobble up. Unfortunately, Outlook for Mac, even the latest Outlook 2016 doesn’t have some of the space saving […]
Office for Mac – interesting things coming
Office 2016 for Mac is getting some big improvements in the next few months. That’s not just Microsoft hype, it seems very real. Last week, Microsoft quietly declared that they were making some big changes to how Office 2016 for Mac works. Those ‘under the hood’ changes would let them add new features a lot […]
Read Receipt responses in Outlook Windows / Mac
Here’s how to control what Outlook does when it gets a Read Receipt request with an incoming email. The setting is at File | Options | Mail | Tracking, just below where you set the options for outgoing Read Receipts. That’s Outlook for Windows, see below about Outlook for Mac. The choices are: Always send […]
Power Excel lists for comparison shopping
Make smarter decisions with Excel’s tables and lists. Excel is a great place for comparison shopping or deciding which product to buy. Unlike Word or OneNote, Excel has tools to sort, filter and do calculations to help you narrow down many choices to just a few or one. In this article we’ll show you a […]
Animated GIFs in Outlook messages, but not all Outlooks
Outlook for iOS and Android has a of plugin with support for animated GIF’s which is very strange indeed. Gfycat has released a plugin for Outlook iOS and Android that lets you choose animated GIF’s to insert into your messages. Source: Microsoft/Gfycat You can add animated GIF’s to emails from the Outlook app, but they […]
Changes to Office for Mac – get ready now
There are changes coming with both Office for Mac and Apple’s MacOS which Mac users need to be aware of. Office 2011 for Mac Office 2011 for Mac will lose support on 10 October 2017, just over month from now. After that date there will be no more updates, especially security updates for Office 2011. […]
Back to School tips for buying Microsoft Office
It’s back to school time in the USA, rushed parents in stores with long lists of supplies. Here’s some tips for getting Microsoft Office for less. Do you already have Office? Maybe you’ve already got Microsoft Office? Before buying, make sure you’re not already entitled to use Office. Some schools have bought a school-wide licence […]
Delete or reorder PDF pages – free!
Here’s how to delete whole pages or rearrange the page order from a PDF document without paying for PDF editing software. A lot of people never need PDF editing software. Making PDF’s is easy using Microsoft Office or the ‘Print to PDF’ feature in Windows. Simple editing, like deleting pages or rearranging the order of […]
How to make Office for Mac speak
On Macintosh computers, the speaking is entirely done by the macOS not Office for Mac To enable speech to text, go to System Preferences | Accessibility and look for the Speech option. Speak selected text when the key is pressed – lets you choose a shortcut key.
Excel security patches for July 2017
Excel is main focus of this month’s security patches from Microsoft. It’s a familiar story, so Microsoft recycles their stock phrases from similar security lapses in the past. A ‘specially crafted’ document can cause a ‘memory corruption’ in Office. The July 2017 patches fix not one, but two separate design errors in Office. All supported […]
