How it works
The link cells function allows us to cross-reference two cells in the same workbook. The link cells function will give us a reference number that points to the other side of that cross-reference the reference number will also be hyperlinked which means we can easily click on that and jump back and forth between our two working papers.
How to use it:
Step 1
With the cell that you’d like to reference selected. In the more drop-down of the Ticking and Bashing group, navigate to lick cells.
A new pop-up window will be displayed.
Step 2
Select the other cell that you would like to link to.
Then click OK.
Step 3
Upon completion, a link will appear next to each cell. When clicking on the link, it will move the user to the linked cell.
Note: These links are moveable and customisable, by holding alt when clicking on the link it will turn into an excel object that can be customised.
