Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can create a dropdown list in a cell (I assume you want do that in Calc) by using menu Data > Validity. Choose "Cell range" in Allow dropdown list in the Criteria tab.

Other points in your question depends on your creativity :-)

You can create a dropdown list in a cell (I assume you want do that in Calc) by using menu Data > Validity. Choose "Cell range" in Allow dropdown list in the Criteria tab.

Other points in your question depends on your creativity :-)

Edit: hyperlinks work better in Calc if you use the HYPERLINK function.