logo ASAP Utilities
HomeExtra features for ExcelColumns & RowsAdvanced Sorting...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Advanced Sorting...

ASAP Utilities  › Columns & Rows  ›  2. 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.

    Screenshots

    Columns & Rows  ›  2 Advanced Sorting...
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Columns & Rows  ›  2 Advanced Sorting...
    Additional keywords for 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
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.