I have a list of items in an excel sheet. I sorted the items, and they sorted
fine. Then I added two items at the end of the list, but they won't sort
with the rest of the list. When I switch between ascending and descending,
the original items reverse order, but the two new entries just stay where
they were.

I've confirmed the items are all numbers, no characters.

Help!!!

Are there any empty rows between the top of the list and these 2 new entries?
Including hidden rows...

You can always force them to sort by highlighting the entire table of data
with aded rows and re-sorting...

"bibbis" wrote:

I have a list of items in an excel sheet. I sorted the items, and they sorted
fine. Then I added two items at the end of the list, but they won't sort
with the rest of the list. When I switch between ascending and descending,
the original items reverse order, but the two new entries just stay where
they were.

I've confirmed the items are all numbers, no characters.

Help!!!

How did you confirm the data to be numbers?

Simply formatting as number or general will not change the format if the
"numbers" are text.

I would add this formula in a helper column to double-check.

=ISNUMBER(cellref) do you get TRUE or FALSE?


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 12:55:01 -0800, bibbis
wrote:

I have a list of items in an excel sheet. I sorted the items, and they sorted
fine. Then I added two items at the end of the list, but they won't sort
with the rest of the list. When I switch between ascending and descending,
the original items reverse order, but the two new entries just stay where
they were.

I've confirmed the items are all numbers, no characters.

Help!!!