All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Jeopardy! clue cards, make your own in PowerPoint and Word
How to make clue cards like the Jeopardy! TV show to use in PowerPoint or Word. Clue … it’s not as straightforward as you might think but we’ll take you through the steps and tricks. Use the well-known format to pose questions for your PowerPoint audience or as a section/chapter heading. Let’s go through the […]
Wavy Dash 〰 in Word, Excel, PowerPoint and Outlook
Insert the Wavy Dash 〰 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Wavy Dash 〰 symbol is like a long curvy version of the em-dash, there’s no specific meaning or purpose. Not to be confused with the two Tilde ~ symbols and reversed ∽ Tilde […]
How to convert Normal style to Body Text style in Word
Switching paragraphs from Normal style to Body Text styles in Microsoft Word is a clever use of the Replace feature that can switch text with any style to another. We’ve talked about how savvy Word users have their main text paragraphs in the Body Text style instead of the standard Normal style. See also Modifying Body Text […]
Microsoft Office is getting pronoun choices
In a move sure to anger some folks, Microsoft is adding pronoun choices to contacts details on profile cards. People will be able to let others know how they like to be addressed: she/her, her/him, they/them or other choices. Before some blood pressure levels rise to dangerous levels, Office Watch will explain what’s happening. What […]
Automatic worksheet/tabs list in Excel
Make an automatic list of tabs in an Excel workbook a better and more flexible way with options to create clickable links and sort the sheet list. Unlike older methods, it works in Excel for Windows and Mac. We’ve already talked about fitting more tabs on the screen or making a manual list of tabs/worksheets. […]
Explore five (yes FIVE) different Exclamation Mark ! in Word and Office
There’s more possible with the humble ! exclamation mark / point in Microsoft Word or Office. At least five different ! available and that’s before changing color, size and other text effect options. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, icons, symbols and several emoji with infinite variations possible […]
Stop contract trickery with a Word document
There are risks when sending a Microsoft Word document to someone when you don’t need to, one landlord found that out the hard way. A Word doc can be changed if you’re not careful. We have some suggestions for avoiding unexpected editing traps. A tenant in the USA received a draft lease via email in the […]
Closed captions for PowerPoint audio – adding and saving
PowerPoint 365 (Windows, Mac and iOS) can now use separate caption files for audio inside a presentation and also export the captions with media. What’s new are captions for audio files like a transcript of a lecture or even song lyrics for a PowerPoint ‘sing-a-long’. There’s a catch but one that can be bypassed. Modern […]
Warning! AI ‘help’ coming to Microsoft Office
Microsoft’s hints that AI ‘help’ is coming soon to Word, Outlook and other Office apps are for investors not paying customers. Don’t get too excited (or worried) about the immediate future of AI tools into either Search or Office apps. There are problems with current AI offerings and traps for people if they aren’t careful. […]
Purple, Prince, Pantone and Microsoft Office
There’s a special purple color named by Pantone as ‘Love Symbol Number 2’ in honor of the musician Prince. That same purple is possible in Microsoft Word and other Office applications. Only last year, Pantone teamed with Prince’s estate to announce that PQ 7448C was to be known as Love Symbol Number 2. Now the […]
Add Prince’s Symbol ‘Love Symbol Number 2’ in Word and Office
The late and much missed musician Prince wished to be known by single character symbol called ‘Love Symbol Number 2‘. Here’s how to enter that unique symbol in Word, PowerPoint or Microsoft Office generally. There are various methods suggested on the Internet, we’ve narrowed them down to one excellent option (SVG graphic) two others that […]
Add the King Charles III monogram to Microsoft Office docs
There’s a new King in Britain (and other countries) which means there’s a new Royal Logo Cypher or Monogram. Here’s how to get the Cypher for Microsoft Office documents or slides. The Royal insignia is usually made from two parts, the Tudor Crown or Scottish Crown above the Royal Cypher. There’s a Royal Cypher below […]
Beware a Microsoft Office 365 – OneDrive outage, what you must to do protect yourself
No cloud service is perfect, no matter what the company says. Here’s what you must do to protect yourself from breakdown of your OneDrive, SharePoint, Teams or Microsoft 365 cloud storage. Microsoft pushes use of OneDrive to store all your documents and images. That suits Microsoft’s strategy but isn’t necessarily a good thing for customers. […]
Exploding Head 🤯 emoji in Word, Excel, PowerPoint and Outlook
Insert the Exploding Head 🤯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Exploding Head 🤯 emoji looks Windows only has Exploding Head 🤯 in the Segoe UI Emoji font, either color or black. To me the black version looks more like a bowl than […]
Three ways to understand part of an Excel formula
Excel has three different ways to see a partial formula result to help you locate and fix a problem or understand how a formula works. Two methods have been in Excel for some time and there’s a new tooltip feature. Evaluate Formula The full Evaluate Formula has been around since at least Excel 2007. It […]
Understand or fix an Excel sheet with Evaluate Formula
Excel has a simple way to understand or fix a complex formula. Evaluate Formula lets you calculate parts of a formula and see interim results that make up the final value that appears in the cell. It’s on the Formulas tab under Formula Auditing. Evaluate Formula isn’t new, just little mentioned despite its usefulness. We […]