How to Add Drop Down to Open Office Calc

You can use drop down lists in OpenOffice Calc

OpenOffice Calc is a free spreadsheet program much like Microsoft Excel. Newcomers to the program find it easy to use, and it has many advanced functions for more experienced users. OpenOffice Calc provides tools that allow you to create a drop down list. You can create a drop down list that people can add to or only allow people to use the list as is.

Instructions

1. Open OpenOffice Calc by clicking the icon on the desktop or through the Start menu.

2. Click in the cell field where you want to add the drop down list. Click "Data" at the top of the screen and select "Validity". Click the "Criteria" tab. Select "List" from the drop down menu.

3. Check the "Show Selection List" option. Check the "Sort Entries Ascending" option if you want to be able to sort the list.

4. Type the items you want in the list in the "Entries" section. Press "Enter" after each item to go to the next line. When you are finished, click "OK". The list will display in the cell field that you selected. At this point, people will be able to add items to the list. If you don't want people to have the ability to add to the list click "Data" and "Validity". Click the "Error Alert" tab. Select the "Show Error Message" checkbox. Select "Stop" for the error type. In the "Error Message" section, type the error message that people will see when they try to add something to the list and click "OK".

References

• OpenOffice Calc: The all-purpose spreadsheet