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.
Reasons why a Word document or email can look different on one computer than another device and what you can do get ‘fidelity’ or the same look across many machines. In short – you can’t assume that what you see is the same as someone else. You get a document
Here’s another example of a seemingly simple Office feature that has hidden depths – Highlighting. For a long time, there’s been a highlight option in Office: Word, Excel, Outlook and even PowerPoint (albeit in a different form). They vary a little in each program so this article will go through
Let’s take a moment to see where customers stand with Dark Mode options in Microsoft Office in Windows, Mac, iPhone, iPad, Android and web. It’s easy to get confused about Microsoft 365 and Office 2021 dark mode or theme options. Microsoft has announced ‘dark’ developments so many times it’s hard
More details on the image insert or linked options in Office, Word documents and Outlook emails. We’ve already talked about the three options available for documents; Insert, ‘Link to File’ and ‘Insert and Link’. Insert adds a copy of the image into the document Link displays the current external picture
Here’s how to make Outlook Contact Groups work with both CC and BCC’s as well. Outlook Contact Groups are a way to combine a list of contacts under a single name. They are often used in business but are also useful for individuals or families. For example groups like: ‘Regional
There are at least eight ways to share an entire calendar or individual appointment in Outlook software. Sharing can be ‘live’ and connected. Any changes or updates to the event or calendar are automatically sent to everyone sharing. Or it can be a ‘one-off’ item. A special attachment which is
How to type the Cent symbol ¢ into Microsoft Word, Excel, PowerPoint or Outlook plus any Windows program. Cent ¢ shortcut Word and Outlook The Cent ¢ symbol has an inbuilt shortcut in Word and Outlook: Ctrl + /, C Hold down the Ctrl key while pressing / then type
Adding comments to Microsoft Word documents isn’t just for groups, use them yourself for your own reminders and side-comments while you’re working on a doc. Word has a feature to let you add ‘side’ comments to documents – comments that don’t show up in the final document, don’t effect the
What causes blank spaces in the Word navigation pane and how to fix them. The Navigation Pane in Word shows the Headings in a document but sometimes has the unexpected. Blank lines or text not in a heading. But sometimes blank spaces appear, like between London and Paris above. Why
Excel Mobile’s Data from Picture has one big problem, it can’t figure out what’s intended to be in one cell and puts text in many cells. Cell discernment is Data from Picture’s biggest weakness and the Review process makes it hard to fix those problems. For example, text using Excel’s
Here’s the full and searchable list of Word 365 Dictation special phrases, in English. Saying any of these phrases converts the words spoken into the symbol or does a Word command. For example, say “Full Stop” and . appears in the document. Say “Dollar sign” and get $ . Say
How to run administration commands via PowerShell for Microsoft 365 hosting and especially Microsoft 365 Exchange Server or mailbox hosting. Microsoft 365 customers will often see instructions like this to configure their Exchange Server mailboxes using PowerShell. Set-OrganizationConfig -AllowPlusAddressInRecipients $true Looks simple, but that command alone won’t work in PowerShell
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
Our annual Microsoft Word vs the Spelling Bee Champions contest is on again for 2022. Word has done better than in the past but was still beaten by another extraordinary 14 year-old. 2022’s Spelling Bee Champ is Harini Logan, 14, from San Antonio TX who narrowly beat Vikram Raju a
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used
A first look at the new “New Outlook” which Microsoft (deliberately?) leaked ahead of an official announcement. It’s interesting but with one major and very disappointing omission. This article has been updated now “New Outlook” (as it’s now called) has been released to Office 365 Insider users. As you can
There are two different ways to access a Microsoft Office document that’s saved on OneDrive. We’ll explain both and why it’s sometimes important. Microsoft’s OneDrive stores documents on servers. Programs (like Office) can open those files directly from the cloud service. Or the OneDrive app can copy (synchronize) files from
Add the Duck 🦆 emoji into Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Duck 🦆 emoji represents the quacky bird with webbed feet. The emoji is usually depicted as a Mallard. Sometimes used as a substitute for the f-word, because of iPhone’s tendency
A simple question – what characters can you put in an email address? Like many things to do with the Internet the answer isn’t as simple or direct as you might think. We’ll look at what makes a valid email address, both in theory and in practice. A simple question
