How to make clickable links within Excel that point to other locations within the same spreadsheet.
This allows you to quickly navigate through large spreadsheets. You can create a title worksheet and include links from there to any other worksheet and specific cells within the worksheet.
If you click the link, it will take you to the worksheet Data 1 and make cell A15 visible and selected like this:
To change anything regarding the link, simply right-click over it and click Edit Hyperlink...
This is a very helpful feature to use when you have a big spreadsheet and you want users to be able to navigate through it with ease.
Download the sample workbook attached to this tutorial to see this in Excel.