[Solved] Multiple choices cell
[Solved] Multiple choices cell
Is it possible to assign a list of values to choose from when selecting a cell? say if I select C7, a menu pops up with a list of values to choose from for C7?
Last edited by Poneyx77 on Fri Sep 24, 2021 9:15 am, edited 1 time in total.
Openoffice 4.1.10 Windows 10
Re: Multiple choices cell
You can set that up with the menu item Data -> Validity. On the Criteria tab, set the Allow list to either List or Cell Range. If you pick List, enter the values you want in the Entries box, pressing the Enter key after each value. If you pick Cell Range, type the address of the cell range that holds the desired values into the Source box. For example, if you listed your desired values in Z1:Z7, enter that address in the Source box.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Multiple choices cell
Well thank you again dear FJCC, you're the best!
Openoffice 4.1.10 Windows 10