Calc - Sorting - Alphabetically

users
#1

Hi Folks,

I have all my data in Column A.

I wish to sort alphabetically.

I highlight all the data in every cell in column A, choose Data>Sort
but in the criteria I don't see anything for alphabetically,

How does one sort alphabetically?

Thank you!

#2

Charles,

What kind of data is in that column? I have a list of names in one column of a sheet. I never bothered to format this to text. When I sorted, it automatically arranged the column in alphabetic order.

hth

Cheers

#3

If you choose an ascending sort then it will sort A to Z; descending will sort Z to A. I believe that as long as there is one non-numeric cell then it will sort based on characters rather than values, but someone else should confirm that.

Dave Liesse

#4

Using Data | Sort...! You don't need to make this selection anywhere: if your data is text, the sort will be alphabetic; if the data is numbers, the sort will be numeric. The only exceptions to this are if you have set other choices at "Custom sort order" or "Language/Options" on the Options tab of the Sort dialogue.

I trust this helps.

Brian Barker