How to Sort Data in Tables

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.

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.

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.

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.

Technewborn is a leading problogging platform that covers the latest in technology, news, social media, mobile industry, apps, games, and more. I have been researching, writing, reading, living in it since 2009. I try adding a unique taste to whatever techy I write. You can follow me on below Social Network