Latest posts by techwriter (see all)
- INFOGRAPHICS – Which Business Entity is Right for You? - September 28, 2016
- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 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: