Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my worksheet where I have my pivot table I have many different filters to chose between.

To the eye it doesn't really look nice and I want to be able to maybe split that long list of filters into a few shorter ones. But I can't figure out how to do this. I've seen where I can move the whole pivot table, but then it's all included and as one piece that can't be split.

Does anyone know if this is possible?

share|improve this question

In Excel 2010 you have an option to "replace" filters with Slicers. You can choose the slicer in the Pivot Table's Options Tab (Sort & Filter group). Slicers can be moved and formatted much easier than traditional pivot filters. They also have an extra advantage of being able to feed multiple Pivot Tables with the same filtering.

Note: If you're using Powerpivot, slicers are built into the Pivot Table Field List, making them even easier to get to and use.

share|improve this answer
thanks for reply! yeah i know about slicers n am using them two filter some variables that i want to go trough all the pivot tables....and i know they are possible to be moved etc...but still want to use the "normal" im guessing u dont know, if even possible, how to relocate the traditional filters on the sheet? – Maria Jun 19 '12 at 12:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.