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,…
Has Costa lost its way?
The other week, I went to Costa Coffee and the lady in front of me asked the barista, “Do you do matcha?” “No, we don’t do matcha,” was the response. She sighed and walked out. I thought to myself, well,…
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: Keyboard method You can also select the first non-blank value down to the last blank…
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…
