How to Create a Sortable Column in an Excel Workbook
- Open an Excel workbook or create a new one.
- Highlight the column you wish to sort.
- Click the Filter icon under the Sort & Filter heading. ...
- Click the arrow to sort the data how you'd like -- smallest to largest, or vice versa -- and press OK.
How do you make multiple columns sortable in Excel?
Multi-Level Sorting Using Sort Icons
- Select the column that you want to be sorted last (in this case, select the Sales data first – C1:C13).
- Click on the Data tab.
- In the Sort and Filter group, click on the Z to A sorting icon. ...
- The above step would make a Sort Warning dialog box pop-up. ...
- Click Sort.
How do I create a sortable list in Excel?
Follow these steps:
- Select the columns to sort. ...
- In the ribbon, click Data > Sort.
- In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort. ...
- From the Order drop-down, select Custom List.
- In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.
