| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you have both a hyperlink and "regular" words in a cell?
If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the
contents turn into a hyperlink. I don't want that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you have both a hyperlink and "regular" words in a cell?
Select the range of cells. Rightclick --Remove hyperlink
-- If this post helps click Yes --------------- Jacob Skaria "kaliszek" wrote: If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the contents turn into a hyperlink. I don't want that. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you have both a hyperlink and "regular" words in a cell?
The Insert|Hyperlink type and the =hyperlink() type both apply to the entire
cell. But you can cheat. You could add a rectangle from the Drawing toolbar (hide the borders!) just over the text you want. Then assign a hyperlink to that rectangle. Format the characters under the rectangle so that it looks like a hyperlink (blue underlined). kaliszek wrote: If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the contents turn into a hyperlink. I don't want that. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I alphabetize data excluding words like "a" and "the"? | Excel Discussion (Misc queries) | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| certain words "CONTAINS" in an free text cell........... | Excel Discussion (Misc queries) | |||
Linear Mode
