logo ASAP Utilities

You can do this too

Download now, it's easy
Sit down and relax, while ASAP Utilities does the rest!

ASAP Utilities menu

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

Example screenshot: Sorting with advanced possibilities
Sorting with advanced possibilities

Starting this utility

In the Excel menu choose ASAP Utilities » Range » Advanced sorting...
Additional keywords:
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


« Return to the list of “Range” utilities.
Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2010 - - - Excel tools - - The Netherlands EnglishDutch - NederlandsGerman - DeutschSpanish - EspañolFrançais (French)