BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.

Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get around Excel and make it do what you want it to do? Formulas are one of the ...

R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.

Microsoft’s January 2026 update puts Excel back in the spotlight. After a brief pause late last year, the company has resumed its monthly feature recap, and thi ...

Microsoft Excel was first released in 1987 and — despite popular competitors such as Google Sheets — is still used by millions of businesses throughout the world. Described as the “world’s most ...

Microsoft updates for Excel in January 2026 introduce Agent Mode with Copilot, new import tools, clearer error messages, Power Query on Mac and Web, and Office Scripts automation to ease daily tasks.

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I’ve accepted a job ...

After a year and a half of Copilot, the generative AI tool is getting to a genuinely useful place. That literal and figurative place is in Microsoft Excel. At the Microsoft 365 Copilot livestream on ...

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...

After a brief pause at the end of last year, Microsoft is back with its monthly feature recap, sharing what changed across its productivity apps in January 2026. And this time, the spotlight is on ...