All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Up arrow ↑ symbol in Word, Excel, PowerPoint and Outlook
How to insert the Upwards arrow ↑ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The upwards arrow ↑ symbol is used for various purposes. It can notate a mathematical symbol for ‘undefined’, for very large integers or in medical notation it can mean increased. Of course, there are plenty of uses in graphics and design elements especially […]
Banana 🍌 emoji in Word, Excel, PowerPoint and Outlook
Insert the Banana 🍌 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There’s also a Banana icon in modern Office apps. How Banana 🍌 looks in different fonts. Only two Segoe fonts support the Banana emoji; Segoe UI emoji (color or black) and Segoe UI Symbol. […]
Excel – how to make and use a checkbox
To make data entry simpler in Excel, form controls such as checkboxes can be added. A checkbox can be used to select or deselect an option. Checkboxes are useful for forms that have multiple options. The trick is using Excel’s Developer tab which holds the checkbox control. See How to get the Developer Tab in Office apps Insert a Checkbox in […]
Sigma upper Σ or lower σ case symbols in Word and Office
How to insert the Sigma upper case Σ and Sigma lower case σ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Sigma (uppercase Σ / lowercase σ) is the eighteenth letter of the Greek alphabet. In mathematics, the uppercase sigma symbol is used as an operator for summation, […]
Make a Word text box with rounded corners
A Microsoft Word text box can have rounded corners instead of the default square corners. It’s remarkably easy once you know the simple trick. Word Text Boxes always start with square corners, no matter which default you choose from the gallery. But once it’s inserted, a Word text box can be transformed many different shapes […]
Double Dagger ‡ symbol in Word, Excel, PowerPoint and Outlook
Insert the Double Dagger ‡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Dagger ‡ symbol is used to mark a third footnote after the asterisk and dagger in a Word document. How Double Dagger ‡ looks in different fonts. Here’s some examples of how Double Dagger […]
Choices for formatting fields in Word Mail Merge
How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents. Nancy M asks: “I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database. In the Excel database the amount cells […]
SUMIFS Excel SUM with filters galore
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little strange. SumIF has filter/criteria first […]
Biohazard symbol for Word, PowerPoint and more
There are official and unofficial biohazard symbols available for Word docs, PowerPoint slides or any other place you need them. We have download links to better graphics you can use with variations to make them stand out The official biohazard symbol was developed in 1966 and there are many variations available. The widely used symbol […]
Type Infinity ∞ symbols in Word, Excel, PowerPoint and Outlook
Type Infinity ∞ and similar symbols into Microsoft Word, Excel, PowerPoint or Outlook. In Office for Windows and Office for Mac you can enter Infinity, Incomplete Infinity, Tie over Infinity and Infinity negated. Infinity ∞ symbol is used for anything that has no end or boundless. Of course, it’s in mathematics where Infinity was first […]
Dagger † symbol in Word, Excel, PowerPoint and Outlook
Insert a Dagger † into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Dagger † symbol is used to indicate a footnote if an asterisk has been already used. Footnotes and Endnotes in Word Formatting Footnotes and Endnotes Dagger is a different look (depending on the font) but […]
Even more Airplane and related symbols in Microsoft Office
There are a lot more airplane symbols available in Microsoft Office including ones for landing, takeoff and even pilots. Also how to get plane graphics for specific models like a 747 Jumbo. If you know where to look, Office has plenty of ‘airplane’ related graphics beyond the simple Airplane ✈ symbol in Unicode. Office Icons […]
Removing email attachments from mailboxes like Outlook.com
How to remove or move email attachments using Outlook for Windows or Mac and the workarounds for Outlook.com in a browser. Doing this reduces the size of your online mailbox and, from 1 Feb 2023, your OneDrive storage. Removing email attachments is the fastest way to shrink a mailbox that’s getting near it’s maximum size […]
All we know about the Microsoft 365 app, so far
Microsoft is hyping their “Microsoft 365 app” but here’s what’s really happening, when the changes will happen and why it’s more hype and rebranding than useful improvements for Microsoft 365 customers. There’s really two parts to this “new” Microsoft 365, changes to the Office.com web site and later, a “Microsoft 365” app that’s based on […]
Year Planner calendar, Improvements and Extensions
Our Year Planner Excel workbook download is just the start. Here are many suggestions for changes to improve or customize the download. Tips for changing the headings, overall look, change financial year, highlight public holidays, change the look of a day in the week, change weekend shading or day label. We’ll even show how to […]
How to put a calendar on a Windows or Mac desktop
How to add a calendar as quick reference to your desktop on Windows or Mac. It can be a yearly, monthly or weekly calendar, just like the old paper calendar / blotting paper on an office desktop in olden times (i.e. 20 years ago)! A handy place to put a calendar is on your Windows […]
