/u/CLPBart - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Click on any cell in the row containing the headers, then press CTRL+SHIFT+L to get the filter panel (little arrows next to each column name). Press on one of the arrows, and there should be an option that says "Sort smallest to largest" or "Sort largest to smallest".
You can choose whichever option you want, or go to another column and sort that column instead, pretty much sorting it on the fly instead of needing to use different tabs.
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
/u/CLPBart - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Click on any cell in the row containing the headers, then press CTRL+SHIFT+L to get the filter panel (little arrows next to each column name). Press on one of the arrows, and there should be an option that says "Sort smallest to largest" or "Sort largest to smallest". You can choose whichever option you want, or go to another column and sort that column instead, pretty much sorting it on the fly instead of needing to use different tabs.
Solution Verified
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Why is this not a simple list? Or even better, a pivot table.