Assembly, Why Add 1 To The Largest Int Will Result In Smallest Int?

Sorting information is an integral part of information analysis. You might want to arrange a list of names in alphabetical order, compile a listing of product inventory levels from highest to lowest, or order rows by colors or icons. Sorting information helps yous quickly visualize and understand your data meliorate, organize and find the information that y'all desire, and ultimately make more effective decisions.

You can sort information by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list y'all create (such every bit Big, Medium, and Small) or by format, including prison cell color, font color, or icon set.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sort text

Select a prison cell in the column you want to sort.
On the Data tab, in the Sort & Filter group, practice one of the following:
- To quick sort in ascending guild, click (Sort A to Z).
- To quick sort in descending order, click (Sort Z to A).

Notes: Potential Issues

Check that all data is stored every bit text If the column that you want to sort contains numbers stored every bit numbers and numbers stored as text, you need to format them all equally either numbers or text. If yous do not utilize this format, the numbers stored as numbers are sorted before the numbers stored as text. To format all the selected data equally text, Printing Ctrl+1 to launch the Format Cells dialog, click the Number tab and then, nether Category, click General, Number, or Text.
Remove whatever leading spaces In some cases, data imported from another application might have leading spaces inserted before information. Remove the leading spaces before you sort the data. You can practice this manually, or you tin use the TRIM function.

Select a prison cell in the cavalcade you want to sort.
On the Information tab, in the Sort & Filter grouping, do one of the following:
- To sort from low to loftier, click (Sort Smallest to Largest).
- To sort from loftier to low, click (Sort Largest to Smallest).

Notes:

Potential Issue
Cheque that all numbers are stored as numbers If the results are not what you expected, the column might contain numbers stored every bit text instead of as numbers. For case, negative numbers imported from some bookkeeping systems, or a number entered with a leading apostrophe (') are stored as text. For more information, see Fix text-formatted numbers by applying a number format.

Select a cell in the column yous want to sort.
On the Data tab, in the Sort & Filter group, do one of the following:
- To sort from an earlier to a later date or time, click (Sort Oldest to Newest).
- To sort from a later to an earlier date or time, click (Sort Newest to Oldest).

Notes: Potential Issue

Bank check that dates and times are stored as dates or times If the results are not what y'all expected, the cavalcade might contain dates or times stored as text instead of as dates or times. For Excel to sort dates and times correctly, all dates and times in a column must exist stored as a date or time serial number. If Excel cannot recognize a value every bit a date or time, the date or time is stored every bit text. For more than information, meet Convert dates stored as text to dates.
If you want to sort by days of the week, format the cells to show the day of the week. If yous want to sort by the day of the week regardless of the date, convert them to text by using the TEXT function. Even so, the TEXT role returns a text value, so the sort operation would exist based on alphanumeric data. For more data, encounter Show dates as days of the week.

You may desire to sort by more than than one cavalcade or row when yous have data that you want to group by the same value in one cavalcade or row, and then sort another column or row within that group of equal values. For example, if yous have a Department cavalcade and an Employee column, you can first sort by Department (to group all the employees in the same department together), and so sort by name (to put the names in alphabetical lodge within each section). You can sort by up to 64 columns.

Annotation:For best results, the range of cells that you sort should have column headings.

Select any jail cell in the data range.
On the Information tab, in the Sort & Filter grouping, click Sort.
In the Sort dialog box, under Column, in the Sort past box, select the first cavalcade that yous desire to sort.
Nether Sort On, select the type of sort. Do one of the post-obit:
- To sort by text, number, or engagement and fourth dimension, select Values.
- To sort by format, select Prison cell Colour, Font Color, or Cell Icon.
Under Order, select how you desire to sort. Practise one of the following:
- For text values, select A to Z or Z to A.
- For number values, select Smallest to Largest or Largest to Smallest.
- For date or time values, select Oldest to Newest or Newest to Oldest.
- To sort based on a custom list, select Custom List.
To add another cavalcade to sort by, click Add together Level, and then echo steps three through five.
To copy a cavalcade to sort by, select the entry so click Copy Level.
To delete a column to sort past, select the entry and then click Delete Level.

Note:You must go on at least one entry in the list.
To modify the order in which the columns are sorted, select an entry and so click the Up or Down arrow adjacent to the Options button to modify the order.

Entries college in the list are sorted before entries lower in the list.

If you accept manually or conditionally formatted a range of cells or a table cavalcade by jail cell color or font colour, you tin can also sort by these colors. Y'all tin can likewise sort by an icon set that y'all created with provisional formatting.

Select a prison cell in the column you want to sort.
On the Information tab, in the Sort & Filter group, click Sort.
In the Sort dialog box, under Column, in the Sort by box, select the column that you want to sort.
Under Sort On, select Cell Colour, Font Color, or Prison cell Icon.
Nether Order, click the arrow next to the button and then, depending on the type of format, select a prison cell color, font color, or cell icon.
Side by side, select how you want to sort. Practice one of the following:
- To motility the cell color, font color, or icon to the top or to the left, select On Pinnacle for a column sort, and On Left for a row sort.
- To motion the prison cell color, font colour, or icon to the lesser or to the correct, select On Bottom for a column sort, and On Correct for a row sort.
  
  Annotation:There is no default cell color, font colour, or icon sort order. You must define the social club that you desire for each sort performance.
To specify the next jail cell colour, font color, or icon to sort by, click Add Level, and then repeat steps 3 through five.

Make sure that yous select the same cavalcade in the And so by box and that you make the same choice under Order.

Proceed repeating for each boosted cell color, font color, or icon that y'all want included in the sort.

You can utilise a custom listing to sort in a user-divers order. For instance, a column might incorporate values that y'all want to sort by, such as High, Medium, and Low. How tin you sort so that rows containing Loftier appear beginning, followed by Medium, then Low? If you were to sort alphabetically, an "A to Z" sort would put High at the top, merely Low would come earlier Medium. And if you lot sorted "Z to A," Medium would appear offset, with Low in the middle. Regardless of the order, you always want "Medium" in the centre. By creating your own custom list, you can get around this problem.

Optionally, create a custom list:
1. In a range of cells, enter the values that you lot want to sort by, in the order that yous want them, from acme to lesser as in this example.
2. Select the range that you merely entered. Using the preceding example, select cells A1:A3.
3. Become to File > Options > Avant-garde > Full general > Edit Custom Lists, then in the Custom Lists dialog box, click Import, then click OK twice.
  Notes:
  - You can create a custom list based only on a value (text, number, and appointment or time). You cannot create a custom list based on a format (cell colour, font color, or icon).
  - The maximum length for a custom list is 255 characters, and the kickoff grapheme must not begin with a number.
Select a cell in the column you desire to sort.
On the Data tab, in the Sort & Filter group, click Sort.
In the Sort dialog box, nether Cavalcade, in the Sort by or So by box, select the column that you want to sort by a custom list.
Under Society, select Custom List.
In the Custom Lists dialog box, select the list that you lot want. Using the custom list that you created in the preceding example, click High, Medium, Low.
Click OK.

On the Data tab, in the Sort & Filter group, click Sort.
In the Sort dialog box, click Options.
In the Sort Options dialog box, select Case sensitive.
Click OK twice.

It's most mutual to sort from top to lesser, but you can as well sort from left to right.

Note:Tables don't back up left to right sorting. To practice so, first convert the table to a range by selecting any jail cell in the table, and and so clicking Table Tools > Convert to range.

Select whatsoever cell within the range you want to sort.
On the Data tab, in the Sort & Filter group, click Sort.
In the Sort dialog box, click Options.
In the Sort Options dialog box, under Orientation, click Sort left to correct, and so click OK.
Under Row, in the Sort by box, select the row that you lot want to sort. This will generally be row one if you desire to sort by your header row.

Tip:If your header row is text, merely you lot desire to guild columns by numbers, you tin can add a new row to a higher place your information range and add numbers according to the club you want them.
To sort past value, select one of the options from the Order drib-downwards:
1. For text values, select A to Z or Z to A.
2. For number values, select Smallest to Largest or Largest to Smallest.
3. For engagement or time values, select Oldest to Newest or Newest to Oldest.
To sort past cell color, font color, or prison cell icon, practice this:
1. Nether Sort On, select Cell Color, Font Color, or Cell Icon.
2. Under Order select a cell color, font color, or jail cell icon, then select On Left or On Right.

Note:When you sort rows that are function of a worksheet outline, Excel sorts the highest-level groups (level 1) then that the particular rows or columns stay together, even if the detail rows or columns are hidden.

To sort by a function of a value in a column, such equally a part number code (789-WDG-34), terminal name (Carol Philips), or first name (Philips, Carol), you first need to split the column into two or more columns and then that the value you desire to sort by is in its ain cavalcade. To do this, you can utilize text functions to separate the parts of the cells or y'all can use the Catechumen Text to Columns Wizard. For examples and more information, meet Split up text into different cells and Split text among columns by using functions.

Warning:It is possible to sort a range within a range, but it is not recommended, because the result disassociates the sorted range from its original information. If you were to sort the following information as shown, the selected employees would be associated with different departments than they were earlier.

Example of sorting a small range within a larger one.

Fortunately, Excel will warn you lot if it senses you are about to attempt this:

Click Continue with the current selection

If you did not intend to sort similar this, then printing the Aggrandize the selection choice, otherwise select Continue with the electric current selection.

If the results are not what you lot desire, click Undo Undo button .

Note:You cannot sort this way in a tabular array.

If you get unexpected results when sorting your data, do the following:

Bank check to see if the values returned by a formula take changed If the data that you lot take sorted contains one or more formulas, the return values of those formulas might change when the worksheet is recalculated. In this instance, make sure that you reapply the sort to get upwardly-to-date results.

Unhide rows and columns before you sort Subconscious columns are not moved when y'all sort columns, and hidden rows are not moved when you lot sort rows. Earlier y'all sort information, it's a adept idea to unhide the subconscious columns and rows.

Bank check the locale setting Sort orders vary by locale setting. Make sure that y'all have the proper locale setting in Regional Settings or Regional and Language Options in Control Console on your computer. For information about changing the locale setting, come across the Windows help arrangement.

Enter column headings in just one row If you lot need multiple line labels, wrap the text within the prison cell.

Turn on or off the heading row It's usually best to have a heading row when y'all sort a column to make it easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation. Occasionally, yous may demand to turn the heading on or off so that the value in the heading is or is not included in the sort performance. Do ane of the post-obit:

To exclude the first row of data from the sort because information technology is a column heading, on the Home tab, in the Editing grouping, click Sort & Filter, click Custom Sort so select My data has headers.
To include the get-go row of information in the sort because it is non a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort, and then clear My data has headers.

If your data is formatted as an Excel table, and so you tin quickly sort and filter it with the filter buttons in the header row.

If your information isn't already in a table, then format it as a table. This will automatically add a filter push button at the height of each table column.
Click the filter button at the top of the column y'all desire to sort on, and pick the sort lodge you want.
To disengage a sort, employ the Undo push button on the Dwelling house tab.

Pick a prison cell to sort on:
- If your data has a header row, pick the one y'all desire to sort on, such as Population.
- If your data doesn't accept a header row, choice the topmost value you want to sort on, such equally 634535.
On the Data tab, choice one of the sort methods:
- Sort Ascending to sort A to Z, smallest to largest, or earliest to latest date.
- Sort Descending to sort Z to A, largest to smallest, or latest to earliest engagement.

Excel Sort Ascending or Descending buttons on the Data tab

Let'south say you accept a tabular array with a Section column and an Employee column. You lot can offset sort by Department to grouping all the employees in the same department together, and and so sort by name to put the names in alphabetical social club within each department.

Select any cell within your information range.

On theInformation tab, in the Sort & Filter grouping, click Custom Sort.
In the Custom Sort dialog box, underColumn, in the Sort by box, select the first column that yous want to sort.

Note:The Sort On menu is disabled considering it's not still supported. For now, you can change it in the Excel desktop app.
NetherOrder, select how you want to sort:
- Sort Ascending to sort A to Z, smallest to largest, or earliest to latest appointment.
- Sort Descending to sort Z to A, largest to smallest, or latest to primeval date.
To add another column to sort by, click Add and then repeat steps five and six.
To change the lodge in which the columns are sorted, select an entry and then click theUpward orDown pointer next to theOptions button.

If you lot accept manually or conditionally formatted a range of cells or a table cavalcade past prison cell colour or font color, you can too sort by these colors. You can also sort past an icon gear up that yous created with conditional formatting.

Select a cell in the column you lot want to sort
On theData tab, in theSort & Filtergroup, selectCustom Sort.
In theCustom Sortdialog box underColumns, select the column that you want to sort.
Under Sort On, select Cell Color, Font Color or Provisional Formatting Icon.
UnderSociety, select the order you want (what you see depends on the blazon of format you have). Then select a cell color, font color, or cell icon.
Side by side, you'll choose how you want to sort by moving the cell color, font color, or icon:

Annotation:There is no default cell color, font color, or icon sort order. Yous must define the social club that you want for each sort operation.
- To move to the meridian or to the left: SelectOn Meridian for a column sort, andOn Left for a row sort.
- To movement to the bottom or to the correct: SelectOn Bottom for a column sort, andOn Correct for a row sort.
To specify the next cell color, font color, or icon to sort by, selectAdd Level, then repeat steps one- five.

Make certain that yous the column in theThen by box and the selection under Order are the same.
Repeat for each additional cell color, font color, or icon that you want included in the sort.

On theDatatab, in theSort & Filter group, click Custom Sort.
In the Custom Sort dialog box, clickOptions.
In theOptions menu, selectExample sensitive.
ClickOK.

It's nigh common to sort from summit to bottom, but you tin also sort from left to correct.

Note:Tables don't support left to correct sorting. To do then, first convert the table to a range by selecting any prison cell in the table, and and so clicking Table Tools > Convert to range.

Select any cell within the range y'all want to sort.
On theDatatab, in theSort & Filter grouping, selectCustom Sort.
In the Custom Sort dialog box, clickOptions.
NetherOrientation, clickSort left to correct
NetherRow, in the 'Sort by' drop down, select the row that you lot desire to sort. This will mostly exist row ane if yous want to sort by your header row.
To sort by value, select 1 of the options from the Order drop-downwards:
- Sort Ascending to sort A to Z, smallest to largest, or earliest to latest date.
- Sort Descending to sort Z to A, largest to smallest, or latest to earliest date