I want to alphabetize one of the columns in a spreadsheet
how do I alphabetize one column and still keep the accompanying columns?
First time here? Check out the FAQ!
how do I alphabetize one column and still keep the accompanying columns?
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.
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.
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.
Asked: 2018-03-10 21:31:11 +0100
Seen: 48 times
Last updated: Mar 11 '18
How do you add bullets to an already number-bulleted group of statements? [closed]
Can I use Microsoft Publisher files with LibreOffice? [closed]
Alternating table column numbering, Col1 Numbers, Col2 Letters? [closed]
Are there any plans to improve image handling? [closed]
LibreOffice 3.5 Writer crashes when making PDF [closed]
How can I center the document in a Writer window? [closed]
How to change datasource in form letter / mail merge imported from MS-Word [closed]
Draft Layout option for Writer (aka Normal View) [closed]
Spell check breaks between Windows and Linux LO installs [closed]
"keep" means that they should not be changed at all? An example would help. See guidelines for asking.