+ Reply to Thread
Results 1 to 5 of 5

Shortcut --> jump to linked cell?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-18-2011
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    2

    Shortcut --> jump to linked cell?

    Hi,

    I'm looking for the shortcut for jumping to a linked cell, e.g. if I select cell A5 in Sheet1 in which I've linked to Z7 in Sheet2, the shortcut should take me to and select Z7 in Sheet2. F5 and ENTER would get me back again. Hence a good way to double check that the linking is correctly done...

    Your help on this one is highly appreciated!

    (I'm using Excel 2010, English version)

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Shortcut --> jump to linked cell?

    Insert a hyperlink to the cell in Sheet2:
    CTRL + K.

    You can't do that, however, for sheet 2, or your text in A1 will show the hyperlink...
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

  3. #3
    Registered User
    Join Date
    08-18-2011
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Shortcut --> jump to linked cell?

    Sorry for not being clear what I'm looking for.. Another try:

    To double check my Excel-files in an effort to make sure I've linked to the right cells there should be a short cut (at least there is in the Swedish Excel version) to "jump" to the first cell in a formula (e.g. =A1+B2 --> moved to and selection of cell A1). I.e. I'm not looking for any permanent link.

    Currently I can double click a cell with a formula and autmatically be moved to the cell which is being linked to from the one I double clicked - now I'm looking for the exact same function but instead the keybord shortcut to speed it up

  4. #4
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Shortcut --> jump to linked cell?

    try using CTRL + [

    This should jump you to the cell in question.

  5. #5
    Registered User
    Join Date
    06-24-2014
    Location
    Tennessee, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Thumbs up Re: Shortcut --> jump to linked cell?

    That is awesome tlafferty. A good find. Thanks for the tip.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1