In that case just click on the arrow for Clients or Business Types.

You cannot filter just one or two columns and have the others not filtered
along with it. Filtered out rows will be hidden no matter which column you
use as the criterion column.

If the extra arrows bother you, select just those two columns by selecting the
headers, you will get filter arrows in just those columns.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 15:07:02 -0800, "celestemberner"
wrote:

I have a list of clients, phone numbers, types of business and dollar
amounts. I only want to use the auto filter for the columns that have client
name and types of business. It would do no good to filter by phones numbers,
etc.