Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?

if anyone has used a list of names in an excel spreadsheet does anyone know
how to alphabetise the names in the spreadsheet?
  #2   Report Post  
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by sera[_2_] View Post
if anyone has used a list of names in an excel spreadsheet does anyone know
how to alphabetise the names in the spreadsheet?


You can sort the names based on either first name or last name by using, Data-sort-Sort on A- Z or Z-A

Please let me know how many columns you have, how you want them to be sorted?

Thanks
Bala
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO i ALPHABETIZE A LIST OF SCHOOL (NOT NAMES) IN EXCEL GERRIREN New Users to Excel 2 April 16th 09 07:26 PM
Using Excell, how do you alphabetize the completed list? Kimo New Users to Excel 1 April 7th 08 09:35 PM
Look up Webpage addresses from a List of company names in Excell? jth Excel Worksheet Functions 2 May 30th 06 01:33 AM
Can excel alphabetize a list of names? Mary P. Excel Worksheet Functions 1 April 25th 06 04:30 AM
Excel Spreadsheet from Access. List of names changes as names are Gordy w/Hi Expectations Excel Discussion (Misc queries) 1 October 21st 05 03:30 AM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"