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.
Recreate the Murphy Brown TV show’s look as a design inspiration for Word and PowerPoint – the fonts, colors and lines. You may not want to use the exact look of the Murphy Brown title card, but it’s a starting point for design variations of your own. We’ll show how
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more
Type the Pilcrow Sign ¶ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Pilcrow Sign ¶ is a typographical symbol sometimes called a paraph, or blind P In typography ¶ marks the start of a paragraph but in Microsoft Word the Pilcrow Sign ¶ marks
Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/plural (e.g. not “1 Year 0 Months 27 Days” but “1 Year 27 Days”). And we’ll show an even better way to write the
A Word document and a floppy disk caught a serial killer back in 2010. There are still lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in
After the report of pirated / illegal Microsoft Office from an Amazon retailer (and Amazon’s initial refusal to act) how can you protect yourself from a similar problem on Amazon or other sites? Your entitlement to a refund or redress for a illegal product is different depending on whether you
Occasionally you’ll get someone who sends lots of messages you don’t want to see. Outlook has a few options for refusing or politely ignoring messages from certain email senders – either individually or automatically. Most commonly these are enthusiastic zealots on some subject and are trying to ‘spread the word’
Meeting or party invitations don’t have to be plain, old white background emails, go for something a little more fancy or useful. Officially, Microsoft suggests using their Stationery themes to change the look of an email. But that’s not available for invitation emails. There are some formatting choices also missing
Many of the dangerous emails arriving in your Inbox have one thing in common — they use the old (and risky) Word .DOC format. .DOC .XLS or .PPT are exactly the sort of email attachments you should avoid. The main ‘red flag’ is the email attachment of a .DOC file
Here’s eight better but simple table formatting options not available from Microsoft Word’s Table Style gallery. Word’s Table Style gallery is a tempting selection of table formats but it doesn’t show you all the options to make your table look good. Some of these variations are right there on the
There are two ways to reveal or un-hide a hidden style, most commonly “Body Text” style. There’s the long-winded Microsoft approved method and the faster way. By default, Body Text style in Microsoft Word is ‘hidden until used’. That seems like a Catch-22, its not visible until it’s used but
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
