Link to a Location Within the Spreadsheet in Excel

Add to Favorites

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.

  1. Right-click the cell where you want the link to appear and click Hyperlink.
  2. A window will open; make sure to click the link on the left that says Place in This Document.
  3. Now we can fill-out this window. In the top of the window input the text that you want the user to see in Excel.
  4. Select the sheet in the workbook that contains the data to which you want to link, or the Defined Name, if those exist for your spreadsheet.
  5. Type the cell that you want to be visible and selected on the worksheet.
  6. If you want, you can click the ScreenTip... button in the upper right of the window and add text that will appear when the user hovers over the link.
    When you are finished, hit OK and that's it.

If you click the link, it will take you to the worksheet Data 1 and make cell A15 visible and selected like this:

Change the Link

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.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Display the Print Window in Excel
Macro: This free Excel macro displays the print window or dialog box in Excel. This is the s...
Print Entire Workbook in Excel
Macro: This free excel macro allows you to print the entire workbook in Excel. You can easil...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Remove Gridlines in Excel 2007 and Later
Tutorial: In Excel 2007 and later you can quickly remove the gridlines that appear within the Excel ...
Quickly Find All Comments in a Spreadsheet in Excel
Tutorial: In Excel, you can create a comment for any cell in the worksheet. The problem is that th...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...