Latest posts by techwriter (see all)
- INFOGRAPHICS: Single-Source Publishing Tools - October 20, 2017
- 2 Good Reasons to Write for Free Rather Than for Just a Few Bucks - October 18, 2017
- 10 Indispensable Concepts of English Grammar You Should Know - October 16, 2017
© 2011 Ugur Akinci
Select the column you’d like to filter and sort out from lowest to highest value, or vice-versa.
NOTE: Make sure your column has a label at top. Otherwise Excel will treat the value of your first cell as a “label”.
In our example, we would like to sort our data by PRICE, the second column.
Click and select the second column and then, in the DATA tab, click on the Sort A-to-Z button:
This will display the following dialog box:
If you select the “Continue with the current selection” option, the PRICE column will be sorted WITHOUT sorting all the other columns. Your result will be wrong:
Select “Expand the selection” option and then click the SORT button.
Now your data will be sorted out correctly, with every RECORD ROW displayed from the LOWEST to the HIGHEST PRICE:
NOTE: To sort the PRICE column from the highest to the lowest value, click the Z-to-A button: