Search code examples
excelsortingalphabetical

How to sort an excel list into Alphabetical List with alphabet as header

I have an excel table list (staff list).

I want to sort it alphabetically with the letter at the top. (refer to example pic attached)

List example

May I know if there a quick method to do this?

Thank you in advance

Solution

  • I suppose you are looking for a simple manual way of doing it for one time.

    Initial data looks like this:

    enter image description here

    Just after finishing the list, add all letters (from A to Z) to the bottom as shown below.

    enter image description here

    After this step, choose sort with below setting: enter image description here

    The outcome of sort will look as below, apply formatting per your needs. i.e. Red colored cells are for inserting the blanks as shown in your image and yellow ones shall be retained as header!

    enter image description here

    This is the easiest manual method I'm aware of.