How to Sort Data in Excel Using Sort Is Extremely Simple

This practical guide explains how to Sort Data in Excel Using Sort Is Extremely Simple through clear, ordered steps. It also covers useful settings, common mistakes, and checks that can improve the final result.

Knowing how to Sort data in Excel Not only saves you time but also optimizes your work. Discover simple tips for filtering and managing data with Free Download now.

Instructions on how to filter and sort data on Excel spreadsheets

Note: The article below Free Download will guide you how to arrange data on Excel 2016 version, with Office 2010, Office 2013 and other versions, you can do the same.  

How to Sort Data in Excel

Excel 2016 provides many options for sorting data, helping you manage and find information efficiently. Below, Free Download will guide readers on how to filter data in Excel from basic to advanced.  

Sort Data in Excel by 1 Column

Suppose you have the following data table:

Requirement 1: Sort the employee list by Name from A to Z.

How to do it:

Step 1: Select the entire data table.

Step 2: Select Expand the selection And click Sort .

Step 4: In theSort Dialog box, customize as follows:

- Column: Select Name .

- Sort On: Select Values ??.

- Order : Select A to Z or Z to A.

Then Click OK .

- The results of sorting data in Excel will be filtered according to the settings.

Requirement 2: Arrange the employee list by Department "Marketing => IT => Accounting".

How to do it:

Step 1: Select the entire data table.

Step 2: Go to theData Tab, click Sort .

Step 3: In the Sort Dialog box:

-At Column: Select Department .

-At Sort On: Select Values ??.

- At Order: Select Custom List .  

Step 4: When theCustom Lists Dialog box opens:

- Select NEW LIST .

- In the List entries Box, enter the syntax: Marketing, IT, Accounting .

=> Click OK .

Step 5: Click OK in theSort Dialog box. And the result you get is:

 

How to Sort Data in Excel for Multiple Columns

When working with large data tables, you will sometimes need to sort multiple columns at once to categorize the data.

From the data table below, Free Download will guide you how to sort data for 2 columns at the same time: Department (AZ) and Salary (Descending/Largest to Smallest).

Steps to follow:

Step 1: Select the entire data table

Step 2: On the Data tab, open theSort Tool

Step 3: Add sort conditions

- Condition 1:

+ At Column : Select the Department Column.

+ At Sort On : Select Values .

+ At Order : Select A to Z.

Click Add Level To add a sorting condition.

- Condition 2:

+ At Column: SelectSalary Column.

+ At Sort On : Select Values .

+ At Order : Select Largest to Smallest .  

Step 4: Click OK

So you have arranged the data in Excel in the desired order.

Note: If you want to add sorting conditions, just click Add Level In step 3 to filter multiple data columns at the same time.

So you know how to Sort data in Excel . Customize data filtering according to this guide, you will track and manage data effectively, find special data in the spreadsheet.

Excel also supports users with the Advance Filter function to filter the desired data. Please refer to how to use Advance Filter in Excel That Free Download has instructed to have the best way to handle it.

FAQ

How do I Sort Data in Excel Using Sort Is Extremely Simple?

Follow the steps in this guide in order, verify each setting before continuing, and check the result after every major change.

What should I prepare before I Sort Data in Excel Using Sort Is Extremely Simple?

Confirm compatibility, install current updates, save important work, and back up data before changing system or application settings.

What can I do if sort Data in Excel Using Sort Is Extremely Simple does not work?

Review permissions and requirements, restart the relevant device or app, repeat the steps carefully, and use official support resources when the issue continues.