Create a drop-down list in a Microsoft Excel table

Microsoft Excel is a spreadsheet program. This program has wide capabilities and a large number of different functions. And not every user is fully familiar with all functions Microsoft Excel programs. Today we will talk about one of the functions of this program. We will consider the following question: how to create a drop-down list in a Microsoft Excel table?

The drop-down list is convenient when there are a lot of values ​​in a certain Microsoft Excel column. In order not to “run” through the entire document, it is convenient to use the drop-down list.

So you're in a Microsoft Excel spreadsheet and you have a column of values. First of all, give this column a title. Now select the cell in which the drop-down list should be located. In our case, this will be the cell labeled "January".

Next you need to go to the "tab"Data"and here you need to click on the item"Data validation".

After this, a new window will open in which you will need to perform a number of actions. In line "Data type"you must select an item"List", and then you will need to click on the button that is located with the item "Source".

Now you need to select the values ​​that will be in the drop-down list. To do this, move the mouse cursor to the top border of the column and click on it. As a result, in the window"Validation of entered values"You should see the name of your column. This is shown more clearly in the screenshot.

After you complete the steps written above, a window will appear in which you will need to click the "OK". As a result, you should have a drop-down list like this.

Dropdown list is a very convenient tool in a table Microsoft Office. And you will learn how to do it in this article.