[Solved] Alphabetizing several rows

Discuss the spreadsheet application

[Solved] Alphabetizing several rows

Postby dmunnee » Wed Oct 06, 2010 3:56 pm

I have to keep a list of names, dates and comments for work, but when I try to alphabetize them by highlighting everything to keep the name with the date/comment, it only works on the last column of comments. Am I doing something wrong?
Last edited by Hagar Delest on Thu Oct 07, 2010 3:50 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.1 on Windows 7
dmunnee
 
Posts: 2
Joined: Wed Oct 06, 2010 3:54 pm

Re: alphabetizing several rows

Postby acknak » Wed Oct 06, 2010 4:36 pm

The toolbar sort buttons sort the data according to the values in the same column as the current cell--the cell with the black border. When you select cells from left to right, the current cell ends up in the rightmost column, and Calc sorts according to that.

So, to avoid that, you can select the cells from right to left, leaving the current cell in the leftmost column, or, if your data are in a neat, rectangular table with no gaps, you can click in any cell of the table, without selecting any other cells, and click the sort button. In this situation, Calc will automatically locate all the data and sort it by the column with the current cell.

This is fine for the occasional quick sort, but for a sorting operation you need to repeat, the best approach uses another step: select the cells with the data, then do Data > Define Range. Give it a name, check the options, and OK. Now, Calc will remember the data range and all the sort options and criteria. Anytime you click one of the sort buttons on the toolbar, Calc will repeat the ordering configured for that area of the sheet.
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17398
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Alphabetizing several rows

Postby dmunnee » Thu Oct 07, 2010 2:32 pm

worked, tyvm.
OpenOffice 3.1 on Windows 7
dmunnee
 
Posts: 2
Joined: Wed Oct 06, 2010 3:54 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests