In various cases, you may find it useful to be able to add drop-down lists to Excel cells, and in today’s article we will look at how to do this.
1.Open an Excel spreadsheet in which you want to make drop-down list cells. The list of values for the drop-down list must first be written somewhere, you can write it on the same sheet, but far below, or create an additional sheet (as we do in our example) and write the values there to create the drop-down list. Click on the “+” at the bottom to add another sheet.
2.Open the created sheet (by clicking on it with the left mouse button) => anywhere in the column, we begin to enter the values that will be needed in the list. For example, in the first column, starting from the first row (you can do it in any column and starting from any row), enter the required values in each cell (which will be displayed in the drop-down list).
3.When you have entered all the values, select the cells with the data (using the mouse or holding the shift key and moving the arrows in the required direction). When the cells with data are selected – above, enter a name for the range of selected cells and press Enter (see figure). In our example, we write the name “Price” and press Enter.
4.Open the sheet and select the cell where you want to add a drop-down list => on the top panel select “Data” => open the left mouse button “Data Validation”.
5.In the field “Data type” from the drop-down list select “List”
6.Uncheck “Ignore blank cells” and in the “Source” field write = and the name you assigned to the range of cells in the 3rd clause. In this example, we assigned the name “Price” to the range of cells, therefore, in the “Source” field, we need to write = Price
7. Go to the tab “Messages for input”, here you can write a message that will be displayed when you select a cell with a list. After entering the desired message, click “OK”.
Now if you select the cell for which you created the drop-down list, then to the right of it you will see an arrow, also if you are in 7th the item set a message – it will be displayed below. The arrow and message will only be displayed when a cell is selected.
By clicking on the arrow next to the cell, you will see the list that you created in the 2nd paragraph and you will be able to select the one you want.
If in the future you need to remove the drop-down list from a cell: select the cell with the drop-down list => on the top panel select “Data” => open the left mouse button “Data Check” (described and the image was in the 4th paragraph).
Left-click on “Clear All”.
Click “Ok”.
Using the instructions above, you can create various drop-down lists and add them to the desired cells. That’s all for today, if you have any additions – write comments! Good luck ?
