I used VBA to generate a hyperlink in a cell in Workbook1 that links to another cell in Workbook2. I can confirm that the hyperlink "bookmark" bug mentioned in this thread exists in Excel 2016. The way you can figure out if you were bitten by the bug is to make sure that your version of Excel is up-to-date. There are reports that some versions of Excel (minor versions, mind you, not major versions) have this bug. If you ensure that the Type the Cell Reference field is set to A1 and the hyperlink still doesn't take you to that cell, it is possible that you are encountering an Excel bug. If that is the case, the solution is to go back and edit the hyperlink (right-click the hyperlink and choose Edit Hyperlink from the Context menu) so that A1 is in the field. It is possible, in Bob's situation, that the Type the Cell Reference field (step 6) is set to some other value or it is blank. The resulting hyperlink will jump to cell A1 on the designated worksheet. In the area at the bottom of the dialog box, click on the worksheet you want to use as the target of the hyperlink.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") #Creating hyperlinks in excel tab full#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. #Creating hyperlinks in excel tab how to#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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |