• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Sorting Data in Ascending, Descending, or Alphabetical Order

0 Comments

Sorting Data in Ascending, Descending, or Alphabetical Order: There are times when you need to sort data in ascending or descending order, sort names alphabetically, and so on. The only difference lies in the data type. If you are sorting by name, the data will be sorted alphabetically. That means the data type is Text. When you sort in order, the data type is usually numeric. Ultimately, the purpose is to serve for statistical analysis, comparison, or data lookup. The following article will guide you on various ways to sort data in Excel.

1. Sorting Data using Sort & Filter

Step 1: First, select the columns containing the data you want to sort.
Then go to the Data tab => Under the Sort & Filter section, select Filter.

Sorting Data in Ascending Descending or Alphabetical Order2
Now, the first cell in each column will display a Filter button for selection.

Sorting Data in Ascending Descending or Alphabetical Order3If you click on the Filter icon of a column containing characters, the following options will appear:

  • Sort A to Z: Sorts in alphabetical order
  • Sort Z to A: Sorts in reverse alphabetical order

Sorting Data in Ascending Descending or Alphabetical Order4If you click on the Filter icon of a column containing numbers, the following options will appear:

  • Sort Smallest to Largest: Sorts numbers in ascending order
  • Sort Largest to Smallest: Sorts numbers in descending order

Sorting Data in Ascending Descending or Alphabetical Order5If you only need to sort data in a single column, simply select that column => Go to the Data tab => Select one of the two icons under the Sort & Filter section:

  • A to Z: Sorts in alphabetical order or ascending order for numbers
  • Z to A: Sorts in reverse alphabetical order or descending order for numbers
  • Sorting Data in Ascending Descending or Alphabetical Order6Step 2: A Sort Warning dialog box will appear, asking how you want to sort the data:
  • Expand the selection: This type of sorting will affect the data in other columns as well. Based on the sorting of the selected column, the data in other columns will be rearranged according to each corresponding row. This option is often preferred because the data in a table is usually interconnected horizontally, so when you change the sorting of one column, other columns should follow suit.
  • Continue with the current selection: Only sorts the data within the selected column without affecting other columns.

Sorting Data in Ascending Descending or Alphabetical Order7As a result, you will get a sorted table as shown below:

Sorting Data in Ascending Descending or Alphabetical Order82. Advanced Sorting

Step 1: Select the data table you want to sort.
Then go to the Data tab => Select the Sort icon.

Sorting Data in Ascending Descending or Alphabetical Order9
Step 2: The Sort dialog box will appear.
Change the selection in the Column field to the column name you want to sort.

In the Order column, if you have selected a column with character (or text) data, you will have two options: A to Z (alphabetical order) or Z to A (reverse alphabetical order).

If you have selected a column with numeric data, you will have two options: Smallest to Largest or Largest to Smallest.

Sorting Data in Ascending Descending or Alphabetical Order10You can continue adding more sorting levels after the initial sort by clicking on Add Level.

Another row for sorting data will appear, and you can perform the same steps as above.

After sorting the data based on the settings of the first row, Excel will continue sorting based on the sorting criteria in the subsequent rows for clusters of similar data that are close to each other.

For example, in the image below, Excel will sort the list based on the Math scores of students. Then, among students with the same scores, Excel will further sort their names alphabetically.

Sorting Data in Ascending Descending or Alphabetical Order11

 

After clicking OK, you will get the sorted result.

Sorting Data in Ascending, Descending, or Alphabetical Order

Sorting Data in Ascending, Descending, or Alphabetical Order

That’s it! The article has guided you on different ways to sort data in Excel. Good luck!

Rate this post
27
253 Views
Searching and Replacing Data Quickly in Excel with Find and ReplacePrevSearching and Replacing Data Quickly in Excel with Find and ReplaceMay 27, 2023
Tips for Using the RANK Function to Rank Data in ExcelMay 28, 2023Tips for Using the RANK Function to Rank Data in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
Products
  • Project Professional 2013 Microsoft Project Professional 2013 - 1 PC $9.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.