Microsoft is changing one of Excel’s most familiar rules: a cell no longer has to contain just one value. The company has ...

Microsoft Excel now supports multiple values, Lists, nested arrays, and new array functions inside a single cell for Insider ...

Microsoft Excel cell arrays let you store multiple rows and columns directly inside one cell. Test this beta feature to ...

Microsoft has ended 40 years of single-occupancy for Excel cells and is now allowing multiple values to inhabit the same home ...

Have you ever found yourself buried under a mountain of Excel spreadsheets, painstakingly updating formulas every time new data comes in? It’s a common struggle, one that can turn even the most ...

Don't copy formulas cell by cell — you're working way harder than you need to.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how. Over the last few months, I’ve written about several of Excel’s new dynamic ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work. Most Microsoft Excel functions are autonomous—one ...

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time. Microsoft has ...