Excel cell drop-down list

Question

I have a simple Excel spreadsheet where in one column I write string values. I need to define some predefined values ​​and instead of entering the string select, this is from the dropdown list. For example, for the Store Name column, I want to select "Reebok", "Adidas", etc.

I understand that there can be several ways to implement this, even VBA. I am using Office 2007.

Please advice.

Answer 1

What I am doing is column A with all the values ​​in, select the cells that need a list (or do it with one, and drag the corner of the cell to the other cells), select Data-> Validation from the menu, on the “Settings” tab change the value of "Any value" to "List". Then click the button that appears next to the new input window.

Select cells in column A, then click the button again. Then click OK.

Then hide column A so you cannot see them (for display purposes only).

You don’t need to use column A, so you don’t have to worry about moving the list if your table spreads down or out.

Answer 2

TIP: this “column A” can be referenced from another sheet