How to sort rows by numbers in column in Excel

Sorting data in Excel is a powerful feature that allows you to organize and arrange your data in a specific order. By following the steps mentioned in this article, you can easily sort your data based on various criteria such as text, numbers, dates and times, or even custom lists or formats.

Sorting data in Excel is a useful feature that allows you to organize and arrange your data in a specific order. Whether you want to sort a list of names alphabetically, arrange inventory levels from highest to lowest, or order rows based on colors or icons, sorting can help you visualize and understand your data better.

How to carry out the sorting

To sort rows by numbers in a column in Excel, follow these steps:

  1. Select the entire dataset, including the header row.
  2. Click the Data tab.
  3. Click the Sort icon.
  4. In the Sort dialog box, make sure My data has headers is selected. If your data doesn’t have headers, uncheck this.
  5. In the Sort dialog box, select the column you want to sort by.
  6. Under Sort On, choose Cell Values.
  7. Under Order, select Smallest to Largest or Largest to Smallest depending on your preference.
  8. Click OK to apply the sort.
More Information ℹ

Share your love
Gabby
Gabby

Inspiring readers to embrace the possibilities of the future while critically examining the impact of our present choices.

Newsletter Updates

Enter your email address below and subscribe to our newsletter

Say whats on your mind.

Videos You may like