LibreOffice: Create dropdown list - how it works

You can organize your data even better in LibreOffice using a drop-down list. In this article, we show you how to create such a list.

Create drop-down list with LibreOffice

1. In the LibreOffice Calc menu bar, click on "Data" and there on "Validity".
2. Now select the "List" under "Allow".
3. At this point activate the option "Show selection list".
4. Enter the contents of your dropdown list under "Entries". Start a new line for each entry.
5. When you confirm with "OK", LibreOffice creates your own dropdown list. Click the arrow on the drop-down list to select an entry.

In the next tip, read how to add new fonts using LibreOffice. This practical tip relates to LibreOffice 4.3.4.