How to Put Numbers in Numerical Order in Excel

By Tricia Goss

Use Excel to quickly put any list into numerical order.
i Brand X Pictures/Brand X Pictures/Getty Images

Excel is a powerful application for presenting data, as it offers tools and features that allow you to format and display numbers and text precisely the way you want. If you have a column listing numbers, you can use Excel's sorting feature to place them in numerical order almost instantly. You can use the feature to sort an entire table based on a numerical column, as well.

Click on any cell in the column you want to sort.

Select the "Data" tab.

Click the "AZ" button in the Sort group to put numbers in order from smallest to largest or click "ZA" to order them from largest to smallest.


Information in this article applies to Excel 2013. It may vary slightly or significantly with other versions or products.