Stacking it on a Saturday run
On a mild yet wet, muddy, and sludgy early morning, my Saturday 12 km run turned into a bit of an obstacle course in places. However, I was doing fine up until the last couple of kilometres, when I unexpectedly…
How to enable Dark Mode in Excel
Dark Mode is available everywhere these days across a multitude of apps and devices. Usually, the process of switching it on and off revolves around a single toggle. Weirdly, Excel’s Dark Mode works a little differently, though. Go back to…
DON’T delete rows like this in Excel
There are a tonne of videos out there showing how to delete blank rows in Excel. And the method shown is pretty much the same each time. However, I’ve noticed most of them do not mention one notable flaw. Firstly,…
Fill blanks with value above in Excel
Got some gappy data? You can fill the blanks by repeating the last visible value until a new one appears, using one of these methods: Select a range with a value at the top followed by blank cells. Then press…
Split lines of text into columns in Excel
If you’ve ever had a list of values that contain line breaks, you might’ve wondered how to split each line into its own column quickly. Say you’ve got a list of addresses in A2:A11, each one containing four lines within…
Excel FORGOT the clocks went back — this has consequences
At the weekend, the clocks went back across Europe, allowing most of us to enjoy an extra hour in bed! In the UK, this occurred on 26 October at 02:00 BST, meaning the hour before was repeated. The issue is…
