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.
The default ‘Body Text’ style in Word needs some changes to suit your needs. Here’s some suggestions for things to alter or check to make sure they suit your, er, style. Can’t see a Body Text style? See Make Body Text style appear in Microsoft Word Body Text style can be
Here’s your four choices for making text fit within an Excel cell. About wrapping text, adding line breaks and merging cells in Excel. There are plenty of options to fit text in Excel but not all of them are obvious. At first, when you type text in a cell it
Did you know that the U.S has two feet? Meaning two different measurements for the term ‘foot’? That got us wondering how Excel’s Convert() handled the standard ‘foot’ and the US Survey ‘foot’. Excel Convert() supports the International Standard Foot and, indirectly, the US Survey Foot. America Has Two Feet.
Microsoft Word has a booklet printing option but there’s a simple alternative if it’s not working or you’d like options not available in Word. Here’s how to booklet print in Word and also a simpler alternative. Word’s Booklet Printing is done in the document (Layout | Paragraph | Page Setup
Here’s how to apply the same formatting, borders and picture styles to more than one picture or graphic in Word, PowerPoint or Excel. There’s an unexpected and easy way to do it. Picture Format tools don’t have custom styles (Microsoft please note) only the in-built pre-sets. If you want to
Put the Reference Mark ※ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Reference Mark ※ or reference symbol is used in Asian writing (Chinese, Japanese, Korean) like the Asterix * in western languages. It marks some additional notes to text. It’s called
When including images or other objects in a Microsoft Word document, it can sometimes be a bit fiddly getting the text to flow around them in the way you want. The text wrapping break lets you specify the point where the text should drop down below the picture. When you
Quickly type the Euro € currency sign into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Euro € symbol is easy on some keyboards but for other keyboards there’s no specific key for Euro. You can [copy content=”€” text=”click here to copy Euro
Tasks in Outlook have been given a major update with the development of Microsoft To Do. To Do is way better than the old Tasks with more options, its own app and web page options. It’s available for everyone but works best with a Microsoft hosted mailbox (Outlook.com, Microsoft 365
The in-built page border option in Microsoft Word has a lot more available than first appears. A little digging will discover a lot more possibilities for interesting edges to pages. We’ve already explained how to make a more flexible page border in Word that you can change to exactly fit
What is the Questioned Equal To ≟ symbol and how to type in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. ≟ is a question mark above an equals sign. It isn’t properly used in equations but can be useful to show an
Function keys can be a hassle, specially on smaller laptop keyboards without a dedicated F key row. Happily there are two alternatives for Microsoft Office user plus another for both Windows or Mac generally. Many laptop users avoid the Function keys because they aren’t directly available on the keyboard. Instead
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,
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
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
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
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
‘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
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
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
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
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
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
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
