EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Sort Column in Excel
 

Sort Column in Excel

Karthikeyan Subburaman
Article byKarthikeyan Subburaman
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 16, 2023

Sort Column in Excel

 

 

Introduction to Sort Columns in Excel

To sort the column in Excel, select the cell in the column we want to sort and then click on the Sort option, which is available in the Data tab. In the drop-down of Sort By, we will be able to see all the header’s names. Select the one which we want to sort. And then, select the criteria from Sort On and Values by which we can sort the values from that column. We also insert multiple levels by which we can get a more precise or exact output.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Sort Columns in Excel?

In Excel, we can find the SORT under the DATA menu, as shown in the below screenshot.

You can download this Column Sort Excel Template here – Column Sort Excel Template

Sort column in excel data

Where we can find the sort option like A to Z (Ascending to Descending order ) and Z to A (Descending to Ascending Order).

Sort Column in Excel is very simple and easy to use. Let us understand the working of Column Sort in Excel with some examples.

Example #1

In this example, we will see how to use the sort function by using the sales data available in the database, as shown below.

Sort Column product title

The above example has sales data that contain SKU, Product name, BRAND, and MRP; now consider that we are going to sort the sales data by A to Z using the Product name as follows:

  • First, select column B, a column named product name & apply the sorting.
  • Go to the Data menu.
  • Choose the A to Z Sorting as shown below.

Sort Column press F1

  • Once we click on the A to Z option, we will get the below dialogue box.

Sort Column sort warning

  • Sorting will ask for two options either to
  1. Expand the selection or
  2. Continue with the current selection.

Expand Section

  • Choose the first option to Expand the selection and Click Sort.

Display product

  • The result will be displayed as an A to Z order.

Column Example 1-6

Example #2

In these examples, we will try to sort out the sales data in reverse order, i.e., Using Z to A Sorting.

Consider the same sales data and apply it to sort by following the procedure below.

  • First, select column B, column name product name & apply the sorting.
  • Go to the Data menu.
  • Choose the Z to A Sorting as shown below:

Sort Example 2-1

  • Sorting will ask for two options either to
  1. Expand the selection or
  2. Continue with the current selection.
  • Choose the first option to Expand the selection And Click Sort.

Column expand Selection

  • The result will be displayed in a Z to A order.
  • As shown below, we will get the sales data arranged in Z to A format.

Arrange format

Example #3 – Advance Sort Option

In this example, we will see the advanced sort option, which allows us to sort out multiple options; so that we can get the specific data we are looking for; we can find custom sort under sort opting as explained below.

In Excel, we can find this custom sort option at the right corner of the ribbon, as shown below:

sort filter

  • Choose the custom sort option to get the sorting dialogue box as follows.

Column Sort Example 3-2

  • The sorting option will ask to expand the selection or to continue with the current selection.
  • Choose the first option to Expand the selection And Click Sort.

Column Sort Example 3-3

  • As shown below, we will get the custom sort option dialogue box with multiple sorting.

Column Sort Example 3-4

We can see that the above screenshot has three multiple sorting options Sort by “Product Title”, By “Values”, and By Order “A to Z or Z to A.

Now we will see how to use these three different options by following the below procedure:

  • Click the Product title.
  • It will list the name displayed as follows, which comes from the database header sales data.

Column Sort Example 3-5

  • Now we can sort by using multiples title, values, and order.
  • Consider that we need to sort the sales data by Brand wise with A to Z sorting order.
  • Click on the brand option and select the order from A to Z.

Column Sort Example 3-6

  • The sorting option will sort out the result brand-wise from A to Z order, as shown below.

Column Sort Example 3-7

The above example shows that the brand column has been sorted brand-wise with A to Z order.

Example #4

In this example, we will see how to sort the sales data using numbers.

Let’s consider the sales data, which has selling prices for different products as follows. So if we want to find out the least selling price of the product in huge sales data, it’s very difficult to find the exact least selling prices. In this scenario, we can use the Sorting feature by using numbers to ascend to descending order and vice versa. Let’s see the example with sales data by sorting the numbers.

Here we can see the sales database, which has the product name, Brand-name, MRP, and Selling prices now; let’s see how to sort the numbers from smallest to highest.

  • Select the E-column cell named SP to sort out the Smallest to Highest numbers.
  • Go to the sort option as follows.
  • Once we click the sort option, we can see the sorting options like smallest to highest and highest to smallest.
  • Select the smallest to highest to get the least selling price.

Column Sort Example 4-1

  • Now we can see the difference in the selling price that it has been sorted from smallest to highest numbers.

Column Sort Example 4-2

  • Same as this, we can do vice versa to get the highest selling price to the lowest selling price by using the sorting option “Largest to Smallest.

Column Sort Example 4-3

Example #5

In this, sorting will show how to get the highest-selling MRP for a specific product.

Let’s consider the below example which has MRP for all the products as shown below:

Column Sort Example 5-1

Here we need to find out which product is selling in Higher MRP. In these cases, we can use the sort option for a number by sorting the largest to smallest as follows:

  • Choose the MRP cell and go to the sorting option.
  • Choose the Sorting option from Largest to Smallest.

Column Sort Example 5-2

  • The sales data will be rearranged as follows.

Column Sort Example 5-3

We can see in the sales data clearly that the MRP column has been sorted from largest to smallest. Now we can configure easily that the above products are selling at the highest MRP.

Things to Remember about Sort Columns in Excel

  • Do not use a blank column while using sorting in Excel.
  • Do not hide the column in Excel while sorting because it cannot be moved once the column is hidden. So it’s better to unhide the column before applying it to sort.
  • Enter the caption header in one row, and do not merge the cell while sorting a column in Excel.

Recommended Articles

This has been a guide to Sort Column in Excel. Here we discuss how to Sort Columns in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel Sort by Date
  2. Excel Sort By Number
  3. Sorting in Excel
  4. Excel Sort by color

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Column Sort Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Column Sort Excel Template

EDUCBA

डाउनलोड Column Sort Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW