All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
I Love signs in Word or PowerPoint
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love NY’ logo was made to […]
Protect against the latest ransomware attack via Excel
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends to be a forwarded message […]
Amazon’s fake problems are bigger than just Microsoft Office
A wonderfully independent article in the Washington Post reveals a big problem with the sale of fake and pirated products on Amazon. Our articles on fake Microsoft Office products is just a tiny part of a bigger problem. The Washington Post is owned by Jeff Bezos, the head of Amazon so it’s great to see […]
Hiding Text in PowerPoint
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously at hiding things in Word and Excel, and PowerPoint also allows you to hide things, although the approach is a little different. The most common reason to want to hide text on a PowerPoint slide […]
Hide a PowerPoint Slide
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You can select multiple slides using […]
OneNote 2016 for Windows gets dark mode
The first sign that OneNote 2016 is back from a slow death is the announcement of the first new feature in well over a year. OneNote 2016 is getting a Dark Mode just like the Mac and Apple apps. OneNote dark mode will be an option in OneNote 2016 for Windows but only for Office […]
Hidden text positioning and formatting tricks in Word
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for their answers. Leaving space where […]
Welsh schoolkids and teachers get Office 365 free – what about your kids?
In Wales, all teachers and their students can get Office 365 free, instead of about ₤60, thanks to an initiative of the Welsh government. It’s worth checking what access to the full Office suite your school, college or university kids might have. The Welsh government has arranged this as part of the HWB scheme that […]
Office for Mac long-standing security bug revealed
A security vulnerability has been discovered in Excel for Mac. It’s been there for many years and affects Office 365, Office 2019, Office 2016 and Office 2011 for Mac. We have details and suggest a protection you can do yourself. It’s another problem with legacy support for an older Microsoft Office feature. In this case […]
Outlook for Mac Profiles, finding and using them
Outlook for Mac also has Profiles to manage multiple setups on the one machine. Though they are managed very differently to Outlook for Windows, the basics are the same on both. To add a bit of confusion, profiles where called ‘identities’ up to Outlook 2011. Outlook 2016 and later for Mac use the ‘Profile’ name. […]
Hiding Columns and Rows in Excel
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control + 0 to hide a […]
Using 3D Formulas to range across Excel worksheets
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of years, a different worksheet for […]
Credit card required for Office 365 – why?
Why does Microsoft demand a credit/debit card for Office 365 plans when you’ve bought your annual plans elsewhere, and probably cheaper? As Office Watch readers know, you don’t have to buy Office 365 Home or Personal direct from Microsoft. Microsoft is the worst place to buy or renew Microsoft Office because it’s always the highest […]
How a savvy Office Watch reader really saved with Office 365
A few days ago we told you about a very good deal at Argos in the UK, half-price Office 365 Home. One couple has taken advantage of our tip, and other suggestions from Office-Watch, to get two years of Office 365 for the price of one. One of our readers saw our Office 365 Home […]
Don’t panic, Office 2010 support ends a year from now
Microsoft has started its usual sales campaign to go with the end of support for Office 2010 in a year from now. There are alternatives beyond what Microsoft is selling. In a self-serving blog headed “Support for Office 2010 is ending—get current with Office 365 ProPlus” we see the tiresomely familiar marketing strategy playing out. Encouraging customers […]
Using oAuth, or not, in Outlook programs or apps
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know about Open Authentication but there’s […]