If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link - deactivate being sent to source when click on linked cell?
It sounds like your hyperlink is still there, but the cell isn't formatted in a
hyperlink style. Select the cell and hit Insert|Hyperlink (or ctrl-k) See if your link is still there. ==== If you have a link that appears normal, but you want it to look like a link (blue, underlined), then select the cell format|style|and choose hyperlink from the dropdown menu (You may have to add a hyperlink to a helper cell for Hyperlink to show up in that dropdown. After you have one, you can clean up that helper cell (Edit|clear).) snidely wrote: I have figured out how to set up a link from a cell in one book to a cell in another book. At first all i could do was the"hyperlink" thing with underlines etc. Now i link and the display is in plain text format. Problem is, tho, if i click on a cell that is linked to another book, it takes me to that other book. (There are times i click on a linked cell to change formatting etc.) Is there anyway to deativate the "feature" of automatically being taken to the "source" workbook? Thanks. ...mike -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Undoing LINKS in Excel 2000 | jayceejay | New Users | 3 | January 4th, 2005 06:58 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 08:16 PM |
Still having Web Page Pathing Problems / Relative Links show Netwo | webmaster | Powerpoint | 27 | July 15th, 2004 11:16 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 09:30 PM |
Stubborn Link Data/Value Problem - Help Appreciated! | Jax | Links and Linking | 5 | January 8th, 2004 08:46 AM |