| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you add a hyperlink to many worksheets/worgroups at one time?
I am new to this and really need some help. I have created a index page that
list the months with weeks that hyperlink to a workgroup for that week contaning 5 worksheets for 5 days of the week. At the top of each worksheet I want to have a cell(Labeled Home) that will hyperlink back to the index page. Is there a way to add the hyperlink to all the worksheets at one time or do I have to do it manually on each sheet? -- Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you add a hyperlink to many worksheets/worgroups at one time?
You can add a hyperlink to a single sheet, copy that cell, group all of your other sheets and paste into a cell in the group. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Raider" wrote in message I am new to this and really need some help. I have created a index page that list the months with weeks that hyperlink to a workgroup for that week contaning 5 worksheets for 5 days of the week. At the top of each worksheet I want to have a cell(Labeled Home) that will hyperlink back to the index page. Is there a way to add the hyperlink to all the worksheets at one time or do I have to do it manually on each sheet? -- Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you add a hyperlink to many worksheets/worgroups at one ti
Thanks for the reply
It will take me sometime to copy and paste to each worksheet since I have 51 workbooks that are linked off my index page contaning 5 worksheets each. -- Thanks "Jim Cone" wrote: You can add a hyperlink to a single sheet, copy that cell, group all of your other sheets and paste into a cell in the group. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Raider" wrote in message I am new to this and really need some help. I have created a index page that list the months with weeks that hyperlink to a workgroup for that week contaning 5 worksheets for 5 days of the week. At the top of each worksheet I want to have a cell(Labeled Home) that will hyperlink back to the index page. Is there a way to add the hyperlink to all the worksheets at one time or do I have to do it manually on each sheet? -- Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove hyperlink of many cell at a time? | Excel Discussion (Misc queries) | |||
| edit more than one Hyperlink at a time | Excel Worksheet Functions | |||
| how to maintain hyperlink between worksheets after sorting | Excel Worksheet Functions | |||
| how do I create a hyperlink that works more than one time | Excel Discussion (Misc queries) | |||
| Hyperlink more than one cell at a time? | New Users to Excel | |||
Linear Mode
