One of the most useful features in Excel is the Sort feature.
It is very easy to sort data, you don’t have to select anything.
Just position on the column that you want to sort by, in your set of data.
Press Alt + A for the Data ribbon, then S for Sort, then press A for Ascending or D for Descending.
So, Alt + A, then S, then A for Ascending.
And, Alt + A, then S, then D for Descending.
Excel will sort on the information in the column that you are positioned on, and bring all the other data with it.
Just make sure there are no blank rows or columns in your data set.
Sort Data in an Excel Spreadsheet
posted in: Shortcut of the Week
0
Leave a Reply