How to make a drop down list in OpenOffice/LibreOffice Calc

Visit us on facebook:

[sabrinasuyana]

I my gosh...I looked over sooo many tutorials on how to do this and none worked. This worked right away, thank you!

[tomasgwynbleidd]

I found this problem as well trying your method - there's a way around it, I found it on the techrepublic article about Libre Calc and drop down lists.
Use the second approach - write the options you want to use on a new sheet within the Calc doc.
Define this as a cell range by going to Data -> Define Range.
Then instead of selecting List in Data -> Validity choose Cell Range (naming the range just created).
Hope this helps.

[meo]

Thank You for keeping it short and to the point!

[morganucopia]

I didn't know you could use drop downs in Calc! I just spent hours bashing my head against the wall trying to create what I needed in Base (I'm not a database programmer). Spreadsheets I understand; and this technique is EXACTLY what I needed in the first place.

[renuodontomedic]

Perfect presentation, concise, objective and extremely helpful! Thanks!!!

[dennisdaniels]

Short, sweet, simple, useful! Thank you!

[thriller]

thank you so much for this tutorial. Simple and to the point. will be checking out the rest of your Channel, the way you teach makes sense

[sheetalparekar]

Short and Sweet and useful video. Thanks for creating it.

[Cthemotorcyclist]

Thanks for that!

Just a question...can I link other cells to the dropdown list?  So, if I want to add a value to how many "green" "eggs" people like, then can you do this?

[XziledBlog]

This is funny, I needed this, but I entered this video accidentaly lol
Thanks a lot!

[osmarribeiro]

Yes, tks still help in 2020. you gain a new subscription.

[Shawass]

this was very helpful, thank you for making the tutorial :)

[marlonreiscalado]

Great! Simple and usefull! Thanks from Brazil!

[Snoopsuk]

Could be, I have the same version (the latest).

Thanks for confirming my problem.

Will you be letting them know about it?

[error-unfo]

Look at that 7 years old and still Relevant. Thanks :)

[patrickbryson]

Very useful! Helped me with my project. Thank You Very Much!!

[Gidjoiner]

Hi, thanks for the vid, do you know what the keyboard shortcut is to open the drop down menu? in excel its Alt+down arrow but doesn't work in open office.

[scabilos]

"Just in case we have a really strange chicken"
Btw, this still works in 2024, in LibreOffice 7.5

[TheCocoaDaddy]

Great! This is just what I was looking for! Does anyone know if this will export to an Excel file format ok? Thanks!

[artistra]

could you do a video on how to influence what appears when you select something in the drop box? e.g. when you select horror in a book genre drop list and only horror books show along the side.