The drop-down should now be available to the cell selected.

In the Allow drop-down, select Cell Range and then type the name of the Cell Range you defined above (in this case Hardware). Go back to the original sheet and go to Data | Validity.ĥ. When the new window pops up, enter a descriptive name (such as Hardware) in the text box ( Figure E).įigure E When you enter the name, the cell range should appear. First, highlight the cells with the new data you just created and then go to Data | Define Range. Now we need to create a name for the range of cells.

On a separate sheet, create the list of items you want to use for the drop-down list ( Figure D).įigure D We’re creating the same drop-down we did with the first method.Ģ. Also, this option is the more flexible method.ġ. This alternative is as simple as the first approach, though it does require an extra step. If you want to edit the contents of that drop-box, you have to go back into the Data | Validity tool and edit the list manually. You can copy and paste this drop-down list throughout your spreadsheet as needed. Your drop-down list should be available in the cell you selected before you began the creation process ( Figure C).įigure C These entries should look familiar - we just created them. 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

Libre excel