Is There A Way To Alphabetize In Excel And Keep Rows Together

I empathise using excel can exist a daunting task, particularly to newbies. The good thing is that in that location are many online resources to help you maneuver every corner of MS Excel. Today, we are going to discuss on how to sort alphabetically without interfering with the rows.

This can be very challenging especially if y'all have multiple columns in a single worksheet. So, in that case, how do y'all sort a column and ensure the rows are intact?

At that place are many ways to go nearly this but the best and the simplest of all is the use of sort function in Excel. But now how practise you discover the sort function to sort the columns and maintain the rows?

Full general sorting

If y'all accept the latest Excel version, I am sure you already found the full general sorting characteristic that helps you to sort information on colors, prison cell icons, and prison cell contents. In this case, you are supposed to click on whatsoever prison cell that y'all want to sort and what follows is to click on the Data tab. However, make sure yous accept non highlighted the data considering it will sort that column only and the rest of the data volition be left unattended. After this, y'all are supposed to click on the sort ascending or descending push and everything will be washed according to your wish.

That sounds like shooting fish in a barrel and unproblematic but the fact remains that performing multi-level sorting is a little bit challenging. This is the reason why the majority of people choose advanced methods of doing that. Below, we have discussed other methods that can help you sort data, and then read on.

Using the sort Function

Step#i

The offset footstep is to select column data that you desire to sort.

Step#2

Click on Data and eventually sort. This will make sure that the rows are intact but the columns accept changed. After this, the sort alert dialog will popular up. You are supposed to go on the Expand the selection option and after that click on sort. The screenshot below shows that clearly.

Stride#3

Now you lot have to specify the benchmark that you volition sort on. The aforementioned warning will prompt you to enter the sorting order. That is clearly shown past the screenshot below.

If that works, what will follow is to click ok to save your changes. After that, you will find out that the column has been sorted and the rows are even so intact.

Another situation is when you want to sort the information depending on the accented values. In this case, you lot cannot expect that the Excel Sort Button can help y'all straight. Information technology is clear that you volition have to get to another alternative method to get the same desirable results. This is just possible by the use of the Advanced Sort role in Excel.

Using the Advanced sort Function in Excel

Information technology's now very easy to sort the data past absolute values including the month, mean solar day, frequency, first or last proper noun, and a lot more. Nonetheless, this process will involve the installation of Excel's advanced sort function. To utilise this function, follow the beneath steps;

Step#1. This footstep is for downloading the advanced sort function for Excel. This volition brand sure y'all accept all the tools to perform as needed along the way.

Step#ii.
Select all the information range and eventually click Enterprise and lastly Advanced sort.

Step#3. At present information technology's time to select the cavalcade you want to sort. After that, you will be prompted to select the Benchmark that you want to sort on. The final thing to do is to select the sort order.

Stride#4. This is the last step where yous will only take to select Ok and the data will be perfectly sorted. You will as well realize that the rows will exist kept intact fifty-fifty after sorting.

There are many other 3^rd political party means of doing this but the above are the main ways that Excel helps you lot to sort. So hands up whoever thought they knew how to sort data without interfering with the rows and ended up messing the whole information. Mine is up considering I take experienced this many times.