View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?