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.
How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents. Nancy M asks: “I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database. In the
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little
There are official and unofficial biohazard symbols available for Word docs, PowerPoint slides or any other place you need them. We have download links to better graphics you can use with variations to make them stand out The official biohazard symbol was developed in 1966 and there are many variations
Type Infinity ∞ and similar symbols into Microsoft Word, Excel, PowerPoint or Outlook. In Office for Windows and Office for Mac you can enter Infinity, Incomplete Infinity, Tie over Infinity and Infinity negated. Infinity ∞ symbol is used for anything that has no end or boundless. Of course, it’s in
Insert a Dagger † into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Dagger † symbol is used to indicate a footnote if an asterisk has been already used. Footnotes and Endnotes in Word Formatting Footnotes and Endnotes Dagger is a different look
There are a lot more airplane symbols available in Microsoft Office including ones for landing, takeoff and even pilots. Also how to get plane graphics for specific models like a 747 Jumbo. If you know where to look, Office has plenty of ‘airplane’ related graphics beyond the simple Airplane ✈
How to remove or move email attachments using Outlook for Windows or Mac and the workarounds for Outlook.com in a browser. Doing this reduces the size of your online mailbox and, from 1 Feb 2023, your OneDrive storage. Removing email attachments is the fastest way to shrink a mailbox that’s
Microsoft is hyping their “Microsoft 365 app” but here’s what’s really happening, when the changes will happen and why it’s more hype and rebranding than useful improvements for Microsoft 365 customers. There’s really two parts to this “new” Microsoft 365, changes to the Office.com web site and later, a “Microsoft
Our Year Planner Excel workbook download is just the start. Here are many suggestions for changes to improve or customize the download. Tips for changing the headings, overall look, change financial year, highlight public holidays, change the look of a day in the week, change weekend shading or day label.
How to add a calendar as quick reference to your desktop on Windows or Mac. It can be a yearly, monthly or weekly calendar, just like the old paper calendar / blotting paper on an office desktop in olden times (i.e. 20 years ago)! A handy place to put a
Here’s a great Excel yearly planner that we’re delighted to share. It works for 2024 or any other year you like and highlights Public Holidays in a simple and elegant way. Office Watch friend David Peel from the UK made this workbook and let us share with our readers. He’s
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a little mystery but we have an alternative for our readers. The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar. Find it from File | New then search for
Type the Lambda upper case Λ, and Lambda lower case λ symbols (aka Lamda) in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Lambda/Lamda (uppercase Λ / lowercase λ) is the 11th letter of the Greek alphabet. The uppercase symbol has various uses, it is
The Delta upper case Δ or Delta lower case δ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Delta (uppercase Δ / lowercase δ) is the fourth letter of the Greek alphabet. It’s the “d” sound in Modern and Ancient Greek. Delta
Looking for some Christmas images, pictures or graphics? Microsoft Office has some in-built Xmas options for the festive tide of Yule. Add these images into Word documents, Outlook emails, PowerPoint slides or even Excel worksheets. Unsubtle Hint: Christmas Cheer with Office has a collection of festive cards, letters, gift tags,
We take a look at a Christmas-themed font called Igloo, where to get it, and more, all compatible with Microsoft Office, Word etc for Windows or Mac One of my favorite fonts is the snow capped TrueType font usually called Igloo or Igloo Laser. A set of letters and numbers
There are many red and white Santa hats that you can quickly add to any photo using Word, Outlook, PowerPoint or any Microsoft Office app. I’ll explain where to get some Santa hats and how to add them to a picture. A Santa Hat can add a little festive fun
Type the Airplane ✈ symbol, icon, emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Airplane ✈ symbol is often used for signs, directions or an itinerary, possibly in combination with symbols for other transport like train, car, walking. For more ‘airplane’
The Lambda() feature in Excel 365 is great, when you try using it the downsides quickly become obvious. Happily there are workarounds. Lambda() itself is fine. It’s a welcome addition which more advanced users will make Excel do amazing things or simplify complex formulas. See Lambda – strange name for
RGBA color codes are an extension of the RGB (Red, Green, Blue) color system which you can use in modern Microsoft Office with a little trickery. There’s an annoying difference (reversal) in settings on Office for Windows vs other Microsoft services and Office for Mac. RGB colors have been around
The excellent Excel Formula Bot is now available as an Excel addin for subscribers to the Bot service and now can explain a formula in plain language. Excel Formula Bot is a wonderful service which converts human-speak into Excel formula-speak or vice-versa. Since we last reported, David Bressler has added
Hidden Text Printing in a Word document is possible but is more complex than it should be. Here’s how to change the setting quickly from the ribbon or change the print setting just for one print job. By default, the hidden text will not be printed, but you can choose
A new way to insert a picture directly from an Android device into a Word document or PowerPoint slide on a Windows or Mac computer. Plus alternatives you can use now and might be more reliable. How it’s (supposed) to work In the online (browser) versions of Word and PowerPoint,
What to do if you see a #BLOCKED cell error message in Microsoft Excel. The fix is simple, if you can get past Microsoft’s unhelpful, er, ‘help’. Open uṗ a workbook and see #BLOCKED in some cells. The message ‘Check privacy settings’ is typical Microsoft message. It’s strictly correct but
