Set a Filter

PROBLEM: I need to sort data or see appropriate data
SOLUTION: Use filter tool
RESULT:

FOLLOW ME THE STEP-BY-STEP GUIDE

1. Assume that you have this data (see below):

2. Select all your data including the heading title (in this case I wrote “My Column”)

3. In the Home ribbon, klik Sort & Filter component in Editing group and then click Filter (see below)

4. In “My Column” cell, you will see a small filter button (see below)

5. Click the button, then you can choose your filtering data. You can choose what data to show up and other data will be hidden or you can sort them.

NOTE: To deactivate filter function, do the step 3 again.

Hope helpfully. Any questions?