Inserting a drop-down menu into an OpenOffice Calc Spreadsheet
This is an example of inserting a drop-down (pull-down) menu into a OpenOffice Calc spreadsheet that references a table.
Step 1: Open OpenOffice Calc and click on View / Toolbars / Form Controls. Should look something like this:
Step 2: In our example, let's create a table like the one pictured below.
Step 3: From the Forms menu, click on the List Box icon.
Step 4: Position the List Box (Pull down men) somewhere on your spreadsheet. Right click on that position (with the little green boxes) and click on Control...
Step 5: In the "Properties: List Box" dialog box, click on the "Data" tab. In our example, we're going to use A10 as or Linked cell, "Position of the selected..." as our "contents of the linked cell... and B2:B4 (see step 2) as our "Source cell range" as illustrated below:
Next, click on the "General" tab an make sure that you have "Yes" selected in the "dropdown" field as follows:
Step 6: The a Cell link in the Cell Link box -- in our example we're going to use cell A10 (see illustration below):
Step 7: Next, we're going to insert a Vlookup function in cell B10 as shown below:
Step 8: That's it! We've created a spreadsheet with a pull down menu. In our example, we should now be able to use the pull down menu to find the weather on a particular date.
See also: How to create a drop down menu in a Microsoft Excel Spreadsheet