When working in Excel, you may want (or need) to create a drop-down list to make it easier and faster to select data from a pre-created set of items — so you can just select them instead of having to type them in. This week’s tip will show you how to create a drop-down list in Excel.
To create a drop-down list:
- Enter the data for the pre-selected list. In this example, I’m entering the data in A1, A2, A3, and A4.
- Click the cell in which you want the drop-down list to be displayed. In this example, I’m using cell D1.
- Click the Data tab. Then, in Data Tools, click Data Validation.
- In the Settings tab, in Allow, select List.
- In Source, enter the cells with the data you entered in step 1, and then click OK.
A drop-down arrow now appears in the cell you chose in step 2 (in my case, D1). Clicking the arrow on the list displays the data pieces, and you can now select one of them.
Next week, we’ll show you how you can create a list in Excel, but this time with data that is stored on a different worksheet!