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 the Drop Down List Select the cells where you want the drop down lists. Choose Data> Validation. In the Allow box, choose List. In the Source box, type the list name, preceded by an equal sign, e.g.: = MyList. Click OK.
To add this drop-down list to a sheet, do the following: Create the list in cells A1: A4. ... Select cell E3. ... Choose Validation from the Data menu. Choose List from the Allow option's drop-down list. ... Click the Source control and drag to highlight the cells A1: A4. ... Make sure the In- Cell Dropdown option is checked. ... Click OK.
Create a Drop- Down List for a Cell or Range Choose Data Validation from the Data Tools group on the Data tab. Select the Settings tab. In the Allow box, select List. Click the Source box. Type in a list of values separated by a comma. Make sure the In-cell dropdown box is checked. Click OK.
3. Create the Drop Down List Select the cells in which you want the drop down list. On the Ribbon's Data tab, click Data Validation. From the Allow drop-down list, choose List. Click in the Source box, and type an equal sign, and the list name, for example: ... Click OK to close the Data Validation dialog box.