Custom Sorting months in Pivot Table - Excel Tips and Tricks
Discover how you can custom sort months in pivot table
Here are the steps outlined in my video.
Add Custom Month List
1) File ~ Options
2) Advanced
3) In General group, click on "Edit Custom Lists..".
4) NEW LIST
5) Add custom month order.
6) OK
7) OK
Sort Month
1) Filter pull down
2) More Sort Options...
3) Ascending (A to Z) by: "Month"
4) More Options...
5) Filter key sort order to custom months
6) OK
7) OK
#tips #excel #shorts #fyp
Watch video Custom Sorting months in Pivot Table - Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 06 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,491 once and liked it 165 people.