.png "Sort data in Excel")
The Excel calculation program can sort the data in an Excel file. Useful when you want to arrange an address list alphabetically, for example.
Why sort?
For example, in an address list you have included the titles ‘First name’, ‘Last name’, ‘Date of birth’, ‘Address’, ‘Postal code’ and ‘City’ in the first row, per column. You always supplement the document with new data. At some point, that becomes cluttered unless you sort the rows. This can be done in alphabetical order, for example.
Sort data
- Click on a cell that contains data. For example, a surname or a date of birth. It can be any item in the queue.
- On the ‘Home’ tab, click Sort and filter.
- Click on the desired sort.
- If the cell contains text, you can choose ‘Sort from A to Z’ or vice versa.
- If the cell contains a number, you can choose from ‘Sort from lowest to highest’ or vice versa.
- If the cell contains a date, you can choose from ‘Sort from oldest to newest’ or vice versa.
Excel sorts the data directly by, for example, last name or date of birth.
You can also sort like this:
- Right-click a cell that contains data.
- click on To sort > [de gewenste sorteeroptie].