Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Alphabetize list

I have a list where each line starts with a last name. How do I make the list alphabetical?

Thanks

MacBook Pro, Mac OS X (10.6.2)

Posted on Jan 16, 2010 3:04 PM

Reply
24 replies

Jan 16, 2010 5:59 PM in response to pglages

pglages,

I like Word Services too, but there is also a native way to sort. A bit of a pain but effective.

It goes like this:

Select the list.
Format > Table > Convert Text to Table.
Select the one of the table cells.
In the Tables Inspector, Edit Rows and Columns, Sort Ascending/Descending.
Select the Table
Format > Table > Convert Table to Text. Now you're back to your list, sorted.

Jerry

Jan 17, 2010 11:54 AM in response to pglages

Thanks guys. I haven't been able to figure out how to use WordServices. I copied it to username>library>services, restarted, selected the list in pages, then what??? Nothing seems to show to direct the sort.

I did use Jerry's suggested process, which worked, but left odd misplaced formatting.

Anyway, any further advice would be much appreciated.

Jan 17, 2010 12:11 PM in response to pglages

Using Services is a bit different in Snow Leopard. First you have to select the text 7 Object you want to do something with. Then go Services. If nothing is still in the list choose Services preferences. Select all functions you want the computer being able to use. Close the preferences. Try again. now you should see all applicable options.

Jan 26, 2010 2:54 AM in response to pglages

I am having a problem with sorting my data too... When I print my labels from my address book I can change the sorting order. But, when I use Pages I cannot change the order?? In other words I am only putting the first name on the letters (merge field) and because of the limited sorting selection I can't seem to get the same order from my address book and Pages merged letter. So I am spending a lot of time sorting after printing to match the letters to the labels. There has got to be a better way... Help!

Jan 26, 2010 12:06 PM in response to pglages

pglages wrote:
Thanks guys. I haven't been able to figure out how to use WordServices. I copied it to username>library>services, restarted, selected the list in pages, then what??? Nothing seems to show to direct the sort.

I did use Jerry's suggested process, which worked, but left odd misplaced formatting.

Anyway, any further advice would be much appreciated.


Select the text.

+Menu > Pages > Services > Format > Sort Lines Ascending/Descending+

If you are using OSX 10.6 you may also find the Services in your contextual menu (right mouse click on the selection).

Peter

Feb 9, 2010 7:46 PM in response to pglages

Friends,

As a normal part of academic reports, I sort large text blocks into separate lists.

I purchased iWorks to avoid the excesses of Word.

I have been unable to find an alphabetical sort function in Pages.

I have downloaded and followed instructions in regard to Devon's application to sort in Pages.
The applications fails to work.
I choose not to be at the mercy of a system that I am too dumb to activate.

Do I understand that Apple intends one to move data back and forth between Pages and Numbers to accomplish alphabetical sorting?
Is this an intended advantage of Pages + Numbers?
Is there an advantage to this that I fail to understand?

Should I revert to Word?
If so, why would I choose to work between Pages and Word to accomplish what Word can do alone?

I welcome suggestions.

MQPeterson

Feb 9, 2010 8:55 PM in response to iygUTFytd675E87tIUGuyf

Welcome to Apple Discussions

The very first reply to the original poster (OP) in this thread has a link to the free WordService by Devon Technologies. Installing this in the Services folder in either the main HD > Library or your home > Library & restarting Pages will give you access to alphabetical sorting & much more. If you are using Snow Leopard you need to go to System Preferences > Keyboard > Keyboard Shortcuts & enable the individual services.

User uploaded file

User uploaded file

Alphabetize list

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.