All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Hiding Cell Contents or Formulas in Excel
There are two ways to hide Excel cell contents that you don’t want visible, but still available able to use in calculations. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are separate options for hiding row, columns or entire worksheets (aka […]
Two ways to Find & Remove Hidden Text in Word
If you want to find then change or remove hidden text from your Word document, there are two ways to do it. Either reveal or find the hidden text OR use Word’s in-built Document Inspector. For a shorter document, you can use the Show/Hide button to see what’s hidden and delete it manually, but that […]
Bring back the 90’s with online WordArt
Make an image using the original Microsoft Office WordArt designs, courtesy of some clever web work by Mike McMillan. Or use the better WordArt that’s still available in modern Microsoft Word. Does anyone miss the original WordArt from the 1990’s? Now you can get it back https://makewordart.com/ recreates, with scary detail, the look of early […]
The best way to make a Word page with black border
Microsoft Word has some simple but frankly inadequate options to make a sign or page with a thick black border. Office Watch shows you the best, most flexible option which is better than the official, direct features. Following the death of Her Majesty Queen Elizabeth II, I was asked to make an appropriate sign for […]
Drop PowerPoint slides into Word documents
There are two ways to drop a PowerPoint slide into a Word document. A simple, one-time method or a slightly advanced but dynamic trick which lets the Word document slide change if the original slide is updated. A few months ago we showed how to add Excel worksheets into a Word document. This time we’ll […]
What are email Plus addresses and how to use them
‘Plus’ email addressing (aka sub-address or disposable email) is a really useful option for managing your incoming messages, if your mail host allow them. The + trick lets you change the email address given out while still letting the messages to a single mailbox. A ‘plus’ email address looks like this fred+sheep@fredagg.com – the real […]
Two ways to find accented letters in Word
How to find words with or without accented characters in Microsoft Word. You might need to find both naïve and naïve or café and cafe. There are many options in Word Find or Advanced Find but not the choice to ‘ignore accented characters’ or ‘treat accented characters as if not accented’. (‘Find all word forms’ […]
Division ÷ symbol in Word, Excel, PowerPoint and Outlook
Type the Division ÷ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Division ÷ symbol is an alternative to the / character. Made up of a dash and two dots. ÷ symbol isn’t recommended these days. It’s not universally known and mostly used to mark division […]
All about Diaeresis or Umlaut in Microsoft Word
How to typing words with a diaeresis or umlaut in Word for Windows, Mac, Apple or Android plus the shortcuts on Mac computers. They aren’t normally needed in English except some organizations that require diaeresis for words like: naïve coöperate reëlect Brontë Noël Noël Coward Or you might be typing in another language where the […]
Saving OneNote notebooks be saved locally and not in the cloud
Many OneNote users would like to save their notebooks on their computer and not OneDrive. Saving a notebook to a local folder is possible. It might become impossible in the years ahead. Only OneNote 2016 for Windows supports saving a notebook to any folder. OneDrive is the only notebook option in other OneNote apps (including […]
Six tips for better spreadsheets
Some good advice for better spreadsheets from the distinguished science journal, Nature, (established 1869!) who have tips about the right way and wrong way to use Excel or Google Sheets. The article Six tips for better spreadsheets opens with a horror story about a list of latitude/longitude “It was a complete mix, The spreadsheet was […]
Hiding stuff in Word, Excel and PowerPoint
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
Showing 12 o’clock as ‘noon’ or ‘midnight’ in Excel
Excel shows midday or noon as 12:00 PM which doesn’t suit everyone, here’s how to change the defaults to a word such as ‘Midnight’ or any other time label you’d like. ABC News in Australia delves into the argument about showing 12 PM – There is no such time as 12pm. The argument is that […]
Apple command ⌘ symbol in Word, Excel, PowerPoint and Outlook
The Apple command ⌘ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Apple command ⌘ symbol appears on Mac and iPad keyboards but only as a command option, not as a symbol to type. The ⌘ symbol predates Apple computers. It’s a ‘PLACE […]
Excel Formula Bot upgrades and goes pro
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite still in beta testing. Please […]
Great Periodic Table documents for Microsoft Office
There are some great and editable Periodic Table of Elements options available in Microsoft Office – Word documents, Excel spreadsheets and PowerPoint slides There are many Periodic Table ‘documents’ on the net but most are PDF’s or images that can’t be changed. We’re looking for editable Word documents and Excel worksheets that you can adapt, […]
