View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default The last two entries in a range won't sort

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!!!