Excel - multiple li...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Excel - multiple links in a cell

6 Posts
6 Users
0 Reactions
66 Views
Posts: 1103
Free Member
Topic starter
 

Is this possible? I've done a workaround using both insert word object containing the links and also inserting shapes which I've formatted to look like there's several links in a cell.

Would something like delimiters or the hyperlink function enable actual typing of text and links in a cell?

Many thanks


 
Posted : 11/06/2021 12:52 pm
Posts: 0
Free Member
 

Why don't you just use more than one cell? There's rarely any excuse for putting multiple items of data into a single cell.


 
Posted : 11/06/2021 1:18 pm
 poly
Posts: 8699
Free Member
 

Its not possible the link is applied to the cell not the text within the cell so there can only be one destination. You can link to another worksheet and list them out there -e.g. "Help" and then in help have a list of links.


 
Posted : 11/06/2021 2:56 pm
Posts: 12507
Free Member
 

Can you do it via a drop down?


 
Posted : 11/06/2021 5:35 pm
Posts: 1781
Free Member
 

Can you do it via a drop down?

Not without using macros


 
Posted : 11/06/2021 5:57 pm
Posts: 3265
Full Member
 

This

Why don’t you just use more than one cell? There’s rarely any excuse for putting multiple items of data into a single cell.

multiple things in cells, merged cells, non-contiguous data. All not tidy. 


 
Posted : 12/06/2021 7:39 am
Posts: 12507
Free Member
 

Not without using macros

Ah fair enough didn't have it to hand and wondered if the hyperlink would through with a excel drop down thingy.

I agree with it being messy though


 
Posted : 12/06/2021 7:48 am

6 DAYS LEFT
We are currently at 95% of our target!