Andrew Moss
Excel Aficionado
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle…
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings…
In a new Excel worksheet, I enter this formula in A1: =SEQUENCE(3276,16384) After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD…
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…
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…
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…
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…
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…
Yippee! 🥳 Excel finally has a date picker 📅 — imitating another Google Sheets feature — except going above and beyond to ensure it’s a cut above. At the moment,…
Cambridge Dictionary (CD) has named ‘hallucinate’ as Word of the Year. No, not to celebrate a surge in psychoactive substance usage, which causes users to see, hear, feel, or smell…
The announcement of eta lambda support has further simplified the summing of columns. When the BYCOL function was released, I was impressed that we finally had a solution that didn’t…