1. Highlight the cells or column that you want to sort. If your numeric data range has headers, it does not matter if you include them or not. Excel is smart enough to recognize them and leave them at the top. In this example, we will sort the January total from largest to smallest to see easily the top performing salesman for that month.Excel Sort example

2.Right-click anywhere in the selected region, and go to sort. From there, choose if you want to sort your data from smallest to largest or vice versa.Excel Sort right click

3.You will be asked if you want to expand the selection or continue with the current selection. Expanding the selection in this example means that the salesmen and February totals will be rearranged to stay with the January totals as they are sorted. Continuing with the current selection would only sort the values we have highlighted in the January Totals column. We need to keep the names and other data associated with each other, so in this case, we pick expand the selection.Excel Sort Warning

4.You can also access the sort options by clicking on Sort & Filter in the editing portion on the far right of the Home tab of the ribbon.excel sort ribbon


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.