How to Create an Excel Jump to Cell Link

How to Create an Excel Jump to Cell Link

Last Updated on July 2, 2022

TheTechieSenior.com is reader supported. We may earn a commission if you buy through links on this site. As an Amazon Associate, we earn from qualifying purchases. Learn more here.

Last Updated on July 2, 2022

Complex Excel workbooks or sheets can become cumbersome to navigate. An Excel “jump to cell” link can make navigating those spreadsheets much easier. Keep reading to learn how to create a jump link in Excel.

We will be discussing jump to or jump links which allow you to navigate from one part of a workbook or worksheet to another by just clicking the link.

While those links are often called jump to links, Excel calls them Hyperlinks.

The instructions in this article are not about connecting the data between cells. Instead, we’ll be discussing only links that are used as navigation aids.

Note: The images used in this tutorial are from the Mac version of Excel 365. While they have a different look than the Windows version, both have the buttons, boxes, etc. that the instructions mention.

I have Excel files that I use to track the articles that I write, their topics, publication dates, and more. The worksheets are much wider than my 27 inch screen. That can cause me to do a lot of scrolling from side to side.

To make moving around in the worksheets easier, I set up column A as a navigation bar. In that column I listed the topics that I write about, one topic per row.

Those same topics are arranged in columns across the sheet. Each of them requires three wide columns to hold certain information pertaining to the topic.

In column A, each row resembles a button of a different color. I could have used shapes to create nicer buttons, but I chose the simplest method because I didn’t need them to be any more decorative.

The buttons were created by setting the fill color for each one as a different color. All have white text to make the buttons easy to read.

The first button links to the first column of the first topic. The second button links to the first column of the second topic, and so on until every topic has its own button in column A.

If I need to find some information about the topic that is stored in columns AF, AG, and AH, I click the button in column A that contains a jump link to that topic. I am immediately taken to column AF—the first column of the three taken by that topic.

Column A is frozen so that it is always visible when I scroll left and right. I’ve labeled the last button in that column as Home. I can click that Home button and be taken straight back to the first column in the worksheet.

It is easy to create jump links. To add a link to a cell so that it is clickable,

  1. Click in the cell where you’d like the jump link.
  2. Click the Insert tab.
  3. Click the Link button.
    insert link button microsoft excel
    The Link button in the Microsoft Excel Insert tab.
  4. In the first box in the Link settings panel, type in the text you want the link to say (your button).
  5. If you want a screen tip to pop up when you mouse over the button, click Screen tip…. Fill in your screen tip text and click OK.
    Excel hyperlink screen tip text
    Type in the text you’d like for a screentip when you mouse over the link. Not required.
  6. Click the This Document tab.
  7. Under Type in the cell reference, fill in the cell identifier of the cell you wish to link to (G1, etc.).
  8. Click OK.

Now, when you click the cell that contains your link, you will be taken directly to that location.

To link to a cell in a different sheet in the same workbook, begin by following the instructions in the previous section.

After you type in the cell reference, choose the title of the sheet that contains your target cell from the list in the larger box below, labeled Or select a place in this document:.

microsoft excel jump to link
Link to a specific cell in the current workbook. Enter cell identifier in the cell reference box and choose the sheet from the lower box.

When you click the link in the original sheet, you should be taken to your target cell in the sheet you selected.

To return to your original sheet, click the sheet tab at the bottom of the worksheet. Or you can use the same method to add a jump link on the sheet you linked to and have it take you back to the original sheet.

You may have more than one Excel workbook that you would like to navigate between by clicking a link.

If you are an author, you might have a workbook for a fiction series. That workbook might contain a spreadsheet with character info, date of publication, editing schedules, etc. for each book in the series.

You may have a second workbook with financial data for each book in the series.

There are two ways that you might link from the first workbook to the second. The first method allows you to link from the first workbook to the second workbook, but not to a specific worksheet or cell reference.

  1. Place your cursor in the cell where you would like the link to be.
  2. Click Link under the Insert tab.
  3. In the Text to Display: field, fill in the word(s) you’d like to name the link.
  4. Click the Web Page or File tab.
    microsoft excel jump to link to other workbook
    Browse to the second workbook you want to link to.
  5. Click the Select… button to the right of the Address: field.
  6. Browse to the Excel file you want to link to.
  7. Click the Open button to select the file and close the search panel.
  8. Click the OK button to complete the link insertion.

Now, when you click the link you created, Excel will open the workbook if it is not already open. You will have to locate the specific sheet and cell as usual.

The previous method allowed you to link from a specific cell in one workbook to a second workbook, but with no specific target cell.

Let’s imagine again that you are an indie author who has created the two workbooks we talked about earlier. One contains data specific to the books in a series. It is your record of characters, locations, rewrites, or whatever else you might track specifically related to the story itself.

You also have a second workbook that contains financial information about the same series. You might track information regarding the income each book has earned, the specific outlets that paid you, the cost of producing covers, cost of editing, etc..

You can create a link from the sheets in the first workbook to the specific related sheets and cells in the second workbook. This would be similar to the way I earlier described using Excel to track my articles on this website. The navigation buttons linked to specific columns in the same workbook.

The following method will allow you to set yours up in a similar way, but instead of linking to columns in the same worksheet, you link to cells in a different workbook. You’ll do this using a hyperlink function. Don’t worry, it’s not hard at all.

  1. Open both workbooks.
  2. In the first workbook, place your cursor in the cell where you want the link.
  3. Choose Function… from the Insert menu OR open the Formulas tab and click the first button, Insert Function.
  4. The Excel Formula Builder will open, probably against the right side.
    microsoft excel formula builder hyperlink function
    The Formula Builder in Microsoft Excel. Select the Hyperlink function, then click Insert Function.
  5. Click Hyperlink from the list of available functions.
  6. Click the Insert Function button.
  7. The Hyperlink panel will open in the Formula builder.
  8. Place your cursor in the Link_location box.
  9. Navigate to the second workbook.
  10. In the second workbook locate the sheet and cell that you want to link to. Click in that cell.
  11. Return to the Formula builder in the first workbook. In the Link_location box, you should now see the file path to the workbook, sheet, and cell that you clicked in.
    microsoft excel jump to link location in formula builder
    Link_location will fill in when you click the target cell in the second workbook.
  12. In the Friendly_name box (below the Link_location box), type in the word(s) that you’ll use to label the link you’ve created.
  13. Click the Done button.

You should have a working link in the first workbook which, when clicked, takes you to the cell you chose in the second workbook. It will look something like the following hyperlink function.

=HYPERLINK([my_2nd_workbook.xlsx]Sheet1!$E$6,”Book 2”)

Excel hyperlinks (jump to links) can make getting around in complex workbooks much easier. I’m sure you’ll come up with uses for them that I haven’t mentioned.

There are ways to link to specific cells in workbooks that are stored online as well.

You might also be interested in How to Print Part of a Microsoft Excel Spreadsheet.

 

About the author:

Tom Buford

About the author:

Tom Buford

Tom Buford - writer at thetechiesenior.com

Tom has enjoyed learning and using computer technology for more than 25 years. At several years north of 65, he finds writing about it and teaching it more enjoyable and interesting than ever. He has been happily married to his bride for more than 48 years and enjoys living with her and their adopted cats in rural Tennessee. Tom is also a published fiction and non-fiction author.

Tom Buford - writer at thetechiesenior.com

Tom has enjoyed learning and using computer technology for more than 25 years. At several years north of 65, he finds writing about it and teaching it more enjoyable and interesting than ever. He has been happily married to his bride for more than 48 years and enjoys living with her and their adopted cats in rural Tennessee. Tom is also a published fiction and non-fiction author.

Get Our Techie Senior Tipsheet!

You’ll receive helpful tips especially for writers, creatives, and others from TheTechieSenior.com.

Delivered weekly right to your inbox.

Get Our Techie Senior Tipsheet!

You’ll receive helpful tips especially for writers, creatives, and others from TheTechieSenior.com.

Delivered weekly right to your inbox.


TheTechieSenior.com logo

We proudly use WPX to host this website.

We do our best to provide accurate information. We cannot, however, be held responsible for any loss of data or any other damages incurred by any user or visitor to this website and accept no liability arising from the use of any information contained on this website.

TheTechieSenior.com provides its content free of charge. To help us do that some links on this page or any other throughout this website may be “affiliate links.” This means if you click on the link and purchase the item, TheTechieSenior.com may receive a commission at no cost to you. You’ll find more info in our compensation disclosure here.

As an Amazon Associate TheTechieSenior.com earns from qualifying purchases.