Hello,

Using Excel 2003. Is there an easy way when using a pivot table, that when I select a column heading where it has the drop down arrow and "Show All" along with all the numbers assoicated to that column. If there are say 200 individual #s' in column, is there an easy way to select a range?

For example:

it has

Show All
# N/A
-5
-4
-3
-2
-1
0
1
2
3
4
etc all the way up to 200.

I want to select say only the negative numbers, or only numbers starting from 4 or Higher, how can I do this without having to manually click on each box for the range of criteria i want?

Thanks