To avoid this, you should leave the default Expand the selection option and eventually press sort. This is especially the case when you have selected some cells in the middle of the book. However, there are some situations that Excel doesn't know which part of the data to sort and which to leave. After this, Excel will move the data in all the other columns and at the same time keep the rows intact. After this, you will just have to put one of the columns in ascending or descending order. Yes, this is also simple especially if your data set has more than two columns. The first screenshot shows the results in ascending order while the other shows the results in descending order.Ĭan you do the same and still keep the rows together? It doesn't matter the method you use because either way, this MS application will sort your list alphabetically. The other method of accessing this tab is to visit the Home tab>Editing group> sort and filter. If you want to sort in descending order, then you should choose Z-A as shown in the picture below. Now move to the sort and filler group and choose A-Z in the Data tab when you want to sort in ascending order. Start by selecting any cell in the column you have chosen to sort. I bet this is the easiest especially if you are starting on this. There are some ways of doing this but the fastest of all ways is to follow the below steps. Problems with alphabetically sorting excel data.Can you do the same and still keep the rows together?.In Excel, there are about three ways of sorting alphabetically which include the sort feature, filter, and A-Z or Z-A methods. The worst situation is when the built-in features stumble and you are forced to figure out another way of doing that with formulas.
It doesn't matter whether you are sorting an entire worksheet, vertically or horizontally, or whether you are sorting them in ascending or descending order, you can accomplish this with the press of a button. Sorting alphabetically in excel is as simple as pronouncing your name.
#HOW TO SORT MULTIPLE COLUMNS IN EXCEL ALPHABETICALLY HOW TO#
We will also give a guide on how to alphabetize names when entries start with the last name rather than the first name. In this guide, in particular, we will cover ways to put excel in alphabetic order. This tutorial and many others to follow will teach you the basic functions of excel and how to perform some simple actions in excel. Excel is one of the most useful Microsoft Office applications and yet one of the most complicated to use especially for people with little knowledge about the same.
0 kommentar(er)
