Sorting Text like Month Order

[PKGARG]

I have created a table in excel with column name Month and data in Month column like Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar

When i am using slicer its sorting it aToZ or zToa, but i need same like in Month Column

Any Solution

 

[Yongle]

You can do this with standard data sort

- select leftmost cell of headings and {CTRL} A to select table incl headings
- and click on Data tab

Sort \ select Months Column \ click dropdown under ORDER \ click Custom Lists \ click Jan,Feb,Mar... \ click OK


(If you created the table using Insert \ Table\ .. the sort will work correctly by selecting any cell in the table - Excel assumes that the whole table should be sorted)

 

[Yongle]

Apologies - I missed the "slicer" bit of your question.
I am away from my PC so cannot test, but (from memory) I think the values in column Month must be "dates" not "text" (with number format "MMM" to give you Jan, Feb, Mar) and then the values will be sorted the way you want in the slicer.