Prev: Print Preview in 2007
Next: Conditional Formatting based on Non Blank Cells
From: bc on 11 Feb 2010 17:47
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!
From: Gord Dibben on 11 Feb 2010 19:37
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 <bc(a)discussions.microsoft.com> 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!

From: bman on 12 Feb 2010 01:36
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!
 | 
Pages: 1
Prev: Print Preview in 2007
Next: Conditional Formatting based on Non Blank Cells