How to Sort Range based on the Number Column

You may need to sort part of a data range when working with Excel. For example, to sort only the last 3 rows of the data range based on numbers. Please see below for details:

Step 1: Select the data range that you want to sort;

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

Step 3: Click the triangle after the "Sort & Filter" in the "Editing" section;

Step 4: Click "Custom Sort" from the drop-down list;

Step 5: In the "Sort" window,

1. Select the sort column in the first box (Column C in this example);

2. Select "Cell Values" in the second box;

3. Select "Smallest to Largest" in the third box.

Step 6: Click "OK" and the data will be in the order you want.

Leave a Reply