none
Microsoft Excel - "Go To" button

Answers

  • Sure:

    Insert > Hyperlink > Place in this Document

    and specify the tab and cell for the destination.


    gsnu201202

    Friday, July 27, 2012 7:58 PM
  • Select the cell.

    Excel 2003 or before: select Insert | Hyperlink.

    Excel 2007 or later: activate the Insert tab of the ribbon and click Hyperlink.

    Click "Place in this document".

    Select the target sheet, and specify the address of the cell to go to.

    Click OK.


    Regards, Hans Vogelaar

    Friday, July 27, 2012 7:59 PM
  • Just create a formula linking to the client cell then double click into the cell that contains the formula then Excel will goto your client cell. If you want to go back, press F5 then Enter.

    However it will work after you set Excel as follow:

    Excel 2003 or before: Tools > Options > Edit > Do not select Edit directly in cells.

    Excel 2007 and later: Excel Options > Advanced > Do not select Allow editing directly in cells.

    Using Excel without selecting Edit directly in cells will cause you to use Formula Bar in editing insted. I always deselect this command.

    Tuesday, July 31, 2012 2:04 AM

All replies

  • Sure:

    Insert > Hyperlink > Place in this Document

    and specify the tab and cell for the destination.


    gsnu201202

    Friday, July 27, 2012 7:58 PM
  • Select the cell.

    Excel 2003 or before: select Insert | Hyperlink.

    Excel 2007 or later: activate the Insert tab of the ribbon and click Hyperlink.

    Click "Place in this document".

    Select the target sheet, and specify the address of the cell to go to.

    Click OK.


    Regards, Hans Vogelaar

    Friday, July 27, 2012 7:59 PM
  • Just create a formula linking to the client cell then double click into the cell that contains the formula then Excel will goto your client cell. If you want to go back, press F5 then Enter.

    However it will work after you set Excel as follow:

    Excel 2003 or before: Tools > Options > Edit > Do not select Edit directly in cells.

    Excel 2007 and later: Excel Options > Advanced > Do not select Allow editing directly in cells.

    Using Excel without selecting Edit directly in cells will cause you to use Formula Bar in editing insted. I always deselect this command.

    Tuesday, July 31, 2012 2:04 AM
  • hi, it's a genius way to set cell into 'no-edit-directly' in excel to get to your destination cell, however, I am not fond of using mouse due to some physical pain, could there be a way to use this function by mouse?

    Monday, November 19, 2012 4:37 AM