- 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)
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.
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.