What to use To filter data (in Excel)?

Answer 1

There is an "Auto-filter" selection in the Data Menu Tab. After you select "Auto-Filter", there is a selection drop-down box which allows you to filter by the existing items in the column, or you can type in your own custom filter from the same menu. In Excel 2007, you can even filter by color of the cell.

Answer 2

If you mean to hide columns by filtering them, as opposed to hiding rows, by filtering them, then the answer is no. The purpose of filtering is for reducing the amounts of rows that are seen, as properly laid out data is built in rows. However, you can use an Advanced Filter to take data from just some of the columns that are in your data and extract rows that meet your criteria and display data from those columns in another part of your workbook. You can do this by building criteria and using just the columns that you need. It will then extract the data from those columns only.

Answer 3

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Answer 4

Filtering means reducing down the data you see by applying criteria. So if you had a block of data and only wanted to show something that met certain criteria you could filter it. You could have a table of sales by different salesmen in different regions. By filtering you could do things like show all the sales by one particular salesman or all the sales in one of the regions or show sales above a certain amount.

Answer 5

1. Select the data you want to filter

2. Data | Filter | Advanced Filter

3. Click "Unique Records Only"

Answer 6

The AutoFilter.