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".