Site icon ExcelNotes

How to Filter a Table

If you are working on a data range, and want to convert the range into a data table, please check how to convert data into a table. Once you have the table, please see steps below to filter a table:

Step 1: In the Table, click the small triangle right after the column name in the top row (e.g., first column);

Step 2: In the drop down window, select a value (or values) from the list;

Step 3: For example, select value 2 and 3 from the list;

Step 4: The table with the selected values will be created, other rows are filtered out.

Exit mobile version