These four overlooked Excel features completely changed how I design spreadsheets.

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

If Excel freezes when deleting rows or columns, identify the possible causes and then resolve the issue. Turn off Auto Save, disable COM Add-ins, etc.

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

Ms. Willis Aronowitz is a writer, a critic and the editorial director of The Meteor. In the middle of the night a few days before Thanksgiving, I woke up with excruciating abdominal cramps. A CT scan ...

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

Don't want it? Time to switch office suite providers, then. When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.