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

Language: English Nederlands (Dutch) Deutsch (German) Español (Spanish) Français (French)

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)
  • Formula
  • Email address host (@...)
  • Alphanumeric content based on the numeric portions
  • 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)

    Video example

    Screenshots

    Range » Advanced sorting...

    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
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utitilities
    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

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2013 - - - - The Netherlands EnglishDutch - NederlandsGerman - DeutschSpanish - EspañolFrançais (French)

    Connect with us and receive our "tip of the week" at:
    Follow us on TwitterFollow us on Facebook