In Calc, when I type a cell entry that is similar to one in the column above it, it suggests an autocompletion which I can accept with the enter key.

If there are several similar entries above it, is there a way to get a drop-down list to chose an alternative?

For example in cell a1,to a3, Smith, Tom; Smith, Dick; and Smith Harry. Then in cell a4 I key in an "S" then I get the suggestion to autocomplete as "Smith, Dick". What I woould like to have is a drop-down list where I can choose "Smith, Tom" or "Smith, Harry."

Using OxygenOffice 2.3.1 on WinXP.

Thank you one and all.

Joe Conner,
Poulsbo, WA

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to