In OpenOffice Spreadsheet, how do I alphabetize last name and first name fields without scrambling addresses?

Asked by Kimberly Powell on 2012-04-06

I have a Client data base spreadsheet in Open Office with Last Name, First Name, address, email etc...how do I alphabetize names without scrambling the address data?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2012-04-06
Last reply:
2012-04-07
Tony Pursell (ajpursell) said : #1

Hi Kimberly

First of all, highlight all the data columns. Then do Data > Sort. You probably want to select the column with Last Name to sort first, then the column with First Name. Note that there is an Options tab. Have a look at this and check any that you need, such as if you have column headings in the first row or you want the sort to be case sensitive. Click on the Help button on the Sort window, if you need more explanation of what to do.

Tony

Can you help with this problem?

Provide an answer of your own, or ask Kimberly Powell for more information if necessary.

To post a message you must log in.