Make sure all of the check boxes are selected before you continue. You should enter these choices one entry per line.įigure B I’m creating a drop-down for hardware that can be used within my spreadsheet.Ĥ. In the text area, enter the choices that will be displayed in the drop-down list ( Figure B). Once this new window opens, select List from the Allow drop-down ( Figure A).įigure A There are multiple ways of getting the data needed for the drop-down.ģ. Open the Data Validity tool by going to Data | Validity. Open the spreadsheet you want to add the drop down to and select the cell where you want the drop-down to be placed.Ģ.
One of the things you can do with Calc’s Data Validity tool is create drop-down lists by following these steps.ġ.
If you want to be a LibreOffice Calc power user, you should follow my step-by-step tutorial on two possible ways to add drop-down lists to the program for faster spreadsheet creation and easier data entry. The addition of drop-down lists can make your LibreOffice Calc spreadsheets more flexible and powerful. DIY: Add drop-down lists to LibreOffice spreadsheets
0 kommentar(er)
