Excel-related articles.
In a new Excel worksheet, I enter this formula in A1: After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD is indeed the 16384th column of a worksheet — the very…
English is an ever-evolving language, with most dictionaries welcoming 500–1,500 new words every year. The job of a lexicographer is to compile dictionaries, adding and editing entries as they monitor what and how words are used in everyday life. Lexicographers…
Excel has limits — plenty of them. Whether it’s the number of worksheet rows, characters in a cell, or the percentage you can zoom in. We’ve all bumped into a limit of some type at some point. There’s a useful…
Just an outrageous idea I’m mooting… Ever since Excel burst onto the scene, it’s been based on a worksheet grid. Each cell in that grid accepts either a formula or constant value. The formula bar is primarily used to input…
Who knew Excel spreadsheets could produce such exhilaration and palpable tension among competitors and crowds alike? Well, there certainly was at the Microsoft Excel World Championship 2023, which took place in Las Vegas days ago in front of a captivated…
Want to crash Excel? Of course you do, and there’s a concoction of things you can do to cause one (and frustration). Reference the same range in GROUPBY’s row_fields and values arguments, along with using PERCENTOF in function and 0…
End of content
End of content
