OpenOffice Calc drop down list | Tutorial

OpenOffice Calc drop down list

OpenOffice Calc drop down list

No matter whether Microsoft Office or Open Office – with a tool for data processing like Excel or Calc, forms can be created that can also be used by other people in a very good and uncomplicated way. But they are not always sure which data should be entered. Therefore, we show you to create an OpenOffice Calc drop down list and thus get a good overview of the available options in advance. This way there will be no misunderstandings when filling out your Open Office Calc documents.

Control user behavior with the right error message:

In addition to the dropdown, you can also specify how to handle deviating values thanks to error messages. For example, a kind of info is available, which also allows different values. If necessary, different inputs can also be prevented completely by using the necessary “Stop” message. Don’t worry, the functions are well explained if you know where to look.

Step-by-step instructions:

  • Select all cells that should get a dropdown menu
  • Click on the “Data” tab and select “Validity…”
  • Change the “Allow” item from “All values” to “List”
  • Make sure that “Show selection list” is activated in any case
  • Enter your desired values for the dropdown in “Entries”
  • In the tab “Input help” you can provide further information when a cell with dropdown is selected
  • In the tab “Error alert” you can set what should happen in case of wrong entries
  • Press “OK” at the end
  • Done!

In our opinion, the setting for the dropdown is not quite meaningful. The item “Validity” makes sense, but only if you know that the function is located there. Therefore we hope that we could save you a lengthy search. If you have any further questions, feel free to let us know on Youtube and we’ll produce more posts for you. And now good luck with your projects in OpenOffice Calc!


Video tutorial:

coming soon

Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!

Be the first to comment

Leave a Reply