How to make a drop-down list in the Excel program

When working with tables in excel 2007 program will be useful to know how to create drop-down lists.This is especially useful if you have to constantly work with the same data, and make them in the table takes up too much time.

So, give detailed instructions with illustrations on how to create and delete drop-down list to Excel.There are several ways.

first method

Suppose that you need to organize books by Russian writers and allow the user to choose the desired poster.To do this, create a special menu to their names in one of the cells.

To list was available not only on the sheet, but also on the whole document, just create it that way.To do this, you must assign it a name.Select the information in the second column, in which is a list of authors, click on the right mouse button to display the special menu and there click on "name range".

How to make a drop-down list in the Excel program

window opens, where the "Name" write the word "authors" (so in this case, you can give any name, depending on their needs) and click OK.

How to make a drop-down list in the Excel program

If over time it will be necessary to replace the name, and it can be done this way: select the cell, and by the text of the document can see the names of the cell line.There, and you can change the name.

How to make a drop-down list in the Excel program

Now create himself drop-down list.Click on the desired cell.At the top of the screen is the "Data" tab, and in it - the command "Data Validation".Opening the box, you will see the string "data type."In it, and choose the item "List".

How to make a drop-down list in the Excel program How to make a drop-down list in the Excel program

Below is the line "Source", and which need to enter the name of the drop-down menu, in our case, the "authors".

How to make a drop-down list in the Excel program

confirming the change by pressing OK.Check out their works, you can immediately set up in the table.

second way

drop-down menu in Excel, and you can create a list below the input values.But in this case, it will be disclosed only in one cell, rather than all the others will be empty.

Select desired, and press the key combination «Alt + I» and the data appears under the pull-down menu.

How to make a drop-down list in the Excel program

third way

Open the tab "Developer" or click on the icon.In the popup window How to make a drop-down list in the Excel program need to select "Settings Excel» and put a tick in front:

How to make a drop-down list in the Excel program

Then you need to click on "Insert" and select the icon drop-down list.The process looks like so:

How to make a drop-down list in the Excel program

Now you need to create the list itself.Use mouse to click on the icon and make a rectangle of any size, and then click the right mouse button and select the menu item "Format object."

window appears in which you you can determine the exact parameters of the future drop-down list:

Removal drop-down list

  • «create a list of the range" Select the cells that will be displayed in the list;
  • «Cell link" if necessary, you can specify the number of the cell in which to display the selected item from the list;
  • «The number of rows in the list" can be set independently, and you can leave the default eight.

To delete the list should perform these actions:

Additional information

  1. Click on the "Data" tab and select the "Data Validation".
  2. In the resulting dialog box, click on the tab "Settings" and then click "Clear All".

to when opening a drop-down list does not lose data, you need to adjust the width of the cell in which it is created.Maximum number of items in the drop-down list - 32767.

Comment