Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Hyperlink
- Thread starter 6060842
- Start date
COEngineeer
Structural
go to excel and type "hyperlink" for help. ie( =hyperlink(" here to go to engineering tips")
Never, but never question engineer's judgement
Never, but never question engineer's judgement
In Excel2000 onwards,
Highlight text or shape and right-click for add hyperlink.
If it is the text, the default will turn it into blue with underlining, you can change the format to remove underline, change colour etc.
I often use a square with colour fill of 25% grey and 50% transparency (or even whitefill with 100%) on a plot plan to take me to another worksheet.
Don't forget to home link yourself back.
This way you don't need ctrl +click. When you are adding hyperlink don't foret to change the screentip and force to something simpler. This is the text that appears when you hover over the link.
On all worksheets, I leave the top three rows clear and one column free to put all the navigation and macro buttons.
Hope that helps
Highlight text or shape and right-click for add hyperlink.
If it is the text, the default will turn it into blue with underlining, you can change the format to remove underline, change colour etc.
I often use a square with colour fill of 25% grey and 50% transparency (or even whitefill with 100%) on a plot plan to take me to another worksheet.
Don't forget to home link yourself back.
This way you don't need ctrl +click. When you are adding hyperlink don't foret to change the screentip and force to something simpler. This is the text that appears when you hover over the link.
On all worksheets, I leave the top three rows clear and one column free to put all the navigation and macro buttons.
Hope that helps
- Status