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:
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:
No comments:
Post a Comment