Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just wanted to find out if there was a way to sort a range of data in Excel
by the highlighted background. Problem: I have a range of data... some of the data the rows are highlighted. I need to be able to do a sort or a filter so that Excel will only show me the highlighted cells. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
you can look at Chip Pearson's page... http://www.cpearson.com/excel/SortByColor.htm Regards, Nika Lampe " wrote: Just wanted to find out if there was a way to sort a range of data in Excel by the highlighted background. Problem: I have a range of data... some of the data the rows are highlighted. I need to be able to do a sort or a filter so that Excel will only show me the highlighted cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Reduced Sorting Capability In Excel Worksheets | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) |