create drop-down menu/list in spreadsheet column

[Ledgr]

Hello!

(Sorry if my English isn’t always correct)

I was wondering whether it is possible to create a spreadsheet (// Excel) with LibreOffice that gives a different drop-down menu with a limited amount of options (f.e. “reptile”, “fish”, “mammal”, “bird”, “insect”, “amphibian”…) per column?
So I could enter any data in one cell and in one beside that click on the relevant option in the list:

random | list

dolphin | mammal

monkey | mammal

spider | insect

How would I be able to create this menu/list?
Thank you!

Aferwards, I would like to save it as a csv file.

[anon73440385]

Hello,

• select a column (e.g. column A)
• Data -> Validity
• Select Tab Criteria
• Select in Dropdown Allow: List
• Add your allowed values in the Entries field
• Select your other options
• Click OK

Now proceed to the next column an repeat the procedure with a list of values valid for the new column.

Please note This answer assumes that there is no dependency between the values in the different columns (i.e. the values do not refer to each other in the sense of some categorization). If your question was meant in the sense: If I select item A on column A then item B in column B should be added, then this answer is not for you)

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.