All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
The Block Download option is worth considering when sharing an Office document, audio file or PDF that you’d like to limit distribution in OneDrive or SharePoint. Block Download is only available for Microsoft 365 Enterprise or Education customers. Look for it at the bottom of the shared Link Settings. What
The options for sharing documents and files will be changing over the next twelve months for the Office 365 apps, Teams, SharePoint and OneDrive. Year of Sharing The whole suite of changes is what Microsoft is grandly calling the ‘Year of Sharing’. That’s overstating things because there’s little or no
Esports (online gaming) is getting serious. Tomorrow the Financial Modelling World Cup pits eight Excel experts against each other in an online tournament. Instead of fighting battles or virtual sports, this is a test of Excel skills. It’s being called the ‘888 Battle’ 8 Contestants from 8 Countries on 8th
Office for Windows can have an extra on the Home pane – Recommended Documents which tries to suggest documents you’re involved with. Here’s what’s possible with this feature including how to hide it away and leave more screen space for the things you want to see. Source: Microsoft Recent Documents
How to sort a list using a hidden or unseen column in a Microsoft Word table. Sometimes you want to sort a list in a way that isn’t apparent to the reader. To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with
You can hide a table column in Word, all it takes is a little trickery and ignoring Microsoft’s advice! Sometimes you want to hide a table column in a Word document but according to Microsoft you can’t do it. Here’s how to do it anyway. It’s true that there’s no
Google Maps is invaluable for getting around, especially in an unknown city. Corporate rivalry means there’s no proper integration between Microsoft Outlook and Google Maps There’s not even a mapping button in the Outlook appointments view. Contacts have a ‘Map it’ button but not ‘Location’ in an appointment – for
A few annoying things in Excel 365 / 2019 / 2021 / LTSC Map charts that Microsoft should fix. We’ll explain the traps and some workarounds. Making our COVID-19 Vaccination workbook reminded us of some anomalies in Excel Map Charts. Always check the Map area options Whenever using the Map
Join us in a hunt for face mask graphics and icons to use in Word documents and PowerPoint slides. Use fask mask icons in signs. See Social Distancing signs in Microsoft Word More ideas for social distancing signs Icons The obvious place for Office 365 customers to look is Microsoft’s
We’ve all seen the standard Find/Replace in Microsoft Word, either the ‘new’ pane or the older dialog box. Like so much else in Word, there’s a lot more available than the obvious features. Here’s a look at some of tricks. Press Ctrl + F to start a Find. In recent
It’s possible to have multiple logins for one person with Microsoft Teams, here’s how and what to do when it all gets too confusing. Teams is becoming so popular that many organizations, groups and even families use it (see Teams for Home). That means you’ll need several different logins for
Microsoft’s Exchange Server system had another snafu late last week, for a few hours all Inbox messages were sent to Junk Email instead! The problem affected users of Microsoft 365 mail hosting. It was caused by a ‘change’ that was applied to Exchange Server hosted by Microsoft. As with other
Microsoft is expanding the reach of their Teams service with more personal and family related features available at no charge. Teams for Home is a repurposing existing Teams business features so they can bring together families and friends. All these features are free (there are some call limits). There are
Microsoft has been getting serious about drawing features in Office so we thought it was time to look at what’s available and possible across all the Office applications. Word, Excel, PowerPoint and some nice drawing stuff in OneNote Once upon a time, drawing onto a Word document or Excel worksheet
Make a draft email on a phone or tablet (maybe some quick notes) to later revise and send from Outlook for Windows/Mac. Once that was a problem but not any more, as long as you’re using Outlook mobile apps. Syncronizing the Drafts folder is really useful. You can write a
Hyphenating words in Word has many choices; manual, optional, compulsory (non-breaking) and fully automatic. Manual Hyphen The simple one we all know. Type the – on the keyboard (properly known as the Hypen-Minus) to hyphenate a word, e.g. choreo-animator. See Of hyphens, em-dash, en-dash and more Automatic hyphenation Word will
Here’s how to add a taste of the logo or text from ‘Friends’ sitcom to a Word document, PowerPoint slide or other document. That includes the important dots between letters. All you need is available online plus a little Office trickery. Note for old-timers (like Peter, our Editor-in-Chief). ‘Friends’ was
Microsoft promotes OneDrive as protection against ransomware however our tests show it’s not always as practical or complete as the company boasts. One recovery feature works fine but the other isn’t complete. While updating our book Everyday Backups, we tested the OneDrive ransomware protections, not taking Microsoft’s word about how
Excel 365 for Windows is getting an expanded Linked Data Types feature with more categories of data and extra features. Here’s what’s possible and the traps that Microsoft doesn’t mention. Stock, Currency and Geography data types have been in Excel 365 (Windows and Mac) for some time. Now it’s expanding
Sometimes Excel 365’s Linked Data Types are great (Stock and Currencies) and other times they’ll drive you crazy or lead you to use wrong statistics. Here’s some problems we found trying out the, supposedly, simple City data type compared to the similar Geography and Location data types. Just getting the
Something new in Excel 365 Linked Data Types is nested data types. If a data field can itself be linked to another data type, Excel will add it automatically. See the ‘Director’ names (from the Movie data type) have little icons next to them? That’s because Excel has added the
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to
Insert the Xi upper case Ξ, and Xi lower case ξ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Xi (uppercase Ξ / lowercase ξ) is the 14th letter of the Greek alphabet. The symbols are used within various contexts. The uppercase letter
” How can I enter a duration in Excel with the format days:hours:minutes:seconds ? If I enter 5:32 Excel converts that to 5:32am but I want to record 5 hours and 32 minutes.” Time durations aren’t very clear in Excel, but they are possible. The time features are mostly aimed
