All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Converting Google Docs to Microsoft Word
Google Docs can be handy for sharing and working on documents with other people, but sometimes you just really need that file in Microsoft Word. No problem – it’s actually really easy to convert them. All you have to do is download the file and save it as a Word doc, Excel sheet or PowerPoint deck. If the Google Docs File is Open […]
London Street Signs, make your own in Word and PowerPoint
Famous London streets signs are selling for big bucks … or you can make your own in Word or PowerPoint for nothing. A sale of genuine London street signs by Westminster City Council included one for Abbey Road that sold for £37,200 (US$51,000). We thought that was a lot and figured out how to make […]
8 simple ‘Prohibited’ symbols for smoking, phones, kids and more in Word
Some ‘not allowed’ or ‘prohibited’ symbols, they can be used in Word, PowerPoint, Excel or Outlook. No Smoking, No Phone, No Children, No Drinking, No Pedestrians, No Bicycles, Not Drinkable Water or Mute. The Unicode symbol list includes red circle with diagonal to stop, smoking, children under 18, Mobile Phones, Littering, Pedestrians, bicycles plus no […]
Ohm symbol Ω in Word, Excel, PowerPoint and Outlook
Type the Ohm symbol Ω into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Also the unofficial Siemens symbol, an inverted Ohm ℧ . Ohm is a measure of electical resistance with the symbol Ω It’s an official SI Unit of measurement just like gram, metre and many […]
Omega upper Ω or lower ω symbols in Word and Office
Type the Greek letter Omega in upper case Ω or lower case ω in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Omega (uppercase Ω / lowercase ω) is the twenty fourth and final letter of the Greek alphabet. It is used to often denote the last or ultimate […]
Flowing column text in Word with break-out or sidebar
Sometimes there’s more than one way to do something in Microsoft Word like having four blocks of text on a page with images or text breakout with flowing columns of text with a side-bar or break-out. “How can I do a magazine-like layout with four blocks of text, one in each corner with a box […]
Named Ranges and Objects in the Excel Name Box
I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to Formulas | Define Name | […]
Six clever tricks (at least) in Excel’s Name Box
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for selecting and moving around a […]
Limitations of Word Sort feature for name sorting
Microsoft Word’s Sort feature is OK but has its limitations. We humans insist on variations of the simple ‘first and last’ name that confuse a computer. Here’s some name sorting traps and workarounds. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list for any anomalies. Longer lists […]
Sort a list of names by surname or more in Word
Microsoft Word sorting is more powerful than it appears, with a few extra clicks you can sort last names or anything else in a list. Sort is one of those Word features that’s been around for a long time. These days it’s tucked away on Home tab in the Paragraph group. Select a list or […]
All mailbox limits (& how to find yours) in Outlook.com and Microsoft hosting
An Outlook.com or Microsoft hosted mail storage quota can be anything from 2GB to 100GB. Here’s a full list of the mailbox limits, how to check your current usage and total allowed size. We’re talking here about Microsoft mailbox hosting services including Outlook.com. NOT the various and confusing types of Outlook software. Outlook.com free account […]
Full CONVERT() measurement list for Excel
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes. Below that are a list […]
Converting SVG into JPG, PNG or other raster image format
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. Here’s some options for conversion or sourcing alternatives. SVG’s are great with many advantages for Office 365 and Office 2021/2019 users. Not everyone has the latest Microsoft Office or shares documents with others who have earlier […]
Make your own ‘handwritten’ letters with Word
Microsoft Word has almost all you need to make ‘hand written’ notes and letters for a fraction of the cost of a special service. Dig into some of the lesser known Word font and line spacing settings to get that ‘written by hand’ effect. The New York Times has a report on Bond – a […]
Type Phi uppercase Φ or lower φ in Word and Office
Insert the Phi uppercase Φ, and Phi lowercase φ / φ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Phi (uppercase Φ / lowercase φ / φ) is the 21st letter of the Greek alphabet. The uppercase symbol has various uses, such as the cumulative distribution function of standard normal deviation in statistics. The lowercase symbol has […]
Word documents might write themselves and more
Microsoft is working on extending OpenAI features like ChatGPT to help people write Word documents based on a short suggestion. And there’s a lot more possible given Microsoft’s investment in OpenAI, even a koala poem ‘written’ by Dorothy Parker. Office Watch has been looking at ChatGPT’s ability to write Office VBA programming code (with mixed […]
