How to sort the selection so that the lowest values will be at top of the column and expand it for all the table. Select the Column you want to order by. Click the Home tab then click Sort and Filter then click Sort A to Z. Check Expand the selection and click Sort.
Step 1: Select the Column you want to order by.
Step 2: Click the Home tab > click Sort & Filter > click Sort A to Z.
Step 3: Check Expand the selection > click Sort.