TNX Jim for the info; I will give it a try, but would like to be clear
about how to compose the required reference string and about where to
properly locate the drop-down selection list . I will first try with
the selection list definition being located on a sheet within the same
workbook. I could name that sheet "Selection Lists" and write a
reference string to that. I have not ever tried to write a reference
string to a sheet that is located within a separate Workbook file, and
do not know if that is possible to work.
At this point, my selection list must include the following that I plan
to do logic operations on from another sheet:
* With Vets '16
* With George '16
* During '16 BVL Practice
* During '16 BVL Competition
* '16 Practice Alone
Those choices are associated with a Workbook where I record my bowling
scores and George's bowling scores, such as they are! In some cases I
bowl a 3-game series whereas in other cases I bowl a 5-game match, and
yet when practicing alone, any number of games may be bowled!.
Regards,
VinceB.
On 2/11/2016 12:18 PM, James Plante wrote:
First, create the choices that you want to have in the dropdown list: In a
blank spreadsheet,
Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s say
you do six entries, D1:D6.
Now, select the cell at which you want to make the dropdown list. Let’s use A2.
Now go to
Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt,
click the dropdown box and select “Cell Range.” The dialog changes.
On the right of the “cell range” box, select the “shrink” button. Now in the
spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once
again the dialog changes. The selected range of inputs is now $Sheet1.$D$1:$D$6.
Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when it
is selected—and only when selected! Click the arrow, and you can choose any of
the six entries you made in D1:D6.
There are other options available in the dialog. Explore them. You can use
numbers, text, or formulas that give rise to arrays. Read the docs to find out
more about it. (Google is your buddy.)
For instance, if you had a bunch of different cells in which you wanted to
control or expedite data entry, you could put all the selections in different
areas on Sheet2. Then when it’s time to select your cell range, shrink the
dialog, change sheets, select the desired range, hit shrink again, and the
dialog would show something like “$Sheet2.$F$10:$F$15”, and those choices would
populate your target cell.
Jim Plante
On Feb 11, 2016, at 10:56 AM, Vince <[email protected]> wrote:
Hello:
Using AOO 4.1.2 on WIN 8.1.
I do not know the correct terminology for searching in HELP file, but I want to
have a drop down selection list, with a clickable arrowhead, inside a Calc
cell. How can this be done?
Regards,
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
