Reverse hyperlink

  • Thread starter Thread starter FP Novice
  • Start date Start date
F

FP Novice

I would like to create a cell where a user can enter a value (1 thru 4096),
the entered value will jump them to the corresponding row. Can this be done?

or should I simply create a worksheet that performs a lookup to another sheet?
 
I found it...just enter the cell you want to go to in the top left corner.

Sorry to bother...
 
In addition to the address box you can press the F5 Go To key and specify a
location or select from a list of named ranges.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top