Sorting Calc Sheet in Alphabet orde on names in one Column

users
#1

I have a calc spreadsheet with many lines of data which include one column with names for the line.
I want to sort the names from A to Z, top to bottom, and have all the corresponding data in each line move with the corresponding name. Hope this is clear.
Is this possible?

#2

ajebay wrote:

> I have a calc spreadsheet with many lines of data which include one
> column with names for the line.
> I want to sort the names from A to Z, top to bottom, and have all the
> corresponding data in each line move with the corresponding name. Hope
> this is clear.
> Is this possible?

Yes.

Select all the data, i.e. all rows and all columns.
Then use Data > Sort, and select the column of the names as the sort column. Now all the SELECTED data will be sorted with the names.
If you would exclude certain columns or rows from the selection they would not move with the sorting but stay where they are.

#3

Yes. You must first select all the cells you want to sort. You can easily do this by clicking the little square above the row numbers and left of the column letters. This will select the entire sheet. Next from the top heading bar at the very top select DATA then from the drop-down context menu select SORT. Then select the sort critera (in your case the columns that have the names in it. Also mark if you want the sort ascending or descending (you want ascending). If you want a secondary sort you can input the criteria also. Finally click the OK button at the bottom.

Blessings, Joe Conner, Poulsbo, WA USA

#4

You can click any single cell in the column you want to sort and click
one of the sort buttons [A-Z], [Z-A]. This will sort the area of
adjacent used cells.
Alternatively you can select the whole range and call the Data>Sort dialog.
And you can click a single cell and call the sort dialog which will
select the area of adjacent used cells as well.
Only one thing does not work: You must not select any part of a table
because this sorts the selected part. Spreadsheets do not have any
concept of tables. A table in a spreadsheet is what you treat as a table.

#5

I see you've already gotten several helpful replies. Couldn't resist adding
my 2ยข. It gives me a chance to share a video I did several years ago to
answer the very same question for my Uncle.

https://youtu.be/RjTgDyNqqQY?list=PLGCG5NYY1-dqMgUQ5E1kAITPfqlHmPJP1

Apologies for the monotone. Riveting narration is not my forte.

-Alan

#6

Hi to all who have answered and many thanks, I have it now. Brilliant.
Sorry to have been dense.
Thanks again,
Budge