You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

We show you multiple ways to freeze and lock the rows and columns in an Excel sheet using the ribbon interface.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

To fix an Excel spreadsheet not filtering correctly, ungroup its sheets, apply the filter to its entire spreadsheet column, and unmerge cells.

Excel spreadsheet showing how to use the FILTER function with SORT This formula will return a filtered table with only the products currently in stock, sorted by their price in ascending order.