To create a custom sort: Select a cell in the column you want to sort by. ... Select the Data tab, then click the Sort command. ... The Sort dialog box will appear. ... The Custom Lists dialog box will appear. ... Type the items in the desired custom order in the List entries: box. ... Click Add to save the new sort order.
Click the “ Data” tab and locate the “ Sort & Filter” section. Click the “ Filter” button. Note that each header will have a small drop down arrow to the right of the cell. Click the top of a column that you want to sort and use the appropriate “ Sort” buttons from the Sort & Filter section.
Create your own custom list In a column of a worksheet, type the values to sort by, in the order you want them, from top to bottom. For example: Select the cells in that list, and then click File > Options > Advanced. Under General, click Edit Custom Lists. In the Custom Lists box, click Import.
To make a custom list to use in fills, follow these steps: Choose Excel→ Preferences from the menu bar. In the Formulas and Lists section, click Custom Lists. ... Select New List in the Custom Lists list. In the List Entries list, type the series entries in order. ... Click the Add button when the list is complete.
Select File→ Options→ Advanced ( Alt+ FTA) and then scroll down and click the Edit Custom Lists button located in the General section. The Custom Lists dialog box opens with its Custom Lists tab, where you now should check the accuracy of the cell range listed in the Import List from Cells text box.
To filter data: Begin with a worksheet that identifies each column using a header row. ... Select the Data tab, then locate the Sort & Filter group. Click the Filter command. ... Drop-down arrows will appear in the header of each column. Click the drop-down arrow for the column you want to filter. ... The Filter menu appears.