Checkboxes have never been Excel’s biggest strength because: 👎 They cannot sit in cells.👎 They cannot be resized.👎 They cannot be coloured.👎 They are only compatible with desktop versions.👎 They are visibly pixelated even after zooming in a tad over 100%.👎…
We’re only 3¾ years into this decade, yet we’ve already seen game-changer after game-changer come to Excel. Next on the conveyor belt is Copilot, which will be made generally available according to the following schedule: When Microsoft first announced Copilot…
Excel has a vast range of keyboard shortcuts, and there have been a few added to the list over the years. New ones introduced include: However, I’m sure there’s a commonly-used feature you wish had a shortcut. Of course, you…
Excel’s border styles help us enhance the structure and readability of our worksheets. Thick, thin, dotted and dashed — there are 13 variations to choose from in the Format Cells window. However, ever noticed how border lines on the edge…
Two weeks ago, the bombshell news about Python integration coming to Excel was greeted with rip-roaring excitement. The secret had been well-kept by tight-lipped Microsoft MVPs, who were finally able to bombard us with their pre-recorded demos to whet our…
Sometimes data is perfectly shaped and structured — other times, it’s not. If you’ve used pivot tables, you’ll be familiar with the cross-tabular format, which summarises data based on two or more categorical variables. While this layout is great for…
