In Excel for Mac, when you select a range of values and then press Backspace, they are all cleared. The same behaviour occurs in Excel for Web. However, in Excel for Windows, it’s a different story. Pressing Backspace only clears…
Structured references are often preferred to cell references because they add a dose of readability and memorability. Let’s be honest, you’d rather see tblEmployees[Name] than A2:A11, wouldn’t you? A few months ago, I talked about how it would be good…
Last Thursday (30/05/2024), Jeremy Vine was joined by two guests on his BBC Radio 2 afternoon show. They were Giles Male, co-founder of Full Stack Modeller, and Harry Matthews, Group Financial Controller at the Landauer Group. Both discussed their love…
Get Data and Get data are two prominent UI buttons found on Excel’s Data tab and Power BI’s Home tab, respectively. Both have the same icon, and both serve the same purpose — to import data. One has a big…
Ever heard of ‘marching ants’? Although it’s not the most commonly used term in the Excel lexicon, it is more prevalent in graphic design. In software like Photoshop, marching ants refers to the moving dashed line that appears when you…
The current Excel logo was introduced in 2019, making it already half a decade old! On the Windows desktop version, you’ll see it in several places, most notably as the app icon in your Start menu, taskbar, and on the…
End of content
End of content
