Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to alphabetize a list in Excel
I put my Christmas List of addresses in Excel. Is there a way to alphabetize
it? I am using Excel 2003 and Windows XP Home Edition. |
#2
|
|||
|
|||
DJ,
yes. You would sort it. Be careful, though. Check out www.smokeylake.com/excel. Go to "Excel truths" and read "Sorting in Excel." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "DJ Somers" <DJ wrote in message ... I put my Christmas List of addresses in Excel. Is there a way to alphabetize it? I am using Excel 2003 and Windows XP Home Edition. |
#3
|
|||
|
|||
Thanks, Earl. I will check out the site U referenced me to and see if it
helps. As U may guess, I am not very experienced with Excel and want to be careful to not lose the info I've already keyed in. DJ "DJ Somers" wrote: I put my Christmas List of addresses in Excel. Is there a way to alphabetize it? I am using Excel 2003 and Windows XP Home Edition. |
#4
|
|||
|
|||
DJ
First..make a backup of the workbook. Then.....create a copy of the worksheet and experiment on that copy. When you get it right, you can use those steps on the original worksheet and delete the copy. Then..........make a new backup of the workbook. The use of copies and backups is a good habit to develop, no matter what you are doing. Gord Dibben Excel MVP On Tue, 28 Dec 2004 09:19:05 -0800, DJ Somers wrote: Thanks, Earl. I will check out the site U referenced me to and see if it helps. As U may guess, I am not very experienced with Excel and want to be careful to not lose the info I've already keyed in. DJ "DJ Somers" wrote: I put my Christmas List of addresses in Excel. Is there a way to alphabetize it? I am using Excel 2003 and Windows XP Home Edition. |
#5
|
|||
|
|||
Earl, I was able to check out the info U suggested and I was able to
alphabetize my info in Excel. Thank U so much! Gord, thanks to U too. I did make a copy of the file to experiment with in case the "Sort" command didn't work the way I wanted it to. DJ "Gord Dibben" wrote: DJ First..make a backup of the workbook. Then.....create a copy of the worksheet and experiment on that copy. When you get it right, you can use those steps on the original worksheet and delete the copy. Then..........make a new backup of the workbook. The use of copies and backups is a good habit to develop, no matter what you are doing. Gord Dibben Excel MVP On Tue, 28 Dec 2004 09:19:05 -0800, DJ Somers wrote: Thanks, Earl. I will check out the site U referenced me to and see if it helps. As U may guess, I am not very experienced with Excel and want to be careful to not lose the info I've already keyed in. DJ "DJ Somers" wrote: I put my Christmas List of addresses in Excel. Is there a way to alphabetize it? I am using Excel 2003 and Windows XP Home Edition. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | New Users to Excel | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |