Use sorting to organize and analyze your data with ease. Prioritized sorting allows you to drill down to the nitty-gritty without mixing your data around.
1. Open a workbook and select the data range you'd like to sort
2. Go to the Edit menu and select Sort Range...
3. Select a column from your range that you’d like to start sorting by
4. If you'd like to sort by more columns in your data range, select the Add column to sort by button
5. Be sure to save your sorting details by clicking the Sort button
Make sure to select all related data for your data range. Otherwise you risk sorting a single column while leaving the rest of its related data unattached and jumbled!
If this happens, don’t sweat it. Undo (ctrl+Z) is there to save us all from ourselves.