I'm not sure what you mean by turn columns off.

If you want to get rid of the dropdown arrows, you'd need some code to hide
those. But this isn't really necessary. You can just ignore those dropdowns
(or use them when you need them).

If you mean how you can see the data again, you can use the each filtered
dropdown arrow and choose All. You can also use data|Filter|show all to see all
the data without going to each arrow.

If you mean not see the columns, you can always select the columns you don't
want to see and Edit|Format|column|Hide--but this isn't using autofilter.

roger_home wrote:

Dave,

You are probably right...data/filter/autofilter would probably work
better than a pivot table. Question: after selecting whole database,
how do you turn certain columns off?

--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson