logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

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

Range » Advanced sorting...

This tool extends the options to sort your data.
You can sort on up to 5 columns at once. Furthermore you can sort on many more properties than just the cell values.

With this tool you can sort by:
  • Value
  • Number format
  • Cell Color
  • Cell Color Indexnumber
  • Font Color
  • Font Color Indexnumber
  • Font Size
  • Font Name
  • Bold
  • Italic
  • Underline
  • Strikethrough
  • Text Length
  • Random order (shuffle)
  • Reverse order
  • Formula
  • Email address host (@...)
  • Alphanumeric content based on the numeric portions
  • Value, ignore minus sign (-) in numbers
  • Year-Month-Day
  • Year-Day-Month
  • Month-Day-Year
  • Month-Year-Day
  • Day-Year-Month
  • Day-Month-Year
  • Day of the week (start on Sunday)
  • Day of the week (start on Monday)


    Range » 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 utility

    In the Excel menu choose: ASAP Utilities » Range » Advanced sorting...

    « Return to the list of “Range” tools.
    « Previous
    Find and/or replace in all sheets...
     Next »
    Sort the data in random order
    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

  • Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Contact Us ^ Back to Top
    © 1999-2022 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook