Selection list

users
#1

Hi!

How to edit selection list in the LibreOffice Calc cell
which contains previously entered values by the right mouse button.

Mic

#2

What's the question?

#3

o Go to Data | Validity | Criteria.
o If Allow is set to List, edit the values in the Entries box.
o If Allow is set to "Cell range", observe the range specified at Source. Either change the range or visit it and modify the values there.
o If Allow is set to "All values", the selection list is being automatically populated from the current column and cannot be changed, I think - except by removing values from elsewhere in the column.

I trust this helps.

Brian Barker