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,…
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,…
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…
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…
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…
Are your columns and rows a bit of a mess? Too wide, too narrow, too tall, or too short for the data they hold? Here are three ways to optimise their size: Mouse method Click the top-left corner of the…
