Calc - combobox in a cell?

users
#1

Hello,

is it possible in Libreoffice Calc 4.2.6.3
Build az.: 4.2.6.3 Arch Linux build-4

to get in a cell a drop-down list or listbox - combobox with a few values
that one can select?

#2

Hi,

is it possible in Libreoffice Calc 4.2.6.3
Build az.: 4.2.6.3 Arch Linux build-4

to get in a cell a drop-down list or listbox - combobox with a few values
that one can select?

Data > Validity, then for the Allow option select either List or Cell range.
List: enter the items you want displayed
Range: enter the wanted items list in a cell range on any sheet, the
select this range. You may use named ranges as well.

HTH,