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.
As we predicted last week, the “Microsoft 365 Oreo Expansion Pack” have appeared on Ebay and at a massive markup over the original price. The ‘special’ offer had a Microsoft 365 “Expansion Pack” of Oreo’s (apparently no waistline joke intended) plus a little plastic tong called a “Clippy Dippy”. Only
There’s a lot more printing and money saving options available if you know where to look or use a little cunning to get what you want. Microsoft Word documents with rescaling paper size, saving money in ink or toner, double-sided printing, two pages to a sheet, poster sizes and booklets.
Here’s three ways to add a PDF into your Word document. Like many things in Microsoft Word, there is more than one way to add a PDF file into a Word document. From a simple link to another file to converting the PDF into a Word document. In most cases
To my horror, I encountered something strange while working on a Word document with “strung out” or ‘stretched’ text on the last two lines with huge gaps of space between them. Here’s the two ways it can happen and the four fixes available. A stretched-out line in a Word document
When Microsoft Word was first released, all those years ago, it had a Paste feature but it was dumb and literal. These days Word’s Paste (Word for Windows and Word for Mac) is a lot smarter and does very useful things that you may not realize or appreciate. Before the
Type the three different types of Ellipsis … marks in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ellipsis … symbol is used for a gap or break in some text, usually to drop out some irrelevant text or speech. The same applies
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off
How can you change the Author name in an Office document? How can you know that the name in a Microsoft Word document is the actual person not an imposter? It’s easy enough to go to File | Info to see and change the document Author name. We did that
Last week Microsoft made a series of announcements of new and changed features in Microsoft Office and Microsoft 365. Here’s a brief roundup of what the main ten promises and what they mean for you (if anything). The important word is ‘announcement’. Almost all the statements are about future arrivals,
Combine or divide adjacent Microsoft Word or PowerPoint table cells into a merged single cell or split a cell in two. Welcome to ‘Merge Cells’ where you can combine adjacent cells into a single cell. It’s very handy for table formatting tricks and other unusual situations like a longer than
The simple and easiest way to convert text dates to Excel dates is using Text to Columns on the Data tab. It’s a simple ‘one off’ method that works well and takes you through the steps. If you need something more automated, for new text dates entered from time-to-time use
Footnote marks aren’t limited to numbers. Microsoft Word has many choices for listing footnotes or endnotes including the standard symbol order for notes or even your choice of custom symbols or emoji. Just one possibility for a footnote mark is a right-pointing hand like this: In-built Footnote/Endnote number choices Go
Today, 17 October, is Spreadsheet Day and Microsoft has joined the event with a fun example of what Excel is capable of. #spreadsheetday #spreadsheets #excel Microsoft Excel at Office-Watch.com The hidden trap in Excel’s DateDif()Better Excel formula converts days into Years, Months, DaysFour ways to make text fit in an
Office for Mac has keyboard shortcuts to speed up work but they are a lot hard to find than they should be. There’s no direct mapping of Office for Windows shortcuts into Office for Mac. Partly because the Mac has keys that aren’t on a regular Windows keyboard ( ⌘/Command
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another
There is a way to add an online calendar (aka webcal) to Outlook for Mac, even though it’s not directly possible. It’ll also add the subscribed calendar to iPhone and iPad. Subscribed calendars are really useful for adding in events like sports and club meetings. There are webcal:// links available
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
