![]() |
||
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
||
|
|
||
The Colored Cells Sorter for Microsoft Excel adds the following toolbar to Microsoft Excel:
Clicking on this button displays the following dialog:
Using the first option, sort by color, allows you to sort by font color or background color. For example
The Colored Cell Sorter allows you to sort the colored cells so that they are at the top or at the bottom. If you use the second option, show or hide rows based on color, the following dialog appears that gives you options to show or hide cells based on background color and/or font color:
If you want to display just the yellow cells (without sorting) in the previous data example, the following is the result:
To redisplay the hidden rows, just use the third option on the main dialog, which redisplays hidden rows.
|
|
| Copyright 2009 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |