Excel-related articles.
Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well, what better place to start than the very thing that…
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…
If you’re presenting an Excel formula for auditing, troubleshooting, or educational purposes, the FORMULATEXT function is very handy. It lets you display the formula from a cell (or range) as text, while updating automatically whenever there’s a change. Needless to…
My new Excel Christmas long-sleeved T-shirt arrived today, and I couldn’t wait to try it on! Here it is… If you’re an Excel longtimer, you will have inevitably faced the #REF! error from time to time. What is so significant…
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…
Today, it suddenly dawned on me that Office Scripts has been around for five years. After being announced at the Microsoft Ignite Conference in November 2019, it was reasonable to assume this was going to be the natural replacement for…
End of content
End of content
