Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Build bulletproof workbooks with named ranges, dynamic tables, and Excel's built-in error-checking tools.

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...

At the heart of Netflix's "Stranger Things" is a girl with a "011" tattoo on her wrist. Her name is Jane, but she is almost always called Eleven. Though unusual, it's not out of the question for ...

When Andrew Grigolyunovich first started using Excel more than two decades ago, he never imagined the spreadsheet program would land him in Las Vegas or on ESPN. The Latvian financial consultant ...

A new Agent Mode comes to Office apps today, alongside an Office Agent in Copilot chat. is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 ...

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 stared at a tangled web of Excel formulas, wondering if there’s a better way to make sense of it all? For many, Excel’s LAMBDA function feels like a cryptic puzzle—powerful but ...

The move would reverse a yearslong effort to remove names and symbols honoring the Confederacy from the military. By Chris Cameron Chris Cameron covered the yearslong effort to rename Army bases that ...

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...