MUO on MSN

Once you understand SCAN in Excel, you’ll never build formulas the same way

The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...

How to hide and unhide columns in Excel to optimize your work in a spreadsheet

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to ...

How to split cells into columns in Microsoft Excel using the 'Text to Columns' feature

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.
How-To Geek on MSN

4 New Microsoft Excel Features to Try in October 2025

All details in this article are correct as of October 7, 2025. Accessibility to some of the latest Excel features depends on ...