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
Here’s a far better way to view and edit formulas in Excel than the small formula bar. It’s a free add-in from Microsoft’s Excel Labs called Advanced Formula Environment (AFE) Understanding Excel formulas can be difficult, even ones you’ve written yourself. Imagine trying to work with a monster formula like
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.
In Microsoft Word, you can use keyboard or mouse shortcuts to select characters, words, lines, paragraphs, and blocks of text faster. Here are ten different selection tricks that Word experts know to speed up their work. Select a Sentence Highlight an entire sentence in Word by simply holding down the
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
Word Designer is a really fast way to reformat a document into something very interesting and professional. Here’s how to use it properly and add extra tweaks to make your Word doc look really great. All these documents were transformed from a plain document with a few clicks. Word Designer
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
Microsoft Office Icons and other SVG graphics can be improved a lot simply with Sketchy or Sketched lines. They turn an icon or graphic from something formal into a hand-drawn and casual look. Sketchy lines is the ‘hand-drawn’ line option available in Microsoft 365 for Windows or Mac plus Office
Get more from Microsoft Office Icons, Illustrations, Cartoon People and other SVG graphics by turning them into Office Shapes which opens up many more options for editing and recoloring the graphic. That includes ‘splitting’ a single graphic into parts that can be changed separately. Microsoft 365, Office 2021, 2019 and
Word has some quick ways to turn a plain document into something fantastic. All it takes is a few clicks on the Design tab to change the overall look, fonts and colors. And we’ve added tips to fix formatting that doesn’t change. Let’s start with a very plain version of
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
Microsoft Application Guard for Office is being ‘deprecated’ (phased out) in Windows 11 and Windows 10 after only a few years. No official reason has been given and the excuses don’t make sense. Back in 2019 Microsoft announced Application Guard as a new way to isolate macro enabled documents from
Outlook 365 for Windows can crash when sending email from a Outlook.com is more than usually embarrassing for Microsoft. The bug is only in the Current Channel (Preview) version 17029.20028 which is the version to everyone on that pre-release option. Other releases like Beta channel and the public release are
Good news for some Visio Online users, the browser-based version now has layers! The bad news is that it’s only for those who pay extra for Visio Plan 1 or 2. Visio Online is available to most Microsoft 365 Business and Enterprise plans. ‘Full’ Visio with a desktop app and
If your Outlook roaming signatures have disappeared, there’s a few things to check first then recover them. Modern Outlook for Windows has roaming signatures but sometimes they don’t behave. See Roaming email signatures in Outlook 365, 2021, 2019 for how they are supposed to work and Outlook signatures and roaming
Signatures in Outlook have changed for Outlook 365, Outlook 2021 and Outlook 2019 but they have troubles, at least for Microsoft managed mailboxes (Microsoft 365 and Outlook.com). In January 2020, Microsoft promised to make email Signatures ‘roam’ meaning they would synchronise and appear on each version of Outlook using the
