![]() ![]() 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 Comments
Leave a Reply. |