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.
2022 is the Chinese year of the Tiger. Here are some tiger images, emoji and graphics in Word, PowerPoint and Office apps. Drop any of these into your documents or slides for a little New Years fun. See our related article Make your Chinese New Year graphics pop with these
Insert the Identical To ≡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Identical To ≡ symbol, also known as the triple bar, is a mathematical symbol. The three lined symbol means that something is identical or like another value, but this
Here’s how to force the ‘Draw with Touch’ button to appear in Word, Excel and PowerPoint when it doesn’t show up automatically. ‘Draw with Touch’ is an Office option to let you draw with a finger or stylus on a touchscreen. It should automatically appear on the right of the
There’s a fast way to Fill cells with sequential data into a list or rows without dragging the mouse. The Series command can insert all sorts of lists for dates, weekdays and numbers. It’s very handy for users that need to fill a large number of cells. Those that use
Excel provides some handy pre-selected styles that you can apply to your cells. Here’s a selection of styles that we use, improve from Microsoft’s bland defaults and will light up your worksheets. These are excellent for distinguishing headers from data, classifying data, or showing the function of each cell (calculations,
Making QR codes is quite simple, all you need is a simple online code maker and by following our step by step guide you’ll have it set-up in no time. We’ll show how to make QR codes for web links and even easily sharing Wifi settings. Nowadays, QR Codes are
Microsoft Word has a powerful grammar checking system but how does it handle changes in English usage like the rise of non-binary or non-specific pronouns like ‘they’ and ‘them’? We took put sample words and sentences in Word to see how ‘woke’ it is. As a bonus, we’ll explain Pibling
Aside from inserting the current date or time, Microsoft Word has some other useful choices for inserting dates automatically. The date/time the document was created, last saved or last printed. Header / Footer In a Word document header or footer, the same Insert Date options and shortcuts apply as in
Back in 2015 the US government made an important decision in favor of ‘net neutrality’ and got a quick complaint back in Morse Code! Here’s how to add Morse Code dots and dashes to Microsoft Word, PowerPoint or other Office app. Verizon issued a press release complaining about the FCC’s
Type the White Right backhand pointer 👉 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. It’s officially called “White Right Pointing Backhand Index”. White Right Pointing Backhand Index 👉 symbol is great for signs, simple hand graphics in slides or an alternative
Excel’s Paste Special feature can be used to modify multiple numbers at once. Paste Special is more commonly used to paste only values or formatting, it has other tricks to offer. We’ll show you firstly how to multiply numbers in Excel by using Paste Special then add, subtract and division.
Styles in Microsoft Word would be very cumbersome if you had to set up each one individually. To make it easier, styles have inheritance. A new style is usually a copy, linked to an existing style with just some changes to selected items. Here’s an example of inheritance in a
There are good reasons to avoid the Normal style for the main text in a Word document and use the hidden ‘Body Text’ style instead. The standard Microsoft Word document structure has Headings (Heading 1, Heading 2) … with paragraphs of text in the Normal style. It sounds good but,
Excel has a way to rank a series of values, showing which is top, middle and bottom. As usual, what appears to be a simple thing has extra features to cope with the real world like equal placings. Here’s a simple ranking. As you can see, Excel has ranked the
Here’s a look at two things that you’d expect Excel to handle quickly and easily, but doesn’t. Showing a ranking of items with equal ranks shown (3rd equal etc) and ordinal numbers (1st, 2nd, 3rd etc) or ordinal names (first, second, third etc). All are possible in Excel but strangely
If you’d like to be really clever with Rank/Rank.EQ in Excel, here’s how to show different words for joint rankings (only two with the same rank) or equal rankings by three or more. It’s a small difference but can make your reports or merged documents look a lot more professional.
You can show ordinal numbers in Excel; 1st, 2nd, 3rd. Sadly, it’s not as simple as you’d think. The ‘Ordinal Rank’ column, 1st, 2nd etc you’d expect to be provided by Microsoft, but it’s not. There’s no in-built function nor a number format. After all, Excel has many different number
The work of Eric Gill is controversial these days, for good reason. Microsoft Windows and Office have fonts based on Gill’s work so users might need to think twice about using Gill Sans and similar fonts. Gill Sans MT and Gill Sans Nova are supplied with Windows and Office but
Office for Mac users yearn for the day when their software matches ‘feature parity’ with Office for Windows. “Two platforms, One Office” is the dream. But is it possible or even likely? We’re inspired by this tweet from José Rodríguez-Suárez. If Microsoft responds, we can predict what they’ll say, because
insert the Black Right Pointing Backhand Index 🖝 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Right Pointing Backhand Index 🖝 symbol can be used as a creative bullet symbol in lists or to point a direction on a sign. It’s
To play a selection of different audio tracks, one after another is surprisingly clumsy even in Microsoft 365 PowerPoint. For example, you might like to have multiple tracks from a single album or several movements from a symphony. We expected that a simple Animation would work with the second music track
A common request is for music to play throughout a PowerPoint presentation. Handy for automatic and kiosk slideshows. That’s easy in PowerPoint these days. Insert the audio then look on the Playback tab. There’s a choice ‘Play in Background’ that does the job in one click. ‘Play in Background’ is just a way of turning on
Almost Equal sign ≈ can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The Almost Equal symbol ≈ is commonly used within Mathematics to indicate two values are roughly equal, but not exactly equal. Or use it whenever you need
How to move rows or columns up, down or across an Excel worksheet. There’s a quick way but it’s not obvious. Excel has a variety of different ways in doing this, but it’s important to know the fastest and easiest way, to save you a lot of time and hassle.
