method

437Currently online
10Today's Reading
20Share Today
Multilingual display

How to filter criteria in excel

2018-04-29 22:24:39

Complete the criteria filtering in an excel table

Tools/Materials
1

excel spreadsheet

2

wps

Methods/Steps
1

First, we open a table and select the first row title bar. After selecting it, we find the filter in the window.

2

Click Filter and select the small triangle at the bottom right of the column you want to filter

3

After clicking the small triangle, the filter criteria will appear

4

Here we find the [space] item we want to filter, and finally confirm the completion of the condition filtering in the table.

Recommendation