How to Put Numbers in Numerical Order in Excel
By Tricia Goss
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.
Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.