How to Sort Excel 2010 by Alphabetical Order

Excel, Word and PowerPoint Tutorials from Howtech

1 десятилетие назад

1,009,676 Просмотров

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

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - 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.

Тэги:

#data #order #alphabetical #sort_excel_alphabetical_order #excel_data_order #alphabetical_order_excel #data_sorting #data_sorting_options #excel #excel_tutorial #excel_2010_tutorial #excel_formulas #excel_2007 #microsoft_excel #excel_2010 #excel_basics #excel_tutorials #learn_excel #excel_for_beginners #excel_tricks #excel_tutorial_2010 #excell #exel #microsoft_excel_2010 #using_excel #office_2010 #how_to_excel #guide #education #manual #tutorial #video #tutorials #howto #how_to #howtech

Скачать видео

Комментарии:

@StllaJob-mq1yi - 24.10.2023 02:35

What if they are in same cell

Ответить

@romasimirov4797 - 13.10.2023 09:41

Amazing explanation

Ответить

@ethiojabez9428 - 15.08.2023 00:57

Thank you for your video it is helpful👍👍👍

Ответить

@claudiajones879 - 08.08.2023 20:03

life saver

Ответить

@saitamassj2475 - 30.06.2023 09:21

Can we make a sorting tab? click the tab in the sheet like on a website?

Ответить

@mohdyaseen4531 - 24.06.2023 13:27

Thanks

Ответить

@tishalove3367 - 15.06.2023 00:50

Thank you 😊

Ответить

@Dev1nci - 07.06.2023 10:03

HAHAHAH wow this guy is using AI's to generate his narration. This one is 'Today I Learned', another is 'Engineering Explained'..

Ответить

@user-lj6jl5qc5x - 01.06.2023 16:51

Ευχαριστω μαναρι μου

Ответить

@PhilipLondon-tb1qy - 10.05.2023 14:08

Thanks ❤

Ответить

@angelbaby373 - 01.05.2023 05:49

Good job 😊👍

Ответить

@alma.702 - 07.04.2023 23:41

How do I start making my list here? What tab or where in excel do I go to create this?

Ответить

@thelthrythquezada8397 - 04.04.2023 18:15

YUP DID THE TRICK, THANKS MATE

Ответить

@Pulang_Diwa - 27.02.2023 13:07

Is Simon Whistler from Biographics doing Excel tutorial videos now? jk.

Ответить

@yasminmitha374 - 14.02.2023 08:53

Thank-you so much

Ответить

@techindiacg1400 - 31.01.2023 09:24

LOT OF LOVE THANKYOU

Ответить

@veryveryvonfused - 21.01.2023 01:02

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

Ответить

@gregoriasimon5678 - 09.01.2023 04:20

thanks

Ответить

@BoneAppleTea - 30.12.2022 18:44

short and good, upvoted

Ответить

@fenekaduguda - 23.12.2022 18:31

Be blessed content creator, you are a life saver

Ответить

@shiro5410 - 11.12.2022 09:15

thanks quick and fast I love it

Ответить

@irfanhaziq720 - 10.11.2022 15:13

It helps me a lot

Ответить

@felixosile - 18.08.2022 17:23

Thank you make job easy

Ответить

@easy2lose109 - 16.03.2022 12:32

But then the whole data is wrong it only did the surnames what about first name to match

Ответить

@rjb073 - 01.01.2022 11:06

Big help. Saved a lot of time. Thanks.

Ответить

@anjalibiswas6673 - 14.12.2021 09:49

Thank you

Ответить

@alinabelousova - 08.06.2021 21:00

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. ;)

Ответить

@functionalmeals1262 - 03.06.2021 05:05

Clear, short and simple. Thank u!

Ответить

@galanbecquet3734 - 04.12.2020 05:35

Thank you , and nice job

Ответить

@theproofreader3204 - 10.09.2020 07:31

Thanks, fast & smooth. This really helps.

Ответить

@vanadium302 - 22.04.2020 07:41

i have 5000 words which i want to sort by alpabatic order. but i want to sort by 3rd latter of every word(examples : apple, karrot, kangaroo in which i want to sort by 3 rd word =kangaroo apple karrot.) but this not directly occurre in Microsoft Office (Microsoft Office only sort by 1st word) can you help me or give any software suggestions!

Ответить