Excel Sorting And Filtering Data. Click on largest to smallest. To quick sort in ascending order click sort a.
In our example we re going to click cell d3 and sort this column by salary. Now you will see a drop down button arrow button at the top of each of the columns on the spreadsheet. On the data tab in the sort filter group do one of the following.
Select expand the selection.
Right click to open the menu. Select this icon to change or clear the filter. Sorting and filtering data with excel. In excel click inside the cell atop the column you want to sort.