excel 2007 filter 3 text values at the same time from the same co.

I

Ivanka

I have a column that has these values AA, AX, AW, RJ, WD, CA, IE, NC
Now I would like to filter AA,AX and IE only. How can I do it with just one
step instead of filtering each one separately, copying and pasting onto
another worksheet.
Please, help
 
G

Gord Dibben

Data>Autofilter then clear "Select All" and select AA, AX, IE


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 SUBTOTAL anomaly when filtering 3
Text spacing uneven when copying charts from EXCEL 2007 to WORD 20 4
Copy several sheets from one workbook into another at the same tim 2
Sorting Numbers as Text 3
Adding multiple values in one column based on multiple values of the same value (text) in another co 1
TEXT to COLUMNS 2
Split a worksheet into multiple worksheets of the same Excel file 1
Printing Cheque of Different sizes from the same Worksheet 9

Top