Ask Your Question

create drop-down menu/list in spreadsheet column

asked 2019-12-04 14:55:43 +0100

Ledgr gravatar image


(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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-12-04 17:53:23 +0100

Opaque gravatar image

updated 2019-12-04 18:00:34 +0100


  • 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

image description

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-04 14:55:43 +0100

Seen: 20 times

Last updated: Dec 04