All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Really fancy and clever Drop Caps in Word
Drop Caps are very old fashioned, there’s space left for them in the oldest printed books in the world, the Gutenberg Bibles. You can do the same thing, a lot more easily, in Microsoft Word. In this Office-Watch.com article we’ll go beyond the simple ‘how to’ for Drop Cap. There’s the basic settings supplied by […]
Fast typing the same thing across many Excel cells
Sometimes when you are filling out the cells in an Excel worksheet, the same thing must be written repeatedly. There’s a fast way to do it using a surprising Excel shortcut. Luckily, there’s an easier shortcut around it. Previously we have spoken about Auto Fill hidden tricks in Excel, but you might not be aware of this simple trick. Firstly, […]
Common Sound effects for PowerPoint
A PowerPoint presentation sometimes needs that extra oomph, such as an occasional sound effect. Here are a few common ones that you’ve heard from movies and TV shows. You can use them as a trigger sound, or novel background noise. It’s all about the sounds: Wilhelm Scream – stock sound effect used in several TV shows and movies, originally from the […]
Nine hidden tricks for Auto Fill in Excel
Typing or formatting cells of repetitive data can be very boring, but Excel has an Auto Fill feature to make it easier by automatically filling in data for you. We thought we knew Auto Fill, but just found nine surprising and useful tricks. Auto Fill goes beyond simple incrementing numbers or dates which is what […]
New Prime Number is too big for Excel
In 2013 they discovered a new Prime number but not for Excel. The GIMPS project has discovered a new prime number – that’s a number that can only be divided by itself and one. The new arrival is a bouncing bonny number 257,885,161-1 which is 17 million digits long. Prime numbers aren’t just mathematical curiosities, they […]
Solving “There’s already an account …” Microsoft login problem
Trying to login to Microsoft can get into a strange loop being told “there’s already an account” but then “That Microsoft account doesn’t exist.” for the same address! Amazingly both messages are right but not well worded. How can a Microsoft account login (email address) both exist and not exist at the same time? Has […]
The best way to ‘Out of Office’ or vacation message
Outlook can setup an Out of Office response, depending on the type of email connection but there’s a better way that works for everyone. ‘Out of Office’ or ‘Vacation’ autoresponses will automatically reply to incoming messages. Clever systems have options like different messages for people inside or outside an organization or only those in your […]
Reversed Tilde ∽ symbol in Word, Excel, PowerPoint and Outlook
Type the Reversed Tilde ∽ into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Reversed Tilde ∽ symbol is the vertically flipped version of the usual tilde ~ symbol. A tilde starts with the downward curve while the reversed tilde has a rising curve at left. How Reversed […]
White Chess Queen ♕ symbol in Word, PowerPoint and Office
How to insert the White Chess Queen ♕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess Queen ♕ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or just a generic ‘Crown’ graphic. How White Chess […]
A simple way to convert PowerPoint slides to Word document
There’s an easy way to make a Word document version of a PowerPoint presentation and it’s another way to make a handout for your audience. It’s a simple step by step process of converting your PowerPoint (.pptx) presentation file into a Word Document (.docx). Firstly, you will need to open your PowerPoint Presentation (amazing but true) Next, select File | Export Select Create Handouts | then the Create Handouts button This section will allow you to put […]
Beyond simple Undo in Microsoft Office
There’s a lot more to Undo than just reversing the last thing you did in Microsoft Office The UNDO command is surely one of the greatest time-saving inventions of the digital age. According to Jensen Harris, the head honcho of the Microsoft Office User Experience Team back in 2008 , undo is the fourth-most used […]
Microsoft 365 great deal now from Walmart
Walmart in the US has had a good deal on Microsoft 365 Family edition, saving $54 on the standard price. Used for renewing/extending an existing Family plan or joining for the first time. Update: Two Microsoft 365 deals to get, while they last The offer is for a 15-month extension/start to Microsoft 365 Family for […]
Best Laundry label text font for Microsoft Office
Which font to use if emulating a true laundry care or clothing text label in Word, PowerPoint or other Office program? We’ve already talked about how to put standard laundry care symbols in Word, Excel or PowerPoint but what about the text that usually goes with the icons? In our research we couldn’t find any […]
All about check in and check out in Microsoft Teams
Checking in and out of documents for Teams isn’t well understood. Using it can end in tears with lost changes or a seemingly stranded document that’s not available to others. What is Check in / Out? In a multi-user environment where lots of people might want to edit a file at the same time, check […]
Beware: don’t be pushed into the wrong Microsoft Office
Buying Microsoft Office in a physical store (remember them?) can be a trap for the unwary. People are being sold the wrong type of Office, instead they are pushed to the best option for the salesperson. We’ve had questions from readers after they’ve visited a local computer store. They’ve been misled talking to self-interested sales […]
Track Changes updates for Word on the web
Track Changes in Word on the web has changed so that accept or reject an edit appears right next to the text. The Track Changes feature allows users to gain feedback from others working on the same document. Microsoft has recently introduced a new feature, cards that pop-up to allow the user to preview any […]