How to Sort a Column with Numbers from Smallest to Largest

Please follow the steps below to sort a column with numbers from smallest to largest, or check sort a column from largest to smallest.

Step 1: Click any cell in the column you want to sort;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort&Filter" in the "Editing" section, and click "Sort Smallest to Largest" from the drop-down list;

Step 4: The column is now from smallest to largest;

Step 5: Alternatively, right click and select "Sort" from the list; then select "Sort Smallest to Largest".

Leave a Reply