Web scraping in Excel has just got better. If you’ve ever used the Get Data From Web tool, you’ll know how limited it was. After pasting a URL and clicking OK, you’d be presented with the Navigator window containing a…
One stealthy arrival to Excel recently is a Workbook Links button in the Data tab to replace the old Edit Links. Clicking it now unveils a pane to manage links to external data sources, such as other Excel workbooks. Previously,…
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%.👎…
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…
End of content
End of content
