This tutorial will show you how to sort a list into alphabetical order in Excel
Don't forget to check out our site [ Ссылка ] for more free how-to videos!
[ Ссылка ] - our feed
[ Ссылка ] - join us on facebook
[ Ссылка ] - our group in Google+
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.
How to Sort Excel 2010 by Alphabetical Order
Теги
dataorderalphabeticalsort excel alphabetical orderexcel data orderalphabetical order exceldata sortingdata sorting optionsexcelexcel tutorialexcel 2010 tutorialexcel formulasexcel 2007microsoft excelexcel 2010excel basicsexcel tutorialslearn excelexcel for beginnersexcel tricksexcel tutorial 2010excellexelmicrosoft excel 2010using exceloffice 2010how to excelguideeducationmanualtutorialvideotutorialshowtohow tohowtech