Ask Your Question
1

I want to alphabetize one of the columns in a spreadsheet

asked 2018-03-10 21:31:11 +0100

Gizkok gravatar image

how do I alphabetize one column and still keep the accompanying columns?

edit retag flag offensive close merge delete

Comments

"keep" means that they should not be changed at all? An example would help. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-03-11 06:51:58 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-03-10 21:42:44 +0100

floris v gravatar image

You have to select all the columns that belong together, then select Data - Sort, in the dialog window you then select what column to sort by, you can select a second and third column as well, then the rows will be sorted by those criteria.

edit flag offensive delete link more
1

answered 2018-03-11 06:50:31 +0100

Jim K gravatar image

Say we have this data.

a   a   a
b   b   b
c   c   c
d   d   d
e   e   e

To produce this result:

a   e   a
b   d   b
c   c   c
d   b   d
e   a   e

...select column B, go to Data -> Sort and choose Current Selection. Then specify to sort Descending.

sort range

If, however, you want this result instead:

e   e   e
d   d   d
c   c   c
b   b   b
a   a   a

...then select all three columns, as described in @floris v's answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-10 21:31:11 +0100

Seen: 48 times

Last updated: Mar 11 '18