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.
At last! After months of delay, Microsoft has released product icons for Access, Project and Visio. Yawn, ho hum. We know Microsoft customers have been desperate to see these graphics (not). Back in March we first saw the Word, Outlook, Excel and PowerPoint graphics. As before, when it comes to
The desperately needed feature is coming to Microsoft Office … the ability to search for Icons. Microsoft added Icons to Office 365 and even more a few months ago … 300 more icons in Office, but which ones and where? The problem has always been finding the right icons from
Office now has sensitivity options to label Word, Excel, PowerPoint docs plus emails. Not ‘touch-feely’ sensitivity like ‘loving’ or ‘compassionate’ but instead corporate, privacy labels. It’s a new feature for Office 365 corporate hosted E3 or E5 accounts and the admins have enabled Sensitivity options. Sensitivity appears on the Home
Despite all the possibilities for importing or sharing appointments, most of the time we have to manually type in new appointments or events. Here’s some tips to do it faster and get it right. We’ve all been there, a web page or email (below right) with details that need copying
The Format Cells dialog can be accessed from Home | Alignment | Orientation, or by right-clicking on selected cells and selecting Format Cells. See Excel’s text and number alignment choices Text formatting in Excel with wrapping, line breaks and merging This dialog gives you more detailed options to choose from than
Under Excel’s Home | Alignment ribbon you can change the indents, alignment or angle of the text in selected cells. As usual, a seemingly simple set of buttons have some hidden tricks. See Text formatting in Excel with wrapping, line breaks and merging Alignment Adjust alignment of the text, both
As Office Watch noted back in July, Office 2019 (Professional Plus or Home & Business) are no longer available in the Home Use Program. Until last month, Office 2019 Professional Plus or Office 2019 Home and Business could be had for the trivial price of $14.99 instead of well over
It’s amazing to see how people use Excel in ways probably not dreamt of by the programs makers. We usually think of Excel as a financial tool either for businesses or personal budgeting or managing lists. Anything to do with numbers or lists has a place in Excel, like a
Microsoft is improving (fixing?) the activation system for Office 365 Home and Personal customers. This comes a few weeks after they announced the same changes for Office 365 Enterprise customers. The per device activation limit will be handled in a much better way. Each Office 365 user is limited to login/activations on
It’s quite easy to tell if your Excel 365 has the new Dynamic Arrays. No need to setup a table and use the new feature – just three keypresses are enough. Some people are reporting that they have the right Excel 365 but with no dynamic arrays. Checking the program/app
After many months of testing, all Excel 365 apps now have dynamic arrays (except Excel Online) though some are just for Insiders at present. Dynamic Arrays are a major and powerful expansion of Excel’s powers. The new abilities, functions and error messages might seem scary but are a great leap
A newly promoted UK politician has his own special style guide for staff, here’s some Word features that can help ensure your documents are approved by the boss. The Right Honourable Jacob William Rees-Mogg (to give his new full title) proudly affects an old-fashioned demeanor and has been described as
In August there’ll be some good changes to Office 365 activation for commercial customers. The per device activation limit will be handled in a much better way. Each Office 365 user is limited to login/activations on five each of desktop programs, tablet apps and smartphone apps. That’s a total of
Microsoft’s Home Use Program is a great way to get Office cheaply including Office 2019, Visio Professional 2019 and Project Professional 2019. The Home Use Program (HUP) has been a way to get Microsoft Office for less than retail for a long time. It’s available to many companies, organizations and
Microsoft Word has several ways to quickly insert placeholder text into documents. Sometimes you want to add some random text to a document as filler, but don’t want to think of something to write yourself. While there are websites that will generate placeholder text for you, it is also possible
Our articles about saving past events with anniversary reminders begs the question; How far back can Outlook save an event. The answer in Outlook for Windows, Mac and online is 1 April 1601. Trying to enter a date before 1st April 1601 brings up an error: “You must specify a
Here’s a practical example of how to share an appointment or event with reminders using the iCalendar .ics standard. Some Apollo 11 events ready to download and add to your calendar (in Outlook or other software). Outlook supports .ics files and so does most other calendar programs. They are small
Here’s the enhanced Apollo 11 mission timeline as an Excel worksheet. Office Watch newsletter readers asked for it after last weeks articles using the NASA web page as a data source. Complete Apollo 11 timeline in Excel Things to do with the Apollo 11 timeline in Excel Apollo 11 suggested
An Excel worksheet with Apollo 11 timeline can be used to analyze and breakdown the astronaut’s movements plus answer the big question: what time was it when Armstrong walked on the moon? See how we put the Apollo 11 timeline into Excel using Get & Transform or the older Copy/Paste
NASA has a detailed web page with the timeline of the Apollo 11 mission from before liftoff to well after splashdown It’s an example of the two ways to put a web table into an Excel worksheet. Newer Excel (365, 2019 and 2016) has PowerQuery with ‘Get and Transform’ which
Amazon Prime members might have a chance to get Office 365 cheaply while the Prime Day deals are on. The Amazon ‘Prime Day’ runs for two days (go figure), Monday 15th and Tuesday 16th apparently according to local time zones. Office 365 Home is often discounted but rarely to the
Sketchy Shapes, the new line option in Office 365 now has a little video to go with it. Sketchy line option in Office for Windows and Mac Sketchy or wriggly lines in Icons and SVG graphics Source: Microsoft
The 50th anniversary of Apollo 11 is our excuse to show-off some features in Outlook for Windows/Mac. How to add past events, post events in other time zones, get reminders of upcoming anniversaries and set reminders for longer times than Outlook allows. Adding Past Events Outlook can save details of
PowerPoint for Windows and Mac getting much better ink replay and animation support as shown in a new build for Office Insiders. Up to now, digital ink drawings could be replayed as a simple animation. That’s been available for about three years starting with OneNote Mobile. That was OK but,
