Using Slicers with non pivot data

[McBee1989]

Hi all,

I am trying to present some basic data in a more user friendly way. I have a basic set of data (4 columns and 72 rows) and I would like to add a slicer to this for selection without having to pivot the data. Is this possible?

Thanks

 

[RoryA]

Which version of Excel do you have? You can use slicers with Tables in 2013 or later.

 

[McBee1989]

Ahh ok! I'm using Excel 2010... that'll be why it doesn't work. I did find a 'how to' on another site that said it worked from 2010 upwards however I can't seem to do it!

Thanks

 

[RoryA]

No, it won't work in 2010. Where did you see that, as a matter of interest?

 

[McBee1989]

Hi Rory,

Here's the link I was looking at : https://www.sageintelligence.com/ti...-tricks/2014/03/using-slicers-non-pivot-data/

I'm just hoping there's not something obvious I have missed now... wouldn't I feel silly!

Thanks

 

[RoryA]

That is using a pivot table.