[libreoffice-users] Re: Sorting Calc Sheet in Alphabet orde on names in one Column

Am 25.10.2015 um 21:48 schrieb ajebay:
> 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?

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.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted