In the Custom Sort dialog box, under Column , in the Sort by box, select the first column that you want to sort. Note: The Sort On menu is disabled because it's not yet supported. For now, you can change it in the Excel desktop app. To add another column to sort by, click Add and then repeat steps five and six. To change the order in which the columns are sorted, select an entry and then click the Up or Down arrow next to the Options button.
In the Custom Sort dialog box under Columns , select the column that you want to sort. Under Order , select the order you want what you see depends on the type of format you have.
Then select a cell color, font color, or cell icon. To move to the bottom or to the right: Select On Bottom for a column sort, and On Right for a row sort. To specify the next cell color, font color, or icon to sort by, select Add Level , and then repeat steps 1- 5. Make sure that you the column in the Then by box and the selection under Order are the same. In the Custom Sort dialog box, click Options. In the Options menu, select Case sensitive. Under Orientation , click Sort left to right.
Under Row , in the 'Sort by' drop down, select the row that you want to sort. To sort by value, select one of the options from the Order drop-down:. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Video: Sort data in a table. Import and analyze data. Sort and filter. Sort data in a range or table. Notes: To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting.
Sort text Select a cell in the column you want to sort. Notes: Potential Issues Check that all data is stored as text If the column that you want to sort contains numbers stored as numbers and numbers stored as text, you need to format them all as either numbers or text. Select a cell in the column you want to sort. Notes: Potential Issue Check that all numbers are stored as numbers If the results are not what you expected, the column might contain numbers stored as text instead of as numbers.
Notes: Potential Issue Check that dates and times are stored as dates or times If the results are not what you expected, the column might contain dates or times stored as text instead of as dates or times. Next, select how you want to sort.
Do one of the following: To move the cell color, font color, or icon to the top or to the left, select On Top for a column sort, and On Left for a row sort. Optionally, create a custom list: In a range of cells, enter the values that you want to sort by, in the order that you want them, from top to bottom as in this example.
Select the range that you just entered. Using the preceding example, select cells A1:A3. Notes: You can create a custom list based only on a value text, number, and date or time. In the Sort dialog box, click Options. In the Sort Options dialog box, select Case sensitive. Click OK twice. It's most common to sort from top to bottom, but you can also sort from left to right.
Note: You cannot sort this way in a table. If you get unexpected results when sorting your data, do the following: Check to see if the values returned by a formula have changed If the data that you have sorted contains one or more formulas, the return values of those formulas might change when the worksheet is recalculated.
To undo a sort, use the Undo button on the Home tab. Pick a cell to sort on: If your data has a header row, pick the one you want to sort on, such as Population. She's written tips and tutorials for Microsoft Office applications and other sites. Facebook Twitter LinkedIn. Updated on February 04, Tweet Share Email. Was this page helpful? Thanks for letting us know!
Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. As you can see in the sorted table on the right, the related information in each row is kept together:. In some situations, mostly when just one or a few cells in the middle of your data set are selected, Excel is unsure which part of the data to sort and asks for your instructions.
If you'd like to sort the entire table, leave the default Expand the selection option checked, and click Sort :. Another quick way to sort alphabetically in Excel is to add a filter.
The beauty of this method is that it's one-time setup - once the auto filter is applied, the sort options for all columns are only a mouse click away. The column is alphabetized straight away, and a small upward arrow on the filter button indicates the sorting order ascending :. In case you want to alphabetize data in several columns, use the Excel Sort command, which gives more control over how your data is sorted.
As an example, let's add one more column to our table, and then arrange the entries alphabetically first by Region , and then by Name :.
In most cases, you can select just one cell and Excel will pick the rest of your data automatically, but this is an error-prone approach, especially when there are some gaps blank cells within your data. In the Sort by dropdown box, select the column you want to alphabetize first, Region in our case.
In this example, the second level sorts the values in the Name column alphabetically from A to Z:. Excel will sort your data in the specified order. As shown in the screenshot below, our table is arranged alphabetically exactly as it should: first by Region , and then by Name :.
If your data is arranged horizontally, you may want to sort it alphabetically across rows. This can also be done by using the Excel Sort feature. Here's how:. As the result, the first row in our table is sorted in alphabetical order, and the rest of the data is rearranged accordingly, preserving all correlations between the entries:. Excel sort features are amazing, but if you are working with an imperfectly structured data, things may go terribly wrong.
Here are the two common issues. An easy fix is to eliminate the blanks and unhide all hidden areas before sorting. November 9, All rights reserved. Microsoft Excel. Data Science. Microsoft Office. Digital Marketing. Marketing Analytics in Google Data Studio. Link Text. Open link in a new tab. No search term specified. Showing recent items.
Search or use up and down arrow keys to select an item.
0コメント