Hyperlinks in a cell

G

Gary''s Student

You can't have more than one at the same time. Using Data Validation and/or
VLOOKUP you can select a hyperlink from a group of hyperlinks to put in a
cell.
 
D

Dave Peterson

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).
 
Top