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.
Sometimes Microsoft gets over-enthusiastic about some ‘new’ feature. Other times they treat their customers like fools. Redmond chose the latter approach to promote a mere ‘catch up’ feature in Outlook for Mac. We were intrigued by this boast on an official Microsoft Twitter account about a new Outlook for Mac
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
Sorting numbers in Excel looks easy but there’s traps if you’re not careful. Let’s look at an example of sorting gone wrong, how it’s easy to do but also fix. Finally how modern Excel has several features to warn you not to fall into a common mistake. This table popped
Here’s how to get the Game of Thrones or House of the Dragon look in Word documents and PowerPoint slides. Plenty of people have borrowed the Game of Thrones or GoT look, including a certain US President. All these uses are contrary to various trademarks by HBO. Despite legal complaints
The \s n switch inside the { SEQ } field code isn’t easy to understand so here’s an example of how it resets numbering after a Heading style. Use {SEQ \s n } to restart numbering from 1 after a chosen Heading style. E.g. { SEQ Identifier \s 1 }
Get the most from the SEQ (Sequence) field code in Microsoft Word using these options and switches. Office-Watch.com has tested all the {SEQ} features and found a few things that are different from the official Office documentation. To start with {SEQ } check out Why Word’s SEQ code is a
Old email addresses or people have an annoying habit of appearing in Outlook, even after you’ve deleted the address or person from the Contacts list. Here’s why obsolete emails keep appearing and how to remove these unwanted and dangerous strays. Here’s an example of Outlook’s problem with ‘sticky’ and unwanted
Microsoft Outlook was blamed for a 2015 leak of passport details of world leaders, including President Obama, according to a report in The Guardian. Here’s what happened then, how it can still happen now and what you can do to avoid the same trap. The details where emailed to the
When the Stock and Geography data types disappear from the Data ribbon in Excel here’s how to fix and restore Linked Data Types. The Data ribbon is missing the entire ‘Data Types’ section. We’ve had several reports from Office-Watch.com readers who start Excel 365 and find that their Stock and
Type the Orthodox Cross ☦ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Orthodox Cross or Russian Othodox Cross ☦ symbol is widely seen in Russia and in particular the Russian Orthodox Church. There’s also a Christian or Latin Cross ✝ symbol
Type the Marriage Symbol ⚭ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Marriage Symbol ⚭ symbol is two interlocked circles with obvious symbolism. It can be used for any situation you like, perhaps when two items or groups merge or an
Whenever someone has a numbering or list problem in Microsoft Word, the solution usually revolves around the little known but oh so flexible SEQ code. SEQ lets you do things in Word that aren’t possible with the numbered or multi-level list features. Even the powerful ListNum field has to give
We have recently discussed how to show hidden formatting characters in Word, but it is also possible to hide text and even images in Microsoft Word, as long as you are using Word desktop on Windows or Mac. See Find and Remove Hidden Text in Word Hidden text positioning and formatting
Cell Margins and Cell Spacing are two important settings in any Microsoft Word Table but they aren’t used much and not well understood. Cell margins are the spaces between your text and the edge of the cell. They can be set separately for the top, bottom, and either side of
Microsoft charges quite different prices for Office 365 Home/Microsoft 365 Family, depending on the country. Some countries residents pay more for Microsoft 365 than others and the differences can be large. We decided to see how cheap or expensive Office 365 Home/Microsoft 365 Family plan can be, depending on where
How long do you have to work to afford Microsoft Office? That’s the question we asked after compiling a list of Office 365 prices across the globe, Office 365 Home and Office 365 Personal. For most people it’s not long but there’s a lot of variation from less than one
An important and useful new option is coming to Word 365’s collaboration options ‘Review only’ aka ‘Reviewing’ mode. There’s also a workaround to get a similar power in other versions of Microsoft Word. Until now sharing a document was only possible in two ways. Either sharing the editing of the
Making unique (not duplicated) list in Excel is possible in three ways that update automatically. One is headspinningly hard. One has some minor quibbles. The best option is a lot easier and relatively new in Excel. We’re talking here about making a list of unique (non-duplicate) values which update automatically
Segoe Fluent Icon is a handy extra symbols font with some icons that aren’t easily available anywhere else. It’s free for Windows and Mac. Here’s how to use it in Word and Office. Segoe Fluent Icons is intended for use by developers making their Windows apps but there’s no reason
An easy way to make fancy text, especially headings, with extra style and flourish is with the OpenType Ligatures in Word for Microsoft 365, 2021 and earlier versions of Word including Word for Mac. Microsoft Word supports OpenType Ligatures. Apart from Word, OpenType Ligatures are also applicable in Publisher and,
There’s a way to convert a sentence into an Excel Formula using modern AI. You’d expect this to come from Microsoft but instead it’s the work on one smart man who has made the Excel Formula Bot. David Bressler has created a way to turn human sentences into an Excel
Once you have the basic setup for the I ♥ or I Love … sign, the fun begins. Making your own variations for a Word document or PowerPoint presentation. Start by making your own I ♥ or I Love … sign based on the original I Love NY logo. Font
It’s pretty easy to make a similar I ♥ or I Love logo, in Microsoft Word or PowerPoint. It’s even a little easier for Mac users. Check out Making the original I Love NY sign to see how the original logo is put together. We’ll show you the little subtleties
Here’s the design details of how the famous I ♥ NY / I Love NY logo was made. The font, colors, symbols and how they come together to make an iconic sign imitated all over the world. The logo was created by Milton Glasner in the back of a taxi
