I want to create a drop down list of links that lead to specific cells in the sheet

hello,

I'm new here.

been looking for a solution for this for a while now and thought id ask for it.

i created a form in excel to help speed up my work flow. there are 20 segments in the form. eg: 01, 02, 03....20.

to avoid excessive scrolling up and down to navigate between segments, im looking to add a drop down menu on the top (3 frozen rows).

is there a way to create links that lead to specific cells within the sheet via a drop down menu?

thanks

Originally Posted by JeteMc

Hello RK10000 and Welcome to Excel Forum.
Perhaps the information in the linked tutorial below will help.

To get specific help with your worksheet we would probably need to see a sample. See the banner at the top of the page for directions posting an Excel sheet.
Let us know if you have any questions.

Thank you for sharing, i have already done the cell hyperlinks, but they dont work when i convert them into a drop down using data validation. im looking for a way to use a dropdown menu to jump to another cell.