Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 13, 2008, 02:39 PM   #1
stenoboy
macrumors newbie
 
Join Date: Nov 2007
Alphabetizing a list in Pages

Does anyone know how to alphabetize a list in Pages? I can't find anything in the help menus or online. Each separate item on the list is a new line, so I don't know if it's a paragraph style I need?
stenoboy is offline   0 Reply With Quote
Old Mar 10, 2009, 05:22 AM   #2
liljo
macrumors newbie
 
Join Date: Mar 2009
How to alphabetize in pages!

If you wish to alphabetize a list in pages....

1. Make the list as below say it's names -

Sarah
Jane
Elizabeth
Ben
Patrick

2. Insert a table on the page

3. Highlight the list of names and drag them into a box in the table - they should automatically each end up in their own box.

4. Go to the 'edit tool bar' and click on the table logo at the top, bringing up all the table edit options.

5. Select only one box in the table ie. the one at the top of the list.
Go to "Edit Rows & Columns" there is a drop down menu. This menu will allow you to 'sort ascending' 'sort descending' etc. Select which you would like.

6. Once the contents of the table are in the order you want, move the text out of the table and get rid of the table.
liljo is offline   0 Reply With Quote
Old Mar 24, 2010, 12:59 PM   #3
starshipcommand
macrumors newbie
 
Join Date: Mar 2010
Have no luck moving out of the table, back to regular text

Quote:
Originally Posted by liljo View Post
If you wish to alphabetize a list in pages....

1. Make the list as below say it's names -

Sarah
Jane
Elizabeth
Ben
Patrick

2. Insert a table on the page

3. Highlight the list of names and drag them into a box in the table - they should automatically each end up in their own box.

4. Go to the 'edit tool bar' and click on the table logo at the top, bringing up all the table edit options.

5. Select only one box in the table ie. the one at the top of the list.
Go to "Edit Rows & Columns" there is a drop down menu. This menu will allow you to 'sort ascending' 'sort descending' etc. Select which you would like.

6. Once the contents of the table are in the order you want, move the text out of the table and get rid of the table.
I have no luck selecting the contents of a table and moving it back to regular text. I can't believe Apple makes no easy way to just write a grocery list and select all, sort asend or desend. So every time you want to add to a list, you have to move the list into and out of a table? I'm shocked. So once I have the list asended or desended, I have tried selecting the table, coping it and , but all I get is another table, not the raw contents of the boxes.
starshipcommand is offline   1 Reply With Quote
Old Mar 24, 2010, 07:55 PM   #4
mysterytramp
macrumors 65816
 
mysterytramp's Avatar
 
Join Date: Jul 2008
Location: Maryland
You also could do this, if you've run AppleScript utility and have the AS menu in the menu bar.

Open your script editor and paste this file:

Code:
tell application "Pages"
	-- not a perfect solution, but a near-perfect one
	-- code stolen liberally from: http://www.macosxhints.com/article.php?story=20040513173003941
	set blob to the selection of document 1
	
	set blobY to paragraphs of text of blob
	
	set TID to AppleScript's text item delimiters
	set AppleScript's text item delimiters to {ASCII character 10}
	set blobList to (blobY as string)
	
	set AppleScript's text item delimiters to TID
	
	set blobReplace to do shell script "echo " & quoted form of blobList & " | sort -f"
	set the selection of document 1 to blobReplace
	
end tell
The script should be saved in this folder: /Users/<user name>/Library/Scripts/Applications/Pages/

Now it will appear in the AppleScript menu, under "Pages Scripts"

mt
__________________
What looks large from a distance, close up ain't never that big.
mysterytramp is offline   0 Reply With Quote
Old Apr 1, 2010, 10:38 PM   #5
mysterytramp
macrumors 65816
 
mysterytramp's Avatar
 
Join Date: Jul 2008
Location: Maryland
Even better way ...

Open System Preferences
Open Keyboard
Select Keyboard Shortcuts tab
Select Services in left-hand pane
Scroll down to Text entry.

You'll see Sort Lines Ascending and Sort Lines Descending

mt
__________________
What looks large from a distance, close up ain't never that big.
mysterytramp is offline   0 Reply With Quote
Old Jun 26, 2010, 03:41 PM   #6
kelkat
macrumors newbie
 
Join Date: Aug 2006
Quote:
Originally Posted by mysterytramp View Post
Even better way ...

Open System Preferences
Open Keyboard
Select Keyboard Shortcuts tab
Select Services in left-hand pane
Scroll down to Text entry.

You'll see Sort Lines Ascending and Sort Lines Descending

mt
I must be really blind...... I don't see this option..... *shrug*
kelkat is offline   0 Reply With Quote
Old Jun 26, 2010, 04:36 PM   #7
snberk103
macrumors 603
 
Join Date: Oct 2007
Location: An Island in the Salish Sea
Quote:
Originally Posted by mysterytramp View Post
Even better way ...

Open System Preferences
Open Keyboard
Select Keyboard Shortcuts tab
Select Services in left-hand pane
Scroll down to Text entry.

You'll see Sort Lines Ascending and Sort Lines Descending

mt
Quote:
Originally Posted by kelkat View Post
I must be really blind...... I don't see this option..... *shrug*
Must be a Snow Leopard thing, I don't see it either. I'm at 10.5.8 ...

If I need an alphabetized list in Pages I do the Table Thing, but if I think I'll be needing to edit it, I keep the table but make all the lines invisible. Then you can add some rows and names, and re-sort whenever needed.
snberk103 is offline   0 Reply With Quote
Old Jun 26, 2010, 04:44 PM   #8
PeggyD
macrumors 6502a
 
Join Date: Jan 2007
Location: Covington/Lake Morton, WA, USA
Pages can only sort in a table. Install WordService from Devon Technologies to add sorting in the main text layer of a word processing document.
PeggyD is offline   0 Reply With Quote
Old Jun 26, 2010, 11:24 PM   #9
snberk103
macrumors 603
 
Join Date: Oct 2007
Location: An Island in the Salish Sea
Quote:
Originally Posted by PeggyD View Post
Pages can only sort in a table. Install WordService from Devon Technologies to add sorting in the main text layer of a word processing document.
Thanks PeggyD. Just tried it and it seems to work well. A couple of other interesting things have also been installed into the Services menu... looking forward to trying those too.

Thanks again.
snberk103 is offline   0 Reply With Quote
Old Jun 28, 2010, 04:50 AM   #10
mackiwilad
macrumors member
 
Join Date: Sep 2007
Location: Ask the Goverment!
Quote:
Originally Posted by liljo View Post
If you wish to alphabetize a list in pages....

1. Make the list as below say it's names -

Sarah
Jane
Elizabeth
Ben
Patrick

2. Insert a table on the page

3. Highlight the list of names and drag them into a box in the table - they should automatically each end up in their own box.

4. Go to the 'edit tool bar' and click on the table logo at the top, bringing up all the table edit options.

5. Select only one box in the table ie. the one at the top of the list.
Go to "Edit Rows & Columns" there is a drop down menu. This menu will allow you to 'sort ascending' 'sort descending' etc. Select which you would like.

6. Once the contents of the table are in the order you want, move the text out of the table and get rid of the table.
Works in Numbers too... Sort Ascending is magic!
__________________
ICQ: notinkansas
Steam: greenfriar
GameCentre: Krus
mackiwilad is offline   0 Reply With Quote
Old Oct 26, 2010, 11:13 AM   #11
bisento
macrumors newbie
 
Join Date: Oct 2010
Quote:
Originally Posted by mysterytramp View Post
You also could do this, if you've run AppleScript utility and have the AS menu in the menu bar.

Open your script editor and paste this file:

Code:
tell application "Pages"
	-- not a perfect solution, but a near-perfect one
	-- code stolen liberally from: http://www.macosxhints.com/article.php?story=20040513173003941
	set blob to the selection of document 1
	
	set blobY to paragraphs of text of blob
	
	set TID to AppleScript's text item delimiters
	set AppleScript's text item delimiters to {ASCII character 10}
	set blobList to (blobY as string)
	
	set AppleScript's text item delimiters to TID
	
	set blobReplace to do shell script "echo " & quoted form of blobList & " | sort -f"
	set the selection of document 1 to blobReplace
	
end tell
The script should be saved in this folder: /Users/<user name>/Library/Scripts/Applications/Pages/

Now it will appear in the AppleScript menu, under "Pages Scripts"

mt

This script worked very well to sort the text, but the problem, as with WordServices, is that it doesn't keep any of the formatting, which is frustrating for a long bibliography in which certain things need to be italicised. I confess I know nothing about writing scripts, but is it possible in anyway to make it sort and keep those style features?
bisento is offline   0 Reply With Quote
Old Nov 13, 2010, 02:34 PM   #12
SVHarmony
macrumors newbie
 
Join Date: Aug 2010
Location: Pacific Northwest
I think I have it...

Needing to find a way to alphabetize a list I had made in Pages, I first, of coarse, looked here in MacForums. Not finding what I wanted I proceeded to alphabetize the list the old fashion way. After I finished I decided I needed another column and clicked on the top of one of the columns. I'm not sure what this is called ... it was labeled according to each row: A,B, and C. (I only had the three columns to start with) Upon right clicking 'C' I saw that sure enough it gave me options of "sort ascending, sort descending". I could have clicked any of the rows and it would have given me the option of "sort ascending, sort descending". I hope I understood the question correctly.
Hope this helps someone else.
Now I hope I can remember this when I need it once again *wink.

Last edited by SVHarmony; Nov 13, 2010 at 02:42 PM.
SVHarmony is offline   0 Reply With Quote
Old Jan 5, 2011, 08:00 AM   #13
fazarelli
macrumors newbie
 
Join Date: Jan 2010
Location: London
Installing WordService from Devon Technologies solved problem for me :)

Installing WordService from Devon Technologies solved this problem for me, had been bugging me for a while as I have just stopped using Word.

If you install after reading the 'read me' file first which tells you how to install and then follow these steps below it is easy to add a sort ascending, sort descending service to pages:

1. Open System Preferences
2. Open Keyboard
3. Select Keyboard Shortcuts tab
4. Select Services in left-hand pane
5. Scroll down to Text entry
6. You'll see Sort Lines Ascending and Sort Lines Descending - Tick boxes
7. DONE
fazarelli is offline   0 Reply With Quote
Old Sep 28, 2011, 09:48 AM   #14
sakuranharuka
macrumors newbie
 
Join Date: Sep 2011
The Easy Way (I guess...)

>highlight text/list
>Format>Table>Convert Text to Table
>Inspector>Table Tab>Edit Rows and Columns>Sort Ascending/Descending
>Format>Table> Convert Table to Text

Hope it helps!
sakuranharuka is offline   1 Reply With Quote
Old Jan 25, 2012, 10:51 AM   #15
rgenie
macrumors newbie
 
Join Date: Jan 2012
helpful site

A favorite site of mine for various list sorting and list refinements is

http://sortmylist.com/

I just used it to sort my Pages list using cut and paste.
rgenie is offline   0 Reply With Quote
Old Jan 2, 2013, 09:46 PM   #16
docks
macrumors newbie
 
Join Date: Jan 2013
Location: Australia
Quote:
Originally Posted by sakuranharuka View Post
>highlight text/list
>Format>Table>Convert Text to Table
>Inspector>Table Tab>Edit Rows and Columns>Sort Ascending/Descending
>Format>Table> Convert Table to Text

Hope it helps!
Thanks so much, so simple once you explained it
docks is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Pages 5: A List of What's Missing, Added, & Changed Jodeo Mac Applications and Mac App Store 81 Apr 29, 2014 12:48 PM
Pages bullets and list error noong Mac Applications and Mac App Store 0 Jan 20, 2014 11:52 PM
How To: Multilevel List in iOS Pages Solved! Traverse iPad Apps 0 Mar 11, 2013 07:56 PM
alphabetizing address book bjames MacBook 0 Dec 13, 2012 04:11 AM
Any idea why Reading List will not save pages on iPod Touch G5? caribou123 iOS 6 1 Oct 4, 2012 03:46 PM

Forum Jump

All times are GMT -5. The time now is 07:16 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC