How To Sort Alphabetically In Excel

How To Sort Alphabetically In Excel

In this quick tech how to video, I’m going to show you how to sort cells alphabetically inside of Microsoft Excel. I’ll also show you how to sort so that all of the corresponding columns adjust as well. For instance, first name, last name, address, etc.

We’ll start by looking at a list of contacts with addresses. They’re completely random now, but we want to sort by our first column which is last names.

Select the first cell, and then drag down to the last cell that contains data.

Next, make sure you’re inside of the Home menu, and on the right choose the dropdown next to Sort and Filter.

From this list, choose sort a to z. If you have only one column, it will automatically sort right away. But if we have more than one column like first names here, it will give you a sort warning. Choosing Expand the Selection will then sort the other column along with the first column. So, first names will stay with our last names. If you choose continue with the current selection, it will break our data apart.

When you’re ready, hit sort, and your data and columns will all sort alphabetically.

And that’s how you sort cells alphabetically inside of Microsoft Excel.

Thanks for watching! Please like and subscribe and stay tuned for more quick tech how-to videos.

#excel #microsoftoffice #excelsortcells #quicktechvideo #howto #tutorial

[QuickTechVideos]

Thanks for watching! Don't forget to give it a thumbs up if you find this video useful. Let us know if you have any questions, and subscribe to be notified of the latest Quick Tech tutorials.