Deleting rows from a large filtered range in Microsoft Excel can take a long time, temporarily place the program into a "not responding" state, or—in a worst-case scenario—cause Excel to crash ...

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

We show you how to autofit in Excel for both columns and rows, using double-click. shortcuts, and the ribbon.