Ask Your Question

Hyperlinks in drop down list

asked 2018-08-09 03:02:31 +0200

antonito gravatar image

Hi, I am classifying my photos. The list is very long: places, birthdays, sunsets, and a long etc. I would like to create a drop down list with hyperlinks such that whenever I choose an item it takes me to the row that contains detailed information. Is it possible? Thanks :)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-09 09:27:50 +0200

JBF gravatar image

updated 2018-08-09 09:29:08 +0200

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.

edit flag offensive delete link more


Not working. I'm using this: $nameOfSheet.$b$4:$b$200 in Data --> Validity ---> Cell Range Do I need to add/modify something? Yes, I'm using Calc, Thanks :)

antonito gravatar imageantonito ( 2018-08-09 15:59:49 +0200 )edit

it is hard to say without a test file.

JBF gravatar imageJBF ( 2018-08-09 19:28:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-09 03:02:31 +0200

Seen: 20 times

Last updated: Aug 09