Excel Pivot Table: How To Sort By Values

preview_player
Показать описание
This video will show you how to sort by values in a Pivot Table in Excel. In pivot tables the default sorting is done by labels. Learn how to sort pivot tables by values.

You've found the ideal video if you're trying to figure out how to sort by values in an Excel pivot table.

Sorting data is helpful when you have large amounts of data in a PivotTable. Therefore, I give you the solution, it is simple and fast.

You can sort by alphabetical order, from top to bottom, or from bottom to top.

Sorting is a way to organize your data so that it is easier to find specific items that require more careful consideration.

All you have to do in order to custom your sort options is to click on More Sort Options and pick the type of sort you want.

It's so simple and helps you a lot to view your data the way you want.

If you find this useful, please drop a 👍 on the video and subscribe 🧐

Timestamp:
00:00 Default sorting
00:25 Customize your SORT options
01:03 This is how you do it!🧐

🔴 RECOMMENDED VIDEOS/PLAYLISTS

Feeling generous? I like coffee.🤗
Рекомендации по теме
Комментарии
Автор

Need help with Pivot Tables? 😰
✅I created a playlist with all the tips & tricks you'll need to master them:

cogwheelLearning
Автор

Thanks! This was perfect and easily explained!

bris_momma
Автор

How did I not know this before. Brilliant explanation

walshedav
Автор

This was very helpful for my homework thank you.

Helptosave-ucpc
Автор

It's weird that Excel doesn't offer the option to sort from the table headers when it comes to Pivot tables.

ChallengerRhino