Log in

View Full Version : Linking All Sheets in Workbook to 1 Sheet


tokentot
Oct 10, 2011, 06:02 AM
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!

JBeaucaire
Oct 12, 2011, 12:54 AM
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.