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…
Why is it still a pain to make table column reference absolutes?
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle to populate adjacent cells. Using A2 as an example, you…
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…
Why Excel needs a ‘drag and swap’ mode
Sometimes when we drag a cell from one place to another, our intention isn’t always to replace a value. Instead, we might want to swap one value with another. That’s why we need a ‘drag and swap’ mode. Whether it’s…
My best Excel tip of 2024
For the second year running, I’m delighted to have participated in John Michaloudis‘ The Best Microsoft Excel Tips & Tricks in 2024. This annual tradition is a roundup of tips and tricks from Microsoft MVPs and experts that will save…
