is there a limit to sorting??

[bill151515]

is it possible to sort all of columns A:AD with data going all the way down row 65000

i am trying to sort on columna then column ad but it seems towork until row 8500 and then stops???? is there a limit in excel to the # of dat fields that can be sorted?????

 

[TheNoocH]

make sure there aren't any blank rows....the sort function might only grab the first section....

best bet....highlight cols A:AD manually down to the last appropriate row....then start your sort....

see if that works for you

 

[bill151515]

blnk rows were ther
thanks