Extract URLs from hyperlinks in Excel
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…
How the FORMULATEXT function could be improved in Excel
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…
Copilot is unavoidable and inescapable
I was only trying to give my rabbit a Hollywood smile using the Format Painter tool, but that blimmin’ Copilot button got in the way again! Thankfully, it is possible to switch it off without fully turning off Copilot. Go…
Insert the current date and time in Windows
In Excel, it’s easy to insert the current date and time into a cell. You only have to press Ctrl + ; for the date and Ctrl + Shift + ; for the time. Use the former, the latter, or…
The evolution of the Global Excel Summit lectern
It’s funny how your memory can play tricks on you. I was convinced the lectern at last year’s Global Excel Summit was made of some shade of mahogany wood — more akin to the traditional ones I grew up seeing…
Reflecting on the Global Excel Summit 2025
Wow! What can I say? It’s crazy to think a week has already flown by since the eve of the Global Excel Summit 2025. Reading all the rave reviews flooding in since has been great. Such is the eagerness of…
