Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Excel cannot sort by color, however my Excel add-in
"Special Sort" - rel 1.31, should do what you want. It adds 11 sort features not found in Excel, including sorting by.. Prefix, Suffix or Middle (where you specify the length/position). Will also sort by color, dates, number group, length, reverse, random and others. Comes with a 2 page install/use Word file. It is available - free - upon direct request. Remove XXX from my email address. Regards, Jim Cone San Francisco, USA XX "Fashionheadhunter" wrote in message I have a spreadsheet with data in about 1,000 cells. I occasionally highlight cells by adding yellow color fill to make them standout. I would like to sort the data so that I could move the "highlighted" cells to the top of the sheet. Can this be done? If not, can you suggest a way to accomplish this in the future--ie., use a different font, boldface, etc. that would allow me to sort easily? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Can you sort Excel data by font color? | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |