Sort by Text, Length, Color, Font Style

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Excel Sorting by Text Value, Text Length, Cell Color, Font Style

Sort by Text Value

Click a single cell in the column that you are going to sort by. Invoke 'DigDB->Sort->Text Value->Ascending'. The table area will be automatically selected.

Practice file - sorting-special-demo.xls (16k)
Sorting options are already set. The sort-by column is 'Col1', 'Ascending', and the special sorting option is 'by Text Value'. You can simply click OK to sort.
Result of sorting by text values - '9' is sorted to after '234'

Sort by Text Length

Click a single cell in the column that you are going to sort by. Invoke 'DigDB->Sort->Text Length->Ascending'. The table area will be automatically selected.

Practice file - sorting-special-demo.xls (16k)
Sorting options are already set. The sort-by column is 'Col2', 'Ascending', and the special sorting option is 'by Character Count'. You can simply click OK to sort.
Result of sorting by text length - the cell values are the same, but text length differ

Sort by Cell Color

Excel's Conditional Formatting allows to format cells based on conditions. After the formatting, you can use this special sorting to group together rows that meet the same condition.

Click a single cell in the column that you are going to sort by. Invoke 'DigDB->Sort->Cell Color->Ascending'. The table area will be automatically selected.

Practice file - sorting-special-demo.xls (16k)
Sorting options are already set. The sort-by column is 'Col3', 'Ascending', and the special sorting option is 'by Cell Color'. You can simply click OK to sort.
Result of sorting by cell color

Sort by font style

Font style refers to bold, italic, or regular. Sometimes user mark up cells with different font styles. Now you can sort them up.

Click a single cell in the column that you are going to sort by. Invoke 'DigDB->Sort->Font Style->Ascending'. The table area will be automatically selected.

Practice file - sorting-special-demo.xls (16k)
Sorting options are already set. The sort-by column is 'Col4', 'Ascending', and the special sorting option is 'by Font Style'. You can simply click OK to sort.
Result of sorting by font style

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.