One of the things you can do with Calc’s Data Validity tool is create drop-down lists by following these steps. 1. Open the spreadsheet you want to add the drop down to and select the cell where ...