Excel for Mac is often derided for being inferior to its Windows counterpart. But every now and then, you find the odd scrap and smidgen it does better. One of them is its table filter dropdown system. In both versions,…
If you copy a set of hyperlinks with friendly text from a website and paste them into Excel, each URL is embedded as part of the cell’s metadata. This poses a challenge if you want to extract them, as there’s…
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle to populate adjacent cells. Using A2 as an example, you…
Sometimes when we drag a cell from one place to another, our intention isn’t always to replace a value. Instead, we might want to swap one value with another. That’s why we need a ‘drag and swap’ mode. Whether it’s…
For the second year running, I’m delighted to have participated in John Michaloudis‘ The Best Microsoft Excel Tips & Tricks in 2024. This annual tradition is a roundup of tips and tricks from Microsoft MVPs and experts that will save…
I’m not sure how proficient Mr Trump is at Excel, but I just discovered something bound to pique his interest… 🇺🇸🇲🇽 In the ribbon border dropdown on the Home tab (also found in the right-click formatting menu), selecting ‘Thick Bottom…
