display only certain names in a column or all rows that have that name

A

Arvi Laanemets

Hi

Use Autofilter feature.


--
(When sending e-mail, use address [email protected])
Arvi Laanemets


Bev said:
I have a data base with a lot of different cities and would like to print
all of one only city at a time. Is there a way of doing this
 
B

Bev

I have a data base with a lot of different cities and would like to print all of one only city at a time. Is there a way of doing this
 
J

Judy Freed

If you have your City in a separate column, you can use Autofilter to filter
the list to display only a particular city. You can print from there.

To use Autofilter, click in your database, then select Data,Filter,
Autofilter from the Excel menu. Little arrows will display next to your
column headings. Click the arrow next to City and select the desired city.

Judy Freed


Bev said:
I have a data base with a lot of different cities and would like to print
all of one only city at a time. Is there a way of doing this
 
P

Peo Sjoblom

You can use autofilter, select the header and do data>autofilter, in the
cities column filter
on the city of your choice and then print

--

Regards,

Peo Sjoblom


Bev said:
I have a data base with a lot of different cities and would like to print
all of one only city at a time. Is there a way of doing this
 
Top