Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Stop sacrificing screen space—Excel tables, Watch Window, Focus Cell, and split views keep context without locking rows.

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 ...

Have you ever found yourself staring at a sprawling Excel spreadsheet, overwhelmed by rows and columns of data that seem impossible to manage? You’re not alone. Despite its reputation as a workplace ...

Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.