Excel Hyperlink
Excel Hyperlink
(OP)
Hi All,
Is there any way of making hyperlinks CTRL+CLICK like in word?
Cheers
Tom
Is there any way of making hyperlinks CTRL+CLICK like in word?
Cheers
Tom
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Excel Hyperlink
Never, but never question engineer's judgement
RE: Excel Hyperlink
This is in Excel 2002, not sure about anything prior.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel Hyperlink
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