All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint, Outlook on macOS, Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Master PowerPoint Handouts, make printouts look better
Handout Master lets you customize your presentation handouts more than the basics; changing the position and formatting of headers/footers, adding a background color or gradient. Maybe you can help uncover some unexplained mysteries of Handout Master, see below? Our Quick PowerPoint Handouts article showed you how to go to File | Print to print out […]
Quick PowerPoint Handouts
There are many ways to make a paper/PDF version of a PowerPoint slide deck, this is the quick ‘only a few clicks’ option. There are other choices that we’ll cover in upcoming articles. PowerPoint has some ‘Handouts’ features but they aren’t all in the same place and some aren’t even called ‘Handouts’! Why handouts? It’s […]
New PowerPoint handout feature isn’t new at all
A supposedly ‘new’ feature in PowerPoint 365 for Windows is already in regular PowerPoint? The latest Insiders version of Office 365 for Windows has no truly new features. The only ‘new’ feature is something that’s already in Office 365. As we looked down the list of changes in version 1909 build 16.0.12013.20000 it was all […]
Center Across Selection vs Merge & Center in Excel
There are two similar text formatting options in Excel. The well-known Merge & Center and the hidden away Center across selection. Both have their advantages, the choice is yours. Merge & Center Most Excel users know ‘Merge & Center’ because it’s atop the Merge list at Home | Alignment | Merge. It does two things: […]
Office 2019 isn’t dead though Microsoft wishes it were so
A lot of press reports about Office 2019 give the impression that the single-payment, non-subscription version of Microsoft Office is about to disappear off retail shelves. Everyone needs to take a deep breath and calm down … Office 2019 isn’t dead or even on life-support though Microsoft would love to stop selling it. It all […]
New icons for Access, Project and Visio … ho hum
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 changed Office icons; if we […]
Search for Microsoft Office Icons
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 the long list. There are […]
Sensitivity settings add security for Office documents
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 tab in Word, Excel, PowerPoint […]
Fast adding an appointment to Outlook and getting it right
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 into a blank Outlook appointment […]
Justify, Fill, Orientation, Shrink to Fit and other Excel formatting tricks.
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 are available in the Orientation […]
Excel’s text and number alignment choices
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 across and up/down, use the […]
Discount Office 2019 killed from Home Use Program
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 $200. The Home Use Program […]
Using Excel to make a better burger
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 guy in Singapore with a […]
Office 365 Home/Personal activation changes make sign-in better
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 five each of desktop programs, tablet […]
Do you have Dynamic Arrays in Excel 365?
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 version is possible, see below. […]
Excel now has Dynamic Arrays – Windows, Mac and more …
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 forward for Excel. All Excel […]
