Excel mail list

Occasional Visitor

I have an excel mailing list. I need to pull names, titles and addresses and create a new mailing list. I want to create a new list with people with specific titles. How do I do that?

1 Reply

@Val1058 First, make sure the the list does not contain blank rows and columns. Then, select a cell anywhere in the list. On the Home ribbon, find this icon:

Screenshot 2022-04-16 at 05.48.20.png

and activate the Filter. This will put small downward pointing triangles across all headers.  Press the arrow in the "Title" column and select the titles you want to extract.

 

Copy the filtered list and paste somewhere else as values.