+ Reply to Thread
Results 1 to 3 of 3

How do I double click a cell and jump to cell's referenced cell

  1. #1
    JerryJuice
    Guest

    How do I double click a cell and jump to cell's referenced cell

    Hi,

    Someone once showed me how if you have a a reference to a cell in one sheet
    you could double click on the cell and it would jump to the referenced cell
    in the reference cell's sheet.

    For example.

    Cell With Reference Referenced Cell in other
    Sheet
    A1 <--double click sheet1 cell A1 takes you to --> =Sheet2!A1

  2. #2
    Dave Peterson
    Guest

    Re: How do I double click a cell and jump to cell's referenced cell

    You have to make sure you have
    tools|options|edit tab|"edit directly in cell" unchecked

    JerryJuice wrote:
    >
    > Hi,
    >
    > Someone once showed me how if you have a a reference to a cell in one sheet
    > you could double click on the cell and it would jump to the referenced cell
    > in the reference cell's sheet.
    >
    > For example.
    >
    > Cell With Reference Referenced Cell in other
    > Sheet
    > A1 <--double click sheet1 cell A1 takes you to --> =Sheet2!A1


    --

    Dave Peterson

  3. #3
    RagDyeR
    Guest

    Re: How do I double click a cell and jump to cell's referenced cell

    In addition to what Dave said, you could keep the "Edit In Cell" option in
    force, and *still* jump to the referenced cell by using a keyboard shortcut.

    <Ctrl> < [ > will take you to the referenced cell(s) of the cell in focus,
    And if that cell happens to be on the same sheet,
    <Ctrl> < ] > will return you to the original cell.
    --

    HTH,

    RD
    =====================================================
    Please keep all correspondence within the Group, so all may benefit!
    =====================================================

    "Dave Peterson" <[email protected]> wrote in message
    news:[email protected]...
    You have to make sure you have
    tools|options|edit tab|"edit directly in cell" unchecked

    JerryJuice wrote:
    >
    > Hi,
    >
    > Someone once showed me how if you have a a reference to a cell in one

    sheet
    > you could double click on the cell and it would jump to the referenced

    cell
    > in the reference cell's sheet.
    >
    > For example.
    >
    > Cell With Reference Referenced Cell in other
    > Sheet
    > A1 <--double click sheet1 cell A1 takes you to --> =Sheet2!A1


    --

    Dave Peterson



+ 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