Here youāll learn with very simple steps to how sorting data alphabetically in Excel, youāre in the right place!Weāll be talking about a function which you can use to sort a list of employeesā names,products, or any other list you need.Ready to start?
weāre here to make sure you, will be able to use Excel in a quick and easy way,
Sorting data alphabetically, whether A to Z or vice versa, Z to A, can be comfortably done in a table of any size.Weāll have a look at how to do it using this prepared table.Before we start, letās just discuss two types of difficulties you can encounter while sorting.To avoid the first one,make sure that there are no blank entries or rows in the list before using the sorting function.Blank entries can easily happen if youāve imported data from other applications.
Now, imagine that we delete the data in row 10.In that case, Excel would work only with rows 2 to 9 and data stored below the row 10 would get ignored and wouldnāt get sorted alphabetically. Therefore, if a table youāre working with contains any blank entries,delete these rows and only then carry on with sorting.If the table youāre working with is extremely large,use the little trick we shared in the video tutorial on how to remove blank rows in Excel. Weāll undo the last step to make sure all rows in the table are filled with data, and weāll move on. The second problem you may encounter is tied to the table headers. If you include headers in a table you prepared, itās important that you distinguish it from the rest of the data.Because if you donāt,Excel will include the text of the header in the sorting as one of the list items, and thatās not what we want.It might be a good idea to use different colours or formatting to make the header of the table distinct and prevent this kind of issue. Now, letās assume youāve done what was needed ā the header has been formatted in a way thatās different from the rest of the data, and there are no blank entries in the table.You can move on to sort the data alphabetically. Itās very simple and easy.
First, click on the header of the column which contains the list of data you want to sort.Weāll click on cell B2, because we need to sort the names of employees.Then weāll click on āDataā tab, section āSort & Filterā for two quick options to sort data ā A to Zor the other way round, Z to A. Here weāll go for the first one ā A to Z. Done!The names of employees have been sorted alphabetically, A to Z, just as we wanted.You can use the very same function to easily sort also numbers from lowest to highest or vice versa.But now if we want to swap and sort the names Z to A, we can simply click on the button āSort Z to Aāand the list gets sorted the way we need.This function works with any number of data entries in tables of any size.
If youāre interested in learning more about a simple way of how to filter data,
Learn how to use Excel in a quick and easy way! Add to your Home screen and allow the Notifications.
Comments
Post a Comment
Share with your friends :)
Thank you for your valuable comment