EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Sort By Number
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Sort By Number

By Madhuri ThakurMadhuri Thakur

Sort by Number Example

Excel Sort By Number (Table of Contents)

  • Sort By Number in Excel
  • How to implement Sort By Number in Excel?
  • Sort By Number in Excel Examples

Sort By Number in Excel

In Excel, there are two ways to sort numbers. In first, select the data and then click on the Sort option from the Data menu tab. Choose the column whose value we want to sort, then choose Sort on Value from the drop-down. Now we can Sort the number by Largest to Smallest and vice-versa. We can also customize the sorting method in that. The second is using filters. Please select the column which has numbers; then, after applying filters, we will be able to sort numbers from Largest to Smallest and vice-versa.

Start Your Free Excel Course

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

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,898 ratings)

The structure of a workbook is such that it allows data in a tabular format. In addition, it allows you to view the data in different ways by using the following features:

  • Sort
  • Filter
  • Group

Today we will discuss the Sort By Number in Excel.

Sorting is a method that allows the user to order data. The textual data can be arranged in alphabetical order or in reverse alphabetical order. The Numerical data can be arranged in ascending order or in descending order. The date data can be arranged in the oldest to newest order or in the newest to oldest order. In addition, we can sort the data on a single criterion or on multiple criteria.

Today, we will work on the Sort by Number in Excel.

How to implement Sort By Number in Excel?

It is very simple and easy to use. This is the guide to Sort by Number Excel with Detailed Examples. In Excel, we can find the Sort option in two places:

  • Under File tab – under Editing Group – Click on Sort and Filter Dropdown Menu.
    • Then Sort A to Z or Z to A for textual data.
    • Then Sort oldest to newest or newest to oldest for Date data
    • Then Sort largest to smallest and smallest to largest for Numerical Data.

Sort by Number Example 1-1

  • Under Data tab – under Sort and Filter Group
    • Then Sort A to Z or Z to A for textual data.
    • Then Sort from oldest to newest or newest to oldest for Date data.
    • Then Sort largest to smallest and smallest to largest for Numerical Data.

Sort by Number Example 1-2

We can also use the Custom Sort option for the data sorted using multiple criteria. In Excel, we can find the sort option in two places:

  • Under File tab – under Editing Group – Click on Sort and Filter Dropdown Menu – Click on Custom Sort.

Sort by Number Example 1-3

  • Under Data tab – under Sort and Filter Group – Click on Sort.

Sort by Number Example 1-4

After this, A dialog box of Custom Sort will open as the following figure:

Sort by Number Example 1-5

We will find three headings:

  • Columns: We will find all the column headings of the table or range.
  • Sort On: It will give us a description of the data on Values, Cell Color, Font Color, and Cell Icon.
  • Order: We can also select the order smallest to largest or largest to smallest.

We can also use the following tabs:

  • Add Level: To add one or more criteria.
  • Delete Level: To delete the selected criterion or criteria.
  • Copy Level: To copy an existing criterion or criteria.

Examples of Sort By Number in Excel

There are two types of Sorting:

  • Single Level or one column sorting
  • Multi-level or two or more columns sorting

Let’s understand the working of Sort by Number in Excel by some examples.

You can download this Sort by Number Excel Template here – Sort by Number Excel Template

Sort By Number in Excel- Example # 1

Single level or one column sorting is sorting the data using one column.

Sort by Number Example 2-1

In the above figure, sorting the data using Employee Basic Pay is single level sorting.

  • Step 1: Select the data range from A2 to B12.

Sort by Number Example 2-2

  • Step 2: Either Go to File tab – under Editing Group – Click on Sort and Filter Dropdown Menu – Click on Custom Sort.

Or

  • Go to Data tab – under Sort and Filter Group – Click on Sort.

Sort by Number Example 2-3

  • Step 3: Now select the checkbox of the My data has headers so that the first row of the selected data of A2:B12 is taken as the header and not as data.

Sort by Number Example 2-3

  • Step 4: Now click on the Sort drop-down menu to select the column heading Employee Basic Pay.
  • Step 5: Then, under the Order drop-down menu, select Smallest to Largest.
  • Step 6: Click on OK.

Sort by Number Example 2-4

After all settings for Sort By Number in Excel, the result will appear as follows:

Sort by Number Example 2-5

Sort By Number in Excel – Example # 2

Example - Data

  • Step 1: Select the data range from A1 to G16

Selecting Data Range

  • Step 2: Either Go to File tab – under Editing Group – Click on Sort and Filter Dropdown Menu – Click on Custom Sort.

Or

  • Go to Data tab – Under Sort and Filter Group – Click on Sort.

Sort and Filter

  • Step 3: Now select the checkbox of the My data has headers so that the first row of the selected data of A1:G13 is taken as the header and not as data.

Checkbox

  • Step 4: Now click on the Sort drop-down menu to select the column heading Book Category.
  • Step 5: Then, under the order drop-down menu, select A to Z or Z to A.

Book Category

  • Step 6: Then click on Add Level for adding other criteria.
  • Step 7: Now click on the Sort drop-down menu to select the column heading Total Sales.
  • Step 8: Then, select Smallest to Largest or Largest to Smallest under the order drop-down menu.
  • Step 9: Click on OK.

Sort by Number

After adding all settings for Sort By Number in Excel, the result will appear as follows:

Result

Things to Remember

  • Our data will get jumbled, and reports will be incorrect if we do not sort the entire data table or range.
  • We have to select the check box; my data has headers so that Excel can understand the first row as the column heading and not as Data.
  • We can sort the numerical values to Sort by Number in Excel as smallest to largest and largest to smallest.
  • We can sort the textual values as A to Z or Z to A.
  • We can sort dates by Oldest to Newest, Newest to Oldest.
  • We can add many levels, such as single-level or multi-level so that we can change or alter the date according to our requirement.
  • We can sort only one color at a time with respect to sorting based on cell color or font color.

Recommended Articles

This has been a guide to Sort By Number in excel. Here we discussed how to Sort By Number in excel and How to implement Sort By Number in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Sorting in Excel
  2. Sort Column in Excel
  3. Excel Sort by Date
  4. VBA Sort
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Sort by Number Excel Template

EDUCBA

Download Sort by Number Excel Template

EDUCBA

डाउनलोड Sort by Number Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more