All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Merge or Split cells in Word and PowerPoint tables
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 common text label. Or a […]
Simple text with day, month and year to Excel date conversion
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 one of the formulas at Converting […]
Choose your own Footnote or Endnote symbols in Microsoft Word
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 to the Footnote and Endnote […]
Happy Spreadsheet Day 2022 with Excel
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 Excel cellCheck Performance – inside […]
Why keyboard shortcuts are harder on Office for Mac
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 and Option) . Conversely Windows […]
Yen ¥ symbol in Word, Excel, PowerPoint and Outlook
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 symbol. ¥ symbol is easy […]
Yes, you can add an online calendar to Outlook for Mac
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 on many web sites. Unlike […]
Murphy Brown look in Word or PowerPoint
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 to make a similar look […]
Array Formula with IF filter in Excel
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 answer from the formula: =COUNTIF(Table3[Industry],G4) […]
Excel Array formulas for everyone
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 very least, you’ll know what […]
Make a List or Table of tables in a Word document
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 formal documentation. It can be […]
Pilcrow Sign ¶ emoji in Word, Excel, PowerPoint and Outlook
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 the END of a paragraph. […]
Better Excel formula converts days into Years, Months, Days
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 formula in Excel 365, 2021/LTSC […]
How a deleted Word document caught a serial killer
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 2004. He liked sending notes […]
Protect yourself buying Microsoft Office from Amazon or Ebay
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 buy from Amazon itself or […]
How to ‘ignore’ emails in Outlook
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’ on their pet subject. They […]
