How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

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

Click and drag over the cell or range of cells that you want to receive the conditional formatting. Excel automatically copies the formatting into the range when you release the mouse button.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.