Sort the database in Excel

The following article provides detailed instructions for you to organize the database in Excel.

Sort the database in Excel Picture 1

Sorting data is indispensable when working in Excel.

1. Sort data simply.

Step 1: Select the data range to sort -> Data -> Sort:

Sort the database in Excel Picture 2

Step 2: The Sort dialog box appears, select the data fields to sort in Sort by -> select the sorting type in the Order section , for example, here sort the revenue in order from baby to big:

Sort the database in Excel Picture 3

After clicking OK, the result is:

Sort the database in Excel Picture 4

2. Sort names alphabetically.

Step 1: Insert 3 more columns, middle names and first names as shown:

Sort the database in Excel Picture 5

Step 2: Copy the entire NV Name column to the Name column -> press Ctrl + H -> the dialog box appears in the section:

- Find What: enter a star and the spacebar.

- Rreplace with section is empty

-> Finally, click Replace All:

Sort the database in Excel Picture 6

Step 3: After clicking Replace All, the result is shown:

Sort the database in Excel Picture 7

Step 4: In cell C9 in the column They enter the formula as shown:

Sort the database in Excel Picture 8

Step 5: Press Enter and make a copy of the formula for the remaining values ​​in the resulting column:

Sort the database in Excel Picture 9

Step 6: Perform copy the entire column They and paste the style Paste Value -> Copy the column They -> paste into the column MI -> press the key combination Ctrl + H -> dialog box that appears in the item:

- Find what: Enter stars and spaces.

- Replace with: Leave blank.

- Finally, click Replace All:

Sort the database in Excel Picture 10

Step 7: Copy and Paste the middle name column as Paste Value. In cell C9 of the column They enter the formula as shown:

Sort the database in Excel Picture 11

Step 8: After pressing Enter -> copy the formula for the remaining values ​​in the resulting column:

Sort the database in Excel Picture 12

Step 9: Make Copy and Paste column They styled Paste Value results:

Sort the database in Excel Picture 13

Step 10: Select the entire data table into Data -> Sort -> dialog box appears enter the values ​​as shown (to add a sort field, click Add Level):

Sort the database in Excel Picture 14

Step 11: After clicking OK, all the data in the table is sorted:

Sort the database in Excel Picture 15

- In case you want to combine 3 columns Last name, Middle name, First name column First and last name perform 3 strings inserting spaces:

Sort the database in Excel Picture 16

- Press Enter -> copy for the remaining values ​​in the column -> Copy the First and Last column and Paste as Paste Value -> delete the 3 columns Last name, Middle name, Result name :

Sort the database in Excel Picture 17

The above is a detailed guide on how to organize a database in Excel 2013.

Good luck!