Pivot Tables/Auto Filter question

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Hello-

Just wondering if it is possible to apply an autofilter to my Pivot Table.

From viewing some of the how-to's it appears that a down error, i.e. pull down filter option is available in Pivot Tables, but I can't figure out how to apply this to my Pivot Tables.

Any advice?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
After the pivot table is completed then you can right click on the upper left hand column identifer. Choose field in the drop down menu then select the advanced button. On the next pop-up screen is teh ability to sort or autoshow. Good luck I hope this helps
 
Upvote 0
Thanks for the response and I am familar with this tool, however it doesn't give me exactly what I am looking for.

I do appreciate your effort.

I am using Microsoft Excel 2000 Formulas text and this is where I got this URL from. Multiple references within the images in this book show a down arrow on the pivot tables. From knowing this down arrow in Microsoft Excel, I would suspect this indicates a pull down menu. I can't seem to figure it out.

I can provide page numbers specific to what I am talking about if that will help others help me.

Thanks!
 
Upvote 0

Forum statistics

Threads
1,203,542
Messages
6,056,017
Members
444,840
Latest member
RazzelDazel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top