Instructions on how to sort in Excel

Instructions on how to sort in Excel
This post was published on the now-closed HuffPost Contributor platform. Contributors control their own work and posted freely to our site. If you need to flag this entry as abusive, send us an email.

Instructions on how to sort with excel:

Make sure you have the entire spreadsheet selected by clicking on the box on the upper left hand corner of the spreadsheet, then click on the Data drop-down window and select Sort. In the dialogue box that opens, make sure the radial next to Header Row is selected, then choose up to three columns to sort by. For example, if you're trying to find how much money was donated after a specific online fundraising appeal, you might want to sort the spreadsheet by Date, then Quarterly Contribution. If you're trying to correlate the money raised in a specific state after Bill Clinton attended a fundraiser there, you might want to sort the data by State, then Date, then Quarterly Contribution.

If you're worried the sort went wrong, please double-check a line in the sorted document against the original. Any questions? Contact me at ethanotb@gmail.com

Popular in the Community

Close

What's Hot