3 ways to autofit columns & rows in Excel
Are your columns and rows a bit of a mess? Too wide, too narrow, too tall, or too short for the data they hold? Here are three ways to optimise their size: Mouse method Click the top-left corner of the…
When is an identical value not an identical value in Excel?
When a calculation goes wrong in your worksheet, it’s usually because of a faulty formula — so you spend seconds, minutes, or hours trying to correct it. But sometimes the issue is actually with your data, even if it’s not…
STOP text from overflowing and wrapping in Excel
In a recent viral TikTok video, creator @frogtownmayor went on a lengthy rant about Excel’s default text overflow — where a cell’s contents spill into the empty cells beside it. While it might sound like a trivial complaint, it’s bugged…
EXCEL IS 40! 🥳
Happy birthday to Excel! Check out my video reflecting on its beginnings and the path that led to where it is today. Watch the video Transcript Microsoft Excel is 40! That’s right. It was on 30th September 1985 when the…
When to use FILTER over XLOOKUP in Excel
There are numerous ways to find the highest value in a column and return one or more values in the matching row. In this example, a table called tblSales houses some monthly sales data. XLOOKUP is combined with MAX to…
Trim ranges with the dot in Excel
How do you reference a range in a formula? For decades, the answer has been simple: select multiple cells to create a reference with the starting cell on the left, a colon in the middle, and the ending cell on…
