arranging in alphabatical order in Excel?

Question

heya, this will be, for now, my last Q on excel.

after typing about 1,200 staffs name in excel. suddenly my supervisor says that she want it in alphabatical order by their last names. all the names are type in columns B...

i noe its sumthing to do wif "functions" but cant figure it out how?

thanks to all of u for the help, but then not all the columns are in the same size...hw do I do it.?

Answer 1

Highlight the whole table.

Click Data, Sort

Sort by Colomn B - Ascending

Answer 2

Hi,

Make sure all the employee names contain first name and last name. For eg, if the employee name stored as "Bill Gates" in a single cell,

1. Open Excel.
2. Select the Column which contains the name list.
3. Select "Data -> Text to Columns"
4. Select "Delimited" radio button.
5. Click "Next"
6. Make sure only the "Space" checkbox is selected. (Note: If you have stored the employee name as "Bill, Gates", then we should turn on the "Comma" checkbox.)
7. Click "Next"
8. Click "Finish"
9. Now the name is split into two columns.
10. Now select both the column containing First Name and Last Name, use the Sort option in the Data Menu.

Hope this works fine. :)

Thanks,
Selva.

Answer 3

Easy.

Highlight the whole spreadsheet and in the menu (not sure which pull down) there is a little AZ. Click on that and it will ask you which column you want to organise by.

Better still ask the office assistant in Excel. It will show you.

Answer 4

just highlight the column and press the az button on the toolbar.

Answer 5

I don't know but I trust you will tell us once you find out.