In the Type the Cell Reference field, enter A1.Change the Text to Display field, as desired.Make sure that the Place In This Document option is selected at the left of the dialog box.Excel displays the Insert Hyperlink dialog box. Click on the Hyperlink tool in the Links group.Select the cell in which you want the hyperlink inserted.Of course, it is possible that Bob created his hyperlink using the Hyperlink tool, in this manner: =HYPERLINK("'Sheet 2'!A2","Jump To Cell A1 in Sheet2") If you prefer, you could also use a full worksheet designation, in this manner: =HYPERLINK("#Sheet2!A1","Jump To Cell A1 in Sheet2") If this is how the link was created, then all you need to do is make sure that you include the cell reference in the actual link destination, in this manner: It is possible, for instance, to create a hyperlink using the HYPERLINK worksheet function. The answer depends on how, exactly, Bob created the hyperlink. Bob wonders how to correct this behavior. He's got the hyperlink set up, but when he clicks it, he is taken to the last-used cell on Sheet2 instead of to cell A1. Bob wants to use a hyperlink to move from Sheet1 to cell A1 on Sheet2.
0 Comments
Leave a Reply. |