2

I'd like to be able to click on some text in a cell that automatically moves the insertion point to a specified cell or row.

So ideally I could have a cell (or some text in a cell) say: ["see row 199"], and when I click on it, it moves me to row 199.

How do I do this in excel?

1
  • Create a hyperlink but instead of linking to a webpage, link to the desired cell. See Source
    – An Dorfer
    Jul 25, 2014 at 15:28

1 Answer 1

4

Use Insert > Hyperlink, then select 'Place in This Document' and enter the cell reference you want to link to.

enter image description here

enter image description here

3
  • This worked well, but is there a way I can have the insertion point at the top of my screen? Its highlighting my cell and navigates to it, but its towards the bottom of my screen.
    – Nebur
    Jul 25, 2014 at 15:32
  • @Nebur Unfortunately I don't think there is a simple solution using just hyperlinks, but it might be possible using a macro
    – Cocowalla
    Jul 25, 2014 at 18:06
  • This is easy with VBA: "Range("A1").Show" The downside is that you'd also have to code the hyperlink functionality. Jul 26, 2014 at 5:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .