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 this: Happily, there’s an easier […]
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 Fuzz As usual what’s more […]
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. The extension will disappear from […]
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 Ctrl key, or the Command […]
Excel’s web version now has some better ways to insert functions direct from the function search window. Also easily see the open/close bracket pairs. Insert Function ‘wizard’ Insert Function has expanded into a little ‘wizard’ (remember those?) after finding the function, a second pane lets you insert parameters with some guidance. Go to Insert | […]