Hello Vince, Le 22/05/2022 à 17:49, Vince@Verizon a écrit :
[...]So, my goal is to edit the existing data w/o typos by use of drop down lists. It appears that I need to make use of Data>Validity>Criteria>Allow>Cell Range .... with dependent drop down(s).
yes, its possible. I do that on a regular basis. A tutorial has helped me very much.
If you can read French, this tutorial/demo is in this mailing list: https://forum.openoffice.org/fr/forum/ftopic22412-tout-sur-les-listes-deroulantes-sous-calc.html Look at the bottom (last message by Gerard24) and download the file: liste déroulante.ods You'll get all the secrets about dropdowns :) HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy