Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

In the screenshot below, when the first and last initials of the names in columns A and B are typed into cells C2, C3, and C4 ...

Checkboxes in Microsoft Excel are a great tool for tracking progress, improving data organization, and adding an extra layer ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Q. How do I spill formulas in Excel? A. Spilling is a feature available in Excel 365 and later versions. With spilling, you can create a formula in one cell, and that formula will then spill over into ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

How to use passwords to grant users access to different Microsoft Excel workbook ranges Your email has been sent You can password protect a Microsoft Excel file, and ...