Home Screenshots 10 Languages Why use it?

Tip of the Day | Saturday May 2nd, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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

Starting this tool

Click ASAP Utilities › Columns & Rows › 2. Advanced Sorting...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

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