Excel超链接到特定单元格 [英] Excel hyperlink to a specific cell

问题描述

我需要将一个电子表格中的单元格超链接到另一电子表格中的相应单元格. 因此，例如，sheet1中的C7有一个超链接，它将带您进入工作表2中的C7.我需要为相当大的电子表格执行此操作，并且每个超链接都必须不同.有没有一种方法可以批量执行此操作而不必转到每个单元格并分别为每个单元格设置超链接? (使用MS Office 2010)

I need to hyperlink a cell in one spreadsheet to a corresponding cell in another spreadsheet. So for example, C7 in sheet1 has a hyperlink that will bring you to C7 in sheet 2. I need to do this for a fairly large spreadsheet and each hyperlink has to be different. Is there a way to do this on mass without having to go to each cell and set the hyperlink for each cell independently? (Using MS Office 2010)

推荐答案

您可以使用以下excel公式:(粘贴到单元格C7中)

You can use the following excel formula: (paste into cell C7)

=HYPERLINK("[Book1.xlsx]Sheet2!"&CELL("address",C7),"click")

注意:

• [Book1.xlsx]必须是工作簿的名称
• Sheet2必须是您要超链接的工作表的名称

• [Book1.xlsx] must be the name of the workbook
• Sheet2 must nbe name name of the sheet you are hyperlinking to

基本上，它使用以上两个作为链接的前缀，然后使用当前单元格的地址(在您的示例中为c7)完成链接.

Essentially it uses the above two as a prefix to the link, and then the address of the current cell (c7 in the case of your example) to finish the link.

上面的示例一旦粘贴到单元格C7中，就可以向下拖动以根据公式单元格的地址生成链接.

The above example once pasted into cell C7 can be dragged down to generate links based on the formula cell's address.

更新 :(按克里斯)

=HYPERLINK("#'Sheet2'!"&CELL("address"),"click") 

这篇关于Excel超链接到特定单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！