Latest posts by techwriter (see all)
- How to Count the Number of Days with an Incident and Chart with Running Averages in MS Excel - October 19, 2016
- FREE Online Video Course – MS Word Power Shortcuts - October 14, 2016
- INFOGRAPHICS – Which Business Entity is Right for You? - September 28, 2016
© 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: