How to Sort Excel 2010 by Alphabetical Order

Показать описание

This tutorial will show you how to sort a list into alphabetical order in Excel

In this tutorial you are going to learn how to sort excel by alphabetical order.

Step # 1 -- Selecting the Data to Sort

Start Excel and open the sheet with the data that you want to sort alphabetically. Here we have an address list and we want to sort the data by "Last Name". To do this you need to start by selecting the entire column, click on the "B" letter in the bar above the first row.

Step # 2 -- Opening the Sort Window

Now the data has been selected navigate to the "Data" tab in the main menu bar. In the "Sort & Filter" section you will see a large icon with "Sort" written underneath it, click this. A window will appear called "Sort Warning", select the "Expand this selection" option and click "Sort...".

Step # 3 -- Sorting the Data

The "Sort" window will load and there are several drop down boxes available. As a default the sort window will want to sort the data by alphabetical order (A-Z). If you want to have it reversed you can select the "Z-A" option from the "Order" drop down list. Finally click "OK". You will be returned to the spreadsheet and that is how to sort excel by alphabetical order.

Рекомендации по теме

Комментарии

*CONTEST IS VALID TILL DECEMBER 22, 2019*

howtechoffice

❗ Subscribe To Our Main YouTube Channel

howtechoffice

Hey everyone If you want to change the entire rows into alphabetical order, you just highlight everything, then under the data tab there is a blue A on top of a red B with a down arrow. Just click on that with everything selected and it should be in alphabetical order with the rows moved with them. Hope this helps!

CarolynRosefolksnaturalliving

Not often do you find instructions that are as simple and clear as yours! Thank you very much!

geronimodk

Precise, quick, dynamic and spot on - if only all of you tube was as good as this

veryveryvonfused

Thanks. Worked a treat. So simple. Moved all columns too. Thanks.

silby

Thank you for your clear and concise tutorial. FINALLY, I will be able to get excel to do what I want it to do!

sally

Be blessed content creator, you are a life saver

fenekaduguda

Oh man, this saved me a lot of time!! Thank you much!

aspegel

i will give "like" just for the accent ;)

gnbwtxu

I had to untick "my data has header" and choose the Column I wanted to sort by - maybe it's in the updated version. But thank you for the short and simple video with no waffling. ;)

alinabelousova