Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
When a column or a data range in excel has numbers in it then we have an option of sorting the data by numbers in excel after using filter on the data range or column, number filters have various options the first being largest to smallest or vice versa and other being the options of conditional formatting such as equals to or greater than a value and others.
Sort by Numbers in Excel (Table of Contents)
How to Sort by Numbers in Excel?
In this article, I will take you through the method of sorting numbers in excel. Believe me, not many people do not know about this cool technique. Then why are you waiting go ahead one step more than your other counterparts?
In excel, SORT option can be found under the Data tab. While sorting we may need to sort on a column in one scenario and in some cases we may require to sort multiple columns at a time.
Sort by Number in Excel – Step by Step Guide
Here we will learn how to sort by number in excel.
Sort Numbers in Excel Example #1 – Single Level Sorting
Single Level Sorting is nothing but sorting only one column at a time. Sort by employee name is one level sorting.
I have sales data based on the product. It includes product name and how many units sold in a month. I want to sort the sort based on the Units Sold column from largest to smallest.
Step 1: Select the data from A1 to B28.
Step 2: Go to Data tab and Sort. Use the shortcut key in excel to open the sort option. The shortcut key is ALT + D + S.
Step 3: Now the mandatory thing you need to do is make sure “My data has headers” checkbox has ticked. If this box has ticked means, the selected data has headers otherwise; your will header will be treated as the data only.
Step 4: Click on Sort by drop-down list and select the word Units Sold.
Step 5: After this undergo to Order section and select Largest to Smallest. By default, excel already selected the order a Smallest to Largest but we can change it according to our requirement.
Step 6: Click on Ok to sort the data from largest to smallest. Below image is the result of that.
Sort Numbers in Excel Example #2 – Multi-Level Sorting
Multi-Level Sorting includes many columns to sort at one. Sort by employee name and by department name. Here employee name is one layer and department is another layer.
Let us take one more example to understand better. In this example, I have the data of sales across four regions at a different time frame.
The first column includes dates, the second column includes the region name, and the third column includes revenue numbers.
Now my requirement is to sort the region-wise and also I want to sort the revenue number from Largest to Smallest and.
This is not a single layer sort. It is a multi-level sorting, we need to include
Step 1: Select the data first.
Step 2: Open the sort box by pressing ALT + D + S.
Step 3: Under Sort by select region name and under Order select A to Z.
Step 4: Now click on Add Level to add one more layer for the Revenue column.
Step 5: Now under this layer select Revenue first and then Largest to Smallest.
Note: Firstly, excel will sort Region-wise data and under this, it will sort revenue-wise from largest to smallest. By this sort, we easily get to know what is the highest revenue under each region.
Step 6: Click on OK to sort the data.
Things to Remember in Sort by Numbers in Excel
- We need to select the entire data range to sort. Otherwise, our data will be shuffled and reports will go wrong.
- We need to click the checkbox my data has headers to tell the excel not to consider the first row as data.
- We can the numbers from smallest to largest and largest to smallest
- In case of non-numerical data, we can sort from A to Z, Z to A We can sort from
- Dates can be sorted from Oldest to Newest, Newest to oldest.
- We can add many layers to make the data alternation according to our wish.
- In case of sorting based on the cells color or font color, we can sort only once color at a time. I would suggest you use it if required.
This has been a guide to Sort by Number in Excel. Here we discuss how to Sort by Number in Excel using practical examples and a downloadable template. You may learn more about excel from the following articles –