This Premier League results matrix is composed of 441 cells, but guess what? There’s only one formula. I remember the days when you had to use 441 formulas. Not to mention the helper columns, the supplementary tables, and the spiderweb…
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…
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…
A few days ago, someone in a Facebook group posted a photo of a newly erected road sign in my town, Harpenden. Pretty unremarkable, you might say — but it was erroneous, leading to an outpouring of annoyance, frustration, and…
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…
