| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with sorting
I have an excel spreasheet that I am trying to sort. Some rows are
highlighted, some are not. When I select the rows I want to sort, my highlights end up in some of the rows that were not previously highlighted and some of the non-highlighted rows end up with highlights. It is not consistent. It ends up with a portion of a row highlighted and all scrambled. Anyone know what i need to do? Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with sorting
How are the rows highlighted?
Manually or by Conditional Formatting? Is there any pattern to the highlighting? Gord Dibben MS Excel MVP On Thu, 11 Feb 2010 14:47:01 -0800, bc wrote: I have an excel spreasheet that I am trying to sort. Some rows are highlighted, some are not. When I select the rows I want to sort, my highlights end up in some of the rows that were not previously highlighted and some of the non-highlighted rows end up with highlights. It is not consistent. It ends up with a portion of a row highlighted and all scrambled. Anyone know what i need to do? Please help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with sorting
Have some of the cells been merged, and others not?
"bc" wrote: I have an excel spreasheet that I am trying to sort. Some rows are highlighted, some are not. When I select the rows I want to sort, my highlights end up in some of the rows that were not previously highlighted and some of the non-highlighted rows end up with highlights. It is not consistent. It ends up with a portion of a row highlighted and all scrambled. Anyone know what i need to do? Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| How can I keep more than one row from sorting | Excel Discussion (Misc queries) | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Linear Mode
