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.
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.