Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to go to another sheet? (https://www.askmehelpdesk.com/showthread.php?t=333098)

  • Mar 24, 2009, 12:02 AM
    email2007
    How to go to another sheet?
    I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others.

    Example: if I click on Apple from Sheet 1, I will go to Sheet2
  • Mar 24, 2009, 02:07 AM
    JBeaucaire

    Don't misunderstand HYPERLINKS, they are not only values to destination outside the sheet. HYPERLINKS can connect to positions within one workbook, too, which sounds like what you want.

    1. First, insert your picture of an Apple.
    2. Right-click the Apple and select Hyperlink
    3. On the left panel, click on Place in Document
    4. Enter the Cell target in "Type in the cell reference"
    5. Double-click on Sheet2 in the "place in document" listing
    6. Your Hyperlink is created
    7. Deselect the apple
    8. Click on the apple
    9. You will go to Sheet2 to the cell indicated

    This behavior will be consistent to others to whom you send this sheet. This is an 'internal" hyperlink.

  • All times are GMT -7. The time now is 12:16 AM.