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.
Tucked away in Microsoft Office is a little used tag ‘Content Status’ or just ‘Status’ that could help manage and find Word, Excel and PowerPoint documents in organizations. Unfortunately, Content Status is only used once in Office features. It’s supported in Windows Explorer if you know where to look. On
A new-ish keyboard shortcut in Excel 365 (Windows/Mac) is very handy for pasting values into a cell or matching the destination formatting. A common Excel task is pasting content into a cell from non-Excel sources (a web page, document, email etc). Until now (and in Excel 2021/2019 etc) is quite
Microsoft is adding zoom shortcuts to Word for Windows and Mac to make Word more ‘browser like’ but to do that they’re changing long-standing keyboard shortcuts. These are keyboard shortcuts you might be using in a web browser and they already work for documents for Word in a browser. Zoom
Some basketball fans at Microsoft have released an Excel workbook to play mens and womens ‘fantasy’ college basketball with friends and family. Excel randomly allocates the 64 teams to your players who can see how the tournament progresses through the shared workbook. Even if you’re not interested in ‘college hoops’,
Excel has five different Pie Charts, here they all are, showing how to use each chart and tricks to make the charts look better. Microsoft has five Excel Pie Charts though one of them is really a donut/doughnut. Find them all at Insert | Charts; 2-D and 3-D Pie charts
Here’s an even better way to make an automatic list of tabs in an Excel workbook it works in Excel for Windows and Mac and bypasses some possible traps. Start with our article on Automatic worksheet/tabs list in Excel which explains how to add a list of Excel tabs/sheets with
Function Fn keys on your keyboard, though neglected, have a special role to play in Microsoft Office. Sometimes they combine with Ctrl, Alt or Shift keys to provide certain functions. Here’s how to use Fn keys when they’re on smaller laptop keyboards or totally missing! Plus how Microsoft Office’s help
Here’s a complete list of the Word Function Key features from fast access to Help, jumping around the document, doc panes, spelling, grammar and managing field codes. Let’s discuss in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, field jump F2 –
Insert the Epsilon upper case Ε, and Epsilon lower case ε symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Epsilon (uppercase Ε / lowercase ε) is the fifth letter of the Greek alphabet. The uppercase isn’t commonly used outside of the Greek language,
The inverted or Spanish question mark ¿ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¿ is most commonly used in Spanish for the start of a question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need
Outlook for Mac is now available to all, no payment or subscription required. It combines email, calendar and contacts in the one app. Anyone with a recent Mac computer can install Outlook for Mac for email, calendar and contacts from the App Store. All the common and most less-common email
Losing recent work on a document is really frustrating so here are a few tips to make Office document saving more reliable, with less risk of loss if the computer or Office programs crash. A few changes to Microsoft’s defaults can mean lower blood pressure for you. Save AutoRecover every
Insert lower case letter with circles ⓐ to ⓩ in Microsoft Office, Word, Excel, Outlook etc. Officially they are called Circled Latin Small Letters. Circled small letters in different fonts Only two common Office fonts have double circled digits Segoe UI Symbol and Calibri. Here’s how the symbols look in both
The rainbow shape with multi-color effect is possible in text, shapes and images for any Microsoft Office documents including Word and PowerPoint. With a few changes you can make a rainbow for documents or slides. Rainbow Text Effect Insert | WordArt choosing whichever preset is closest to what you want.
Here’s how to mask a photo with any Microsoft Office shape or icon and do it with full control over what appears from the original image. We’ve already explained two simple ways to crop a photo to a shape or fill a shape with some options to move and resize
The picture option ‘Set Transparency Color’ doesn’t always work properly in Microsoft Office. We’ll explain the problem and suggest some fixes. When we were making our article “Make a transparent shape to mask a photo in Word, PowerPoint and more” we discovered that the ‘Set Transparent Color’ option didn’t work
It is possible to display your Mac screen to another person or even let someone take control of your Mac to fix a problem or help learn a computer skill. We’ll explain how to find and start the Screen Sharing app in macOS and an alternative. Windows has a similar
The ‘speech to text’ Dictation feature is now in OneNote for Mac. Look on the far-right of the Home tab for the Dictate button. Click on it to make the little Dictation toolbar appear. Our book Dictation and Read Aloud in Office explains Dictation and other Office speech features from
There are two ways to switch between Letter (Imperial) and A4 (Metric) paper sizes for Microsoft Word documents on Windows or Mac. One is easy and temporary, the other changes the document itself. Also how to switch Word’s default paper size and how to save PDF’s to another page size.
There’s a simple way to tell if your mailbox has the useful plus + address feature. Plus email addressing (aka disposable or sub-address) is sometimes available automatically (Gmail or Outlook.com) or has to be switched on (Microsoft 365 hosting). Some other mail hosts might have an option to allow plus
Have all your favorite Office features and buttons in one place. Commonly used buttons or options that aren’t on the regular ribbon. The Office ribbon lets you make a personal tab filled with your choices. We will show you how easy it is to make in Word below, but this
A Word Drop-down list lets you quickly choose one of several options. It’s a fast way to make new documents with a standardized pattern. Don’t be scared, it’s easy to create even though the word ‘Developer’ is involved. We’ll show you how to make drop-down lists, change the bland ‘Choose
How to make a bullet list that has different bullet symbol or emoji for each Word or PowerPoint line. With the wide range of symbols and emoji in Word and PowerPoint there’s scope for creative lists that use symbols that relate to each line. It’s not possible to do that
Insert digits with double circles from ⓵ to ⓽ in Microsoft Office, Word, Excel, Outlook etc. Use them as an alternative way to number a list like this … Double Circled digits in different fonts Only two common Office fonts have double circled digits Segoe UI Symbol and Calibri. Here’s how
