Excel-related articles.
I wonder where Excel will be in 4.1 years, let alone 41. The last couple of years have been dominated by Copilot updates, so it’s easy to see the direction of travel. After all, we’re living in a rapidly changing…
It’s taken a while, but two long-requested features have finally arrived in Excel! They’re not exactly groundbreaking, but they’re welcome additions that make a couple of everyday tasks that little bit easier. For those who want to name their tables……
Custom formatting is a great way to control how values are displayed, but formats are designed to sit on a single line, which isn’t always ideal. Take a football match summary, for example. You might want to display the day,…
Excel’s calculation engine just got upgraded. And it’s the biggest change since dynamic arrays came about at the back end of the last decade. Formulas can now respond to the active cell, something that previously required VBA. As a result,…
When you open a file in Excel with US dates (month/day/year), things can quietly go wrong. The US is the only major country in the world that uses this format as its primary standard, while the vast majority use day/month/year….
Focus Cell is a great feature that has only been around for 1½ years, despite many people requesting it for years before. With a single click of the button on the View tab, Excel highlights the active row and column,…
