Days like today don’t come around very often, so it’s an appropriate time to remind everyone of the dreaded ‘leap year bug’. What is the ‘leap year bug’? Ever since Excel debuted for Windows in 1987, it has incorrectly recognised…
Have a look at these Excel buttons: What do you notice? That’s right. Inconsistency. For two of them, the negative action is on the left side and the positive on the right. However, it’s the reversal of this for the…
I’ve been to all four Global Excel Summits now, stretching back to the inaugural edition in 2021. I wasn’t an employee for the first two. However, I was delighted to become part of the setup in 2022, in prep for the…
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…
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are never up to standard. At home, I have a memory…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings up a window letting you limit the active cell or range…
End of content
End of content
