If you have the latest Excel version, I am sure you already found the general sorting feature that helps you to sort data on colors, cell icons, and cell contents. But now how do you find the sort function to sort the columns and maintain the rows? There are many ways to go about this but the best and the simplest of all is the use of sort function in Excel. So, in that case, how do you sort a column and ensure the rows are intact? This can be very challenging especially if you have multiple columns in a single worksheet.
#Excel for mac 2016 sort column alphabetically how to
Today, we are going to discuss on how to sort alphabetically without interfering with the rows. The good thing is that there are many online resources to help you maneuver every corner of MS Excel. This is how we can add an order of our choice in Order drop down box of Sort dialog box.I understand using excel can be a daunting task, especially to newbies. If it does not appear you can also select it from the spreadsheet where you have written your order list and click on Import. The Import list from cells: box will show the reference of the cells we selected. Step 9: A Custom Lists dialog box will pop up. Step 8: Under Advanced option in General Section, click on Edit Custom Lists button. Step 7: An Excel Options dialog box will be opened. For example, I have written an order of Batches from 1 to 5. As we know the, it already provides the sorting of months and days. Step 5: Now let us learn how to customise the Order drop down box in Sort Dialog box. You can observe the data in front of the Total values has also shuffled to match the sorting result. But you can also customise the order of sorting Which I have discussed later in the article.Īnd here is how data has been sorted. In Order drop down box, I chose Smallest to Largest. whether you want to sort on values, or colour of cell, or colour of the font, etc. In Sort On drop box select the base of your sorting i.e. Now under Column section, in Sort by drop box select the column on which you want to apply sort. In case if we have selected Left to right sorting then Row section would have appeared. Step 4: Next, in Sort dialog box you can see a Column section, as we selected top to bottom sorting. Under Orientation section, select whether you want to perform sorting in a top to bottom fashion or from left to right fashion. If you want that sorting must also take care of case sensitivity then mark that checkbox. At the top, there is Case sensitive checkbox. Step 3: A Sort Options dialog box will pop up. First, check the Options tab to see whether the sorting will be done from top to bottom or from left to right. Step 2: As you will select Custom Sort, a Sort dialog box will appear. Here, you can directly choose among smallest to largest or largest to smallest.īut for demonstration, I chose Custom Sort to explain the particular tool. Click on it it provides three sorting operations Sort Smallest to Largest, Sort Largest to Smallest and Custom. Inside Home tab, under Editing group, we have Sort and Filter button. Step 1: Select the cell to which you want to apply sorting operation. So let us move on How to Sort Data in Ms Excel 2016 ? Steps to Sort Data in Ms Excel 2016: You can also create your own order for sorting data. Sorting comes in a frame when we need to arrange data in a certain fashion i.e.
0 kommentar(er)
