I have two sheets in one google sheets document. One is a project log with project details and the other is a customer list. I have linked the customer cell to the cell with their project. When I add new customers the cells change but link stays to the same cell. Is there a way to get the link to change cells with the customer location without having to relink?


1 Answer 1


One workaround is to create a named range for each customer. Then Insert > Link that points to that named range.

Alternatively, use the name box in the upper left-hand corner of the spreadsheet window, right next to the formula bar, to quickly jump to a named range. You can open the name box by pressing Control+J.

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.