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.
LucidChart is a very nice diagramming and flowchart tool which is integrated with Microsoft Office for Windows or Mac. Office has diagram tools via Insert | Shapes but they aren’t very elegant. They serve for simple uses but not a lot more. LucidChart is better than the inbuilt Office diagram
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of
Changing the case upper/lower for text through all of a Word document is easy because the default Find / Replace settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has
How to view Text Boundaries in Microsoft Word, why they can be useful and how the feature has changed over time. Text Boundaries put a dotted line box around each text element on a Word page. Turn on Text Boundaries to solve formatting problems. For example, in the above example,
How to show the four corner Crop or Trim marks on a Microsoft Word page. The ‘L’ shapes are a guide to the useable part of the page, inside the margins, and appear in all four corners. The four marks are called Crop Marks also known as Trim Marks. Word
Microsoft Word has a ‘profanity’ check to warn you about rude, offensive or swear words in some places. In others, the same word won’t get any special marking. We’ll explain how to setup and use Microsoft Word’s Profanity check then show its limitations and traps. The Profanity, offensive or swear
Inserting a link to a PDF (or any other file) into a Word document or email is easy to do. All you need is the web or other link to the PDF and paste that link into your document or email. The key question to ask is ‘Where is the
If you have included equations in a document, Word can generate a list of them all for you. Like a table of contents, this list or Table of Equations can include page references or links to each equation. A Table of Equations can be useful for creating a proper appendix
If you’ve ever needed to split dates in Excel into separate day, month, and year, there are several options to choose from. Excel has different functions, Text to Columns or Flash Fill which can do the job. Here’s a quick guide on several methods: Using the DAY, MONTH and YEAR
With a little Office formatting trickery, you can make a Twitter ‘message’ that looks like what you see on the Twitter web site or app to put in a Word document or PowerPoint slide. Use this trick to recreate a real Tweet that’s part of a document. Or as a
There are disagreements about how to pronounce the acronym ‘GIF’ for the popular image format, even though there’s an authoritative answer. Even Microsoft Word is confused about how to say GIF with the Read Aloud feature. Stephen E. Wilhite, the developer of the Graphics Interchange Format or GIF passed away
Add a background image to any page in a Word document instead of a solid color or pattern. Using a picture as the background for Word page isn’t as straight forward because the official or approved method doesn’t work very well. We’ll show you other Word features that work better
Insert the Eye of Horus 𓂀 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eye of Horus 𓂀 is an Egyptian Hieroglyph symbolizing protection. According to Egyptian myth, Horus lost his left eye during his struggle with Seth, and it was restored
The Researcher button on Word’s References tab lets you lookup information online and copy into a document with formatted but optional citation. It’s likely to dismay many teachers and lecturers. Researcher is a cloud service, only available in Word 365 for Windows and Mac. The Researcher pane is really a
A slip of the typing fingers can be funny, insulting or embarrassing, turning an innocent word into a naughty one. There are features in Word to help avoid these mistakes which have improved over the years but they aren’t 100% reliable It only takes a single letter to turn an
Google has just doubled the cells available in their Sheets spreadsheet, taking it to 10 million cells. Still well short of Excel’s 17 million cells. Sheets can now stretch to 18,278 columns (column ZZZ) for all Google Workspace customers, as well as legacy G Suite Basic and Business customers. Excel has
A long-standing bug in Microsoft Word quietly breaks your document navigation when you place Heading styles inside a table. The Table of Contents shows all your headings correctly, but the Navigation Pane silently drops any heading that lives inside a table cell. The same broken behavior ripples into PDF Bookmarks
As long time space and SF nerds, Office Watch can’t resist putting the look of 2001: A Space Odyssey into Word documents and PowerPoint slides. We’ll show you how to make a ‘close match’ using just the fonts and features in Microsoft Office. We’ll also explain the details behind that
Excel has ways to add a list of dates by day, weekday, month or year either by the fill handle or the Series command. Date Series with Fill Handle You probably know about the Fill handle tool to fill the remaining cells. Once highlighted, just hover your mouse in the
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Here’s what it looks like with the pink, black and red
Microsoft Word can generate a list of all the images, graphs, tables or equations in a document – called a Table of Figures. Just like a table of contents, this list can include page references or links to each figure or picture. A Table of Figures can be useful for
Microsoft 365 does an online licence check at least every 30 days. If your device will be offline for weeks, how can you make sure you have a full 30 days licence before disconnecting from the Internet? Here’s how to update your Microsoft 365 licence before going offline. Office 365
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the
Here’s how to make a lookalike for the Law & Order TV show title card in either PowerPoint or Word. Last week we showed how to make the Law & Order opening screen image and how to use that look in slides or documents. Many readers asked why Office-Watch.com didn’t
