Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Linking All Sheets in Workbook to 1 Sheet (https://www.askmehelpdesk.com/showthread.php?t=602485)

  • Oct 10, 2011, 06:02 AM
    tokentot
    Linking All Sheets in Workbook to 1 Sheet
    I have an excel workbook with multiple sheets. My first sheet is a hyperlink list to all the different sheets. I would like to have a hyperlink in each sheet back to the list sheet. Is there a formula or simple way to do this without going to each sheet and manually doing it? I am thinking cell A1 on each sheet to link back to the first sheet. There probably is a pretty simple solution, but I am excel challenged :) sorry,

    Many thanks!
  • Oct 12, 2011, 12:54 AM
    JBeaucaire
    The Hyperlink formula is the easiest way to do this.

    Put the hyperlink to sheet1 on your sheet2, get it working, then copy/paste that cell to the other sheets, you'll be done in seconds.

  • All times are GMT -7. The time now is 03:42 PM.