Unclear. Suppose you have in A1:A3 the text "apple", "banana", "cherry"
after sorting
Now starting in A4 you add some more. Let's say At A7 you add "avocado"
When next you sort, do you want this to follow "apple" or "cherry"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengmeremove caps from email
"suzie" <su...@discussions.microsoft.com> wrote in message
news:F330BC35-1E42-459A...@microsoft.com...