Your data is entered into your database, row by row, in any order. Should you wish to re-order the rows
to better portray some aspect of the database, you may wish to sort the data. There are multiple ways to do it (use
- Sort list in alphabetical, numerical, or chronological order
- Order can be ascending or descending
How to sort
Select the column or array you wish to sort, then choose Data > Sort & Filter > Sort from the ribbon
The same is true in Excel for Mac
Or use the sort tools from the right click option.
The ribbon option and the Custom Sort option both will reveal the dialog box.
Check that the data sorted correctly.
To undo, use the undo icon or CTRL-Z or "Edit, Undo"
or just redo the sort.