On 13 Dec 2007 at 15:22, Dotan Cohen wrote: > Can Calc be configured to have a dropdown box or pre-choosen options > in a specific column? For instance, in every new row I'd like Column C > to present the user with the choice [bank1|bank2|bank3]. I know that > this is stepping on Base's territory, but this user will _not_ learn > to use base and she needs this. I have considered using Autocomplete, > but it interferes with other columns. If Autocomplete can be turned > on/off on a column-specific basis, then it would work. Thanks in > advance.
You might look at the menu option under Data | Validity, and pick Allow: list. The help files has an entry "validity of cell contents". -- http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
