Excel-related articles.
Wouldn’t it be great if the HYPERLINK function was fully compatible with dynamic arrays? Here’s the function’s syntax: I have a table called tblWebsites featuring three websites, each with its name and URL. In D2, if I were to reference…
Ah, it’s all Excel’s fault again, isn’t it? Austria’s Social Democratic Party ran an election over the weekend to determine its new leader. After nearly 600 members cast their votes, it was announced that Burgenland governor Hans Peter Doskozil had…
Typing equals (=) in a cell or the formula bar followed by a letter presents you with Formula AutoComplete, a dynamic drop-down that displays functions beginning with that letter. The majority of functions are listed alongside a small circular icon…
What constitutes copyright infringement on LinkedIn? That’s the question I’ve been asking myself recently, and I felt compelled to post this after seeing yet another blatant breach of copyright law yesterday. Microsoft MVP Soheil Bakhshi informed followers that a PDF version of…
Looks like Excel’s error dialog boxes have finally been brought into the 21st century! They now have a modern appearance and fit better with the Excel theme. It’s a minor change in the grand scheme of things, but a UI…
As a rule of thumb, referencing a whole column in Excel isn’t considered good practice. It’s better to include only the cells you need in a range. And it’s even better to use tables so you’re working with structured references….
