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.
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
ChatGPT or Copilot can be used to learn the basics of Microsoft Office VBA coding with examples made to order. Hereâs some VBA made by ChatGPT for Word, Excel, PowerPoint and Outlook and some of its mistakes. ChatGPT or Copilot will take a simple request and returns some text. Â People
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
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
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
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 â
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
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
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.
