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.
How to use the font kerning settings in Microsoft Office, Word and PowerPoint and fix the default setting for Heading styles in Word. Kerning letters makes a difference as the letters get larger so the setting is more important for headings and titles in Word and PowerPoint. Here’s common Arial
Meta has joined the ‘text to image’ AI race with Imagine. Here’s how to use it to make interesting pictures quickly and bypass its current limits. There are so many AI tools out there, in particular ‘text to image’ makers, Microsoft has ‘Generate Image’ in Designer and a separate Image
Excel Labs has just added a nice formula Debug option that helps you understand the steps inside a formula and fix errors. There are already three ways to look inside a formula; Evaluate Formula, F9 to calculate part of a formula and the recent Visual Preview. Now Microsoft’s Excel Labs
There are two important changes coming to Get & Transform (Power Query) in Excel. Both changes are probably already covered by the current setup but you should check any external data links now to avoid an unwanted surprise. These changes apply from 11 March 2024. Microsoft is a little vague
Microsoft Designer has secret key shortcuts to quickly insert shapes and text boxes without jumping to the side menus. All you need to do is press a single letter key to insert one of these shapes: R – Rectangle (inserts a square) C – Circle L – Line T –
Microsoft messed about with Notes and Comments in Excel 365. Here’s what’s happened, name changes, overlapping functionality and how Excel has gone from ‘Notes’ to ‘Comments’ and now back to ‘Notes’ again! There are now two different ways to add text notes or comments into an Excel 365 cell. The
Here are three ways to add an explanation or note within an Excel formula itself, instead of separate notes. The ‘Achilles Heel’ of Excel or any spreadsheet program has always been explaining or commenting of cell formulas. Adding comments is an important part of any code including Excel’s VBA but
Pantone’s color of the year for 2024 is “Peach Fuzz”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2024 is … Peach
The Microsoft 365 browser extra for Edge and Chrome is being ‘retired’ from January 2024 though not for any good or explained reason. Maybe it’s because Microsoft’s Edge browser has an in-built alternative? From 15 January 2024, there’ll be no more updates or support for the Microsoft 365 browser extension.
Designer in PowerPoint 365 is great, but it can be too pushy and intrusive with the Design Ideas pane popping up too much. Designer risks becoming the new ‘Clippy’! Here’s how to stop Designer appearing until you want it. PowerPoint Designer suggests slide designs based on the content. It’s a
PowerPoint Designer and Design Ideas is the start, not the end, of making a great looking presentation. Some simple changes will make something unique and not obviously copied from Microsoft’s template supply. We’ll show how to dig into the Design Ideas to change individual slide elements a little, or a lot. Not familar with
PowerPoint Designer should just be the start of making a great looking presentation. A few manual adjustments will transform Microsoft’s automated suggestions into something awesome and unique. All the design helpers in PowerPoint and Office have the same problem. Everyone uses them and so a lot of slides or docs end up
PowerPoint’s Designer suggestions work better if you add some words to the slide first. If you add some broad keywords or title, it gives Designer clues for the most appropriate look. Designer uses the text to choose from the many templates available. The words don’t have to appear in the
PowerPoint Designer is perhaps the most interesting and useful feature in PowerPoint 365. It turns a basic slide into something eye-catching. Here’s how to use Design Ideas effectively and wisely. It’s a very quick and easy way to take a couple of Design Elements and create a full-blooded Custom Style for
Google has more than 3,000 Icons available to add into Microsoft Office documents from either SVG files or a font. Material Symbols are a collection of small icons, much like the Icons available in modern Office. As SVG files they can be recolored and changed from their standard black line
Add the Croissant 🥐 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. I have to declare a personal interest in this article because the Croissant 🥐 is an essential part of my breakfast. No morning is complete without the “Three C’s”
Office for Windows and Mac has three special outline styles for the borders of shapes and text boxes. Called ‘Sketched’ or ‘Sketchy‘ because they have a hand-drawn line look. It’s a nice little addition to Word, Excel, Powerpoint and Outlook. Let’s see how it works plus some details and limitations
Here’s how to avoid the tricks hackers use to infect your computer via Office documents. Microsoft has added features to Office that should make it harder to infect your computer via a Word, Excel or PowerPoint document. Hackers have found ways to trick people into bypassing those warnings and enable
Insert the Telephone location ✆ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Telephone location ✆ symbol is supposed to be used as a sign for a phone box or booth but can be used for any ‘phone’ purpose. See also: Telephone Receiver
If you enjoy the stuff we do here at Office Watch we’d really appreciate you chucking a few dollars at our annual fundraising drive – and we have a new 2023 ebook for all contributors as a special gift. Donate via Paypal or credit card. The financial support of readers
Let’s explore the basic options for making a Table of Contents (TOC) in a Word document. Table of Contents is very easy to do in Word and it’s not just for people who are making books. TOC’s can be useful in any long document such as a contract. Beyond the
Choose specific words from a heading to appear in the Table of Contents (TOC) of a Word documents, instead of the whole heading. Welcome to the strange world of Word’s Style Separators. We’ve already explained Lead in emphasis which is easy to use. Simply select the text you want at
There are many different ways to change the look a Table of Contents from a Microsoft Word document. The standard ways, taught in most classes, force you to format your document in a way that suits Word. We’ll show you how to get a Table of Contents (TOC) from a
Four simple Microsoft Word tricks to squeeze a Table of Contents (or Table of Figures etc) into fewer pages. Here’s an example of a Table of Contents (ToC) that’s grown too big using Word’s default settings. It’s creeped over to a second page. We’ve seen ToC’s for big documents that
