I have a column on sheet2 where each cell has a hyperlink redirecting to cells of a column of sheet1.

I have manually gotten the "Link to this cell" and put in under hyperlink to be able to achieve the desired functionality. I understand that to access different cells I will just have to change the range.

I have created each of these links manually using the following format:

In Sheet2 A2: =HYPERLINK("https://docs.google.com/spreadsheets/d/********************************************/edit#gid=**********&range=A2", "Sheet1-A2")

Sheet2 A3: =HYPERLINK("https://docs.google.com/spreadsheets/d/********************************************/edit#gid=**********&range=A3", "Sheet1-A3")

I have a thousand rows in this sheet and so it becomes cumbersome to do this. Is it possible to do this using arrayformulas?

1 Answer 1


You need to wrap your formula with an Arrayformula and generate as many rows as column A in Sheet1 has a value in it:

, "Sheet1-A" & row(A2:A)),""))


enter image description here


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.