Excel

Hiding worksheets is a good way to reduce clutter in the tab strip and prevent unwanted use. But did you know there are two ways to hide worksheets? The simple way Right-click on a tab and select Hide. To make…

Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you’ll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it…

Numbered lists are a great way of staying on top of work or personal tasks. However, not all methods are equal. Suppose we have a task list in A1:B6, with the headings in the first row, the numbers on the…

A merged cell in a spill range? That’s not supposed to be possible in Excel — but it is — if you know the secret hack. In usual circumstances, spill ranges can only have the number of cells that exist…

Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well, what better place to start than the very thing that…

Excel’s web scraping capabilities have improved in the last couple of years, thanks to an update to the Get Data From Web feature. However, while it can now extract content from a much larger pool of websites, it still lacks…