To apply a filter, select the arrow in the column header, and pick a filter option. Select the data you want to filter. For best results, the columns should have headings. On the Data tab, choose Filter. Select the filter arrow next to March > Number Filters > Less Than and enter 6000. Click OK.
Guide to Filter in Excel. Here we discuss how to use/add filters in excel along with step by step examples and a downloadable template
Filter your Excel data to only display records that meet certain criteria. This is page 1 of 10 in our comprehensive filtering course. Click any single cell inside a data set. On the Data tab, in the Sort & Filter group, click Filter.