Advanced Sorting...

Sort your data in ways Excel can't.
This tool provides more sorting options than Excel's built-in feature. You can sort by formatting, text properties, and custom order types. Whether you need to organize data by font, text length, special sequences, or even shuffle it randomly, this tool makes it easy.

Available options to sort by

• Value - Sort based on the actual cell value.
• Number Format - Sort by the applied number format.
• Cell Color - Sort by the background fill color of each cell.
• Cell Color Index Number - Sort by the internal Excel color index number assigned to each cell background.
• Font Color - Sort based on the text color.
• Font Color Index Number - Sort by the internal Excel color index number assigned to the text color.
• Font Size - Sort by the font size of the text in each cell.
• Font Name - Sort alphabetically based on the font used.
• Bold - Sort based on whether the text is bold or not.
• Italic - Sort based on whether the text is italic or not.
• Underline - Sort by whether the text has an underline applied.
• Strikethrough - Sort by whether the text has a strikethrough effect.
• Text Length - Sort by the number of characters in each cell.
• Random Order (Shuffle) - Randomly rearrange the rows for a shuffled order.
• Reverse Order - Reverse the order of rows in the selection.
• Formula - Sort based on the actual formula in each cell instead of the displayed value.
• Email Address Host (@...) - Sort by the domain portion of email addresses (e.g., @gmail.com, @outlook.com).
• Alphanumeric Sorting by Numeric Value - Sort text that contains numbers in a natural alphanumeric order (e.g., Item 2 before Item 10).
• Sort Numbers While Ignoring Negative Signs - Sorts numbers as if all were positive, treating negative values the same as their positive counterparts (e.g., -5 is treated as 5 for sorting purposes).
• Year-Month-Day - Sort dates in YYYY-MM-DD format.
• Year-Day-Month - Sort dates in YYYY-DD-MM format.
• Month-Day-Year - Sort dates in MM-DD-YYYY format.
• Month-Year-Day - Sort dates in MM-YYYY-DD format.
• Day-Year-Month - Sort dates in DD-YYYY-MM format.
• Day-Month-Year - Sort dates in DD-MM-YYYY format.
• Day of the Week, Starting from Sunday - Sorts days in the order of a week, beginning with Sunday.
• Day of the Week, Starting from Monday - Sorts days in the order of a week, beginning with Monday.

With these advanced sorting options, you can organize your data in ways that Excel's built-in sorting cannot achieve.

Starting this tool

Additional keywords to help you find this tool:
Colors, Order, Random, Randomise, Colour, e-mail, e-mail address, colours, sort by fill color, sort rows, change order, highlighted color, join colors together, background color, alphabetical order, flip horizontal range, flip vertical range

Tip:Alt+P for the previous tool.