How to Sort Number ID in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Sort Number ID in Excel



In this tutorial, you will learn completely about how to sort number ID in excel.

We often have number IDs in one of the columns in our data tables in excel. They become the unique identifications for each of our data entries. We can easily know the number of our data entries too if we look at their column.

Sometimes, we need to sort our number ID column so our data table looks much more organized. There are several methods to do it depending on our preference and needs in our data processing.

Want to master the methods to do the sorting? Read all the parts of this tutorial!







How to Sort Number ID in Excel 1: Sort & Filter

To sort data in excel, we can activate the sort & filter feature in our data table headers. Using this feature, we can sort our number ID column and its related data entries easily!

Want to know how to utilize this feature? Follow the steps below.

  1. Place your cell cursor anywhere within the data table where you want to sort based on its number ID column

    How to Sort Number ID in Excel - Screenshot of Step 1 of Using Sort & Filter to Sort Number ID in Excel

  2. Go to the Home tab, click the Sort & Filter dropdown, and choose Filter (or go to the Data tab and choose Filter). You can also press Ctrl + Shift + L (Command + Shift + F on Mac) as a shortcut

    How to Sort Number ID in Excel - Screenshot of Step 2 of Using Sort & Filter to Sort Number ID in Excel

  3. There will be white boxes with down arrows show up on your data table headers. Click the white box on your number ID column

    How to Sort Number ID in Excel - Screenshot of Step 3 of Using Sort & Filter to Sort Number ID in Excel

  4. Choose Sort Ascending (or Sort Descending if you want to sort the number ID column from the largest to the smallest number)

    How to Sort Number ID in Excel - Screenshot of Step 4 of Using Sort & Filter to Sort Number ID in Excel

  5. Done! You have sorted your data table based on the ascending order of your number IDs! If you want to remove the filter button on your headers, just redo step 2

    How to Sort Number ID in Excel - Screenshot of Step 5 of Using Sort & Filter to Sort Number ID in Excel




How to Sort Number ID in Excel 2: Right-Click

Besides using the filter buttons in your data table headers, you can also use this right-click method to sort directly. This method may be the fastest way to sort your data table based on its number ID column.

The steps to do this method are below.

  1. Right-click within your number ID column, highlight Sort, and choose Sort Smallest to Largest (or place your cell cursor within your number ID column. Then, go to the Home/Data tab and choose Sort Smallest to Largest). You can also choose Sort Largest to Smallest if that is what you need.

    How to Sort Number ID in Excel - Screenshot of Step 2 of Using Right-Click to Sort Number ID in Excel

  2. Done! You have sorted your data table based on the order of your number IDs!

    How to Sort Number ID in Excel - Screenshot of Step 2 of Using Right-Click to Sort Number ID in Excel



XLTools Banner Ads



How to Sort Number ID in Excel for the Only the Number ID Column

What if we only want to sort the number ID column in our data table and not the other columns? Can we do that?

The answer is yes, we can. Follow these steps for the method implementation.

  1. Highlight the whole number ID column you want to sort

    How to Sort Number ID in Excel - Screenshot of Step 1 of Sorting Only the Number ID Column in a Data Table in Excel

  2. Right-click on the highlighted cells, highlight Sort, and choose Sort Smallest to Largest (or go to the Home/Data tab and choose Sort Smallest to Largest). You can also choose Sort Largest to Smallest if that is the sorting process you nee

    How to Sort Number ID in Excel - Screenshot of Step 2 of Sorting Only the Number ID Column in a Data Table in Excel

  3. On the dialog box that shows up, choose Continue with the Current Selection. Then, click Sort

    How to Sort Number ID in Excel - Screenshot of Step 3 of Sorting Only the Number ID Column in a Data Table in Excel

  4. Done! You have sorted only the number ID column in your data table!

    How to Sort Number ID in Excel - Screenshot of Step 4 of Sorting Only the Number ID Column in a Data Table in Excel




Exercise

After you have learned the methods to sort number ID in excel, now let’s do an exercise! You can deepen your understanding of the tutorial topic by doing it.

Download the exercise file and do the instructions. Download the answer key file if you have done the exercise and want to check your answer.

Link to the exercise file:
Download here

Instructions

Do each instruction number in its appropriate sheet (1 = Sheet1, 2 = Sheet2, 3 = Sheet3)
  1. Sort the data entries in the data table based on the number ID column! Use the Sort & Filter method!
  2. Sort the data entries in the data table based on the number ID column! Sort the number ID column in descending order and use the right-click method!
  3. Sort only the number ID column!


Link to the answer key file:
Download here



Additional Note

Be careful if your number ID column has blank cells in it. You may not sort your data table properly because of that.

XLTools Banner Ads

Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert