Secret Excel hack — merged cell in spill range
A merged cell in a spill range? That’s not supposed to be possible in Excel — but it is — if you know the secret hack. In usual circumstances, spill ranges can only have the number of cells that exist…
Building an Excel football league table — 5 years on
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…
The great ice scam
Here’s my Vanilla Iced Matcha Latte. I purchased it today from Cafe Nero for £4.50. What do you notice? That’s right, it’s full of big blocky ice cubes. There’s about 15 of them filling half the cup that could have…
How to scrape files from the web using your web browser
Excel’s web scraping capabilities have improved in the last couple of years, thanks to an update to the Get Data From Web feature. However, while it can now extract content from a much larger pool of websites, it still lacks…
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…
