I am not sure about 2000 but in my 2007 Excel I choose Pivot Tables, Select,
and then make sure Enable Selection is pressed. That will give you the thick
black arrow you are looking for that when you hover your mouse at the
beginning of a row, which then allows you to select all rows of a field at
once.



"ChuckW" wrote:

Hi,
I have Excel 2000. Once I created a pivot table, I used to be able to
format various fields as currency or percentages and hide totals. I would
hover my mouse at the beginning of a row and click. It would highlight all
values in a category. I would then select currency and it would highlight
all currency values in the category. For some reason, I lost this
functionality. The output in a pivot table can no longer be highlighted. I
don't remember changing anything though. Can someone help?

Thanks,
--
Chuck W