Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed. After you filter data, you can copy,
find, edit, format, chart, and print the subset of filtered data without rearranging or moving it.
Filter Text
1. Select a range of cells containing alphanumeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.
Click the arrow in the column header.
Do one of the following:
Select from a list of text values
· In the list of text values, select or clear one or more text values to filter by.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.
find, edit, format, chart, and print the subset of filtered data without rearranging or moving it.
Filter Text
1. Select a range of cells containing alphanumeric data.
2. On the Home tab, in the Editing group, click Sort & Filter, and then click Filter.
Click the arrow in the column header.
Do one of the following:
Select from a list of text values
· In the list of text values, select or clear one or more text values to filter by.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.
No comments:
Post a Comment