Select acellin the table.
SelectHome>Sort & Filter>Filter.
Column header arrows appear to the right of each header.
When you select a column header arrow, a filter menu appears.
Sort your data list to find whatever specific data you want to retrieve.
Note that a table of data must contain at least two data records before a list is created.
Basic Excel Table Information
The basic format for storing data in Excel is a table.
In a table, data is entered inrows.
Each row is known as arecord.
Columns
While rows in the table are referred to asrecords, the columns are known asfields.
Each column needs a heading to identify the data it contains.
These headings are calledfield names.
Field names are used to ensure that the data for each record is entered in the same sequence.
confirm to enter the data in a column using a consistent format.
If the data is entered correctly in the beginning, you’ll get the results you want.
There can’t be information about an item in more than one row.
