ONE ROW WON'T SORT
 

I am trying to sort an Excel spreadsheet alphabetically. All but one row will
sort correctly. I have deleted the row and retyped the info, checked to make
sure the properties are the same as the other rows and there is not a space.
Any idea what is going on?

ONE ROW WON'T SORT
 

Is the data text strings?

Where is the bad cell located?

If in top row perhaps you have "my column has headers" checkmarked?


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 13:56:01 -0700, Kimmy T <Kimmy
wrote:

I am trying to sort an Excel spreadsheet alphabetically. All but one row will
sort correctly. I have deleted the row and retyped the info, checked to make
sure the properties are the same as the other rows and there is not a space.
Any idea what is going on?

ONE ROW WON'T SORT
 

I was trying to sort a list of cooler manufacturers alphabetically, the name
in the cell that wouldn't sort was True. After posting this question and
talking to several other people, I changed the name in that cell to True Mfg,
now it sorts correctly. I guess it has to do with the "logical sort order"
where FALSE will be sorted before TRUE (per Excel help). I made up a new
spread sheet of words including true & false, true always ended up at the
bottom of the list and both words would change to caps. Thank you for taking
the time to respond to my post.
--
Kimmy T


"Gord Dibben" wrote:

Is the data text strings?

Where is the bad cell located?

If in top row perhaps you have "my column has headers" checkmarked?


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 13:56:01 -0700, Kimmy T <Kimmy
wrote:

I am trying to sort an Excel spreadsheet alphabetically. All but one row will
sort correctly. I have deleted the row and retyped the info, checked to make
sure the properties are the same as the other rows and there is not a space.
Any idea what is going on?

ONE ROW WON'T SORT
 

You could enter an apostrophe before entering True then XL will treat it as
text not a Boolean

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Kimmy T" wrote in message
...
I was trying to sort a list of cooler manufacturers alphabetically, the
name
in the cell that wouldn't sort was True. After posting this question and
talking to several other people, I changed the name in that cell to True
Mfg,
now it sorts correctly. I guess it has to do with the "logical sort order"
where FALSE will be sorted before TRUE (per Excel help). I made up a new
spread sheet of words including true & false, true always ended up at the
bottom of the list and both words would change to caps. Thank you for
taking
the time to respond to my post.
--
Kimmy T


"Gord Dibben" wrote:

Is the data text strings?

Where is the bad cell located?

If in top row perhaps you have "my column has headers" checkmarked?


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 13:56:01 -0700, Kimmy T <Kimmy

wrote:

I am trying to sort an Excel spreadsheet alphabetically. All but one row
will
sort correctly. I have deleted the row and retyped the info, checked to
make
sure the properties are the same as the other rows and there is not a
space.
Any idea what is going on?

ONE ROW WON'T SORT
 

Thanks for posting back with the resolution.


Gord

On Wed, 4 Jun 2008 12:43:02 -0700, Kimmy T
wrote:

I was trying to sort a list of cooler manufacturers alphabetically, the name
in the cell that wouldn't sort was True. After posting this question and
talking to several other people, I changed the name in that cell to True Mfg,
now it sorts correctly. I guess it has to do with the "logical sort order"
where FALSE will be sorted before TRUE (per Excel help). I made up a new
spread sheet of words including true & false, true always ended up at the
bottom of the list and both words would change to caps. Thank you for taking
the time to respond to my post.