Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2025, 04:56 AM
Hans Peter Hans Peter is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Novice
Make a link from a textstring in a cell
 
Join Date: Aug 2025
Location: Solna, Sweden
Posts: 5
Hans Peter is on a distinguished road
Default Make a link from a textstring in a cell

I want to make a link from the text string newfoundland in a cell to another file.


According to what I have read, I should start by selecting the text string, right-click and select LINK. However, I do not get such an option. Not even if I go via INSERT. I am doing something wrong, but what? Or is this not possible?


/hans peter
Attached Images
File Type: jpg Bild1.jpg (9.2 KB, 14 views)
Reply With Quote
  #2  
Old 10-18-2025, 01:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,944
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi and welcome,
what is the link you posted for? I did not click on it as it might be unsafe.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 10-18-2025, 02:09 AM
macropod's Avatar
macropod macropod is offline Make a link from a textstring in a cell Windows 10 Make a link from a textstring in a cell Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,479
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

@ Hans Peter

Instead of posting links, please attach your sample direct to your post. You can do that via the paperclip icon on 'Advanced' posting screen. In this case, I've done it for you.

@ Pecoflyer
In this case it's just harmless link to a jpg image on OneDrive showing a textstring, presumably on Excel, to a Word document. Even so, it's not obvious what the issue is.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-18-2025, 02:58 AM
Hans Peter Hans Peter is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Novice
Make a link from a textstring in a cell
 
Join Date: Aug 2025
Location: Solna, Sweden
Posts: 5
Hans Peter is on a distinguished road
Default

Thanks both for the quick replies. Especially to macropod who taught me things and helped me make my post understandable for pecoflyer (I hope.)

"Still, it's not obvious what the problem is." I understand that. I'll try again. I want to make a link to a file named newfoundland.docx. I highlight the word newfoundland (part of the text in the cell), right-click on the selection and this comes up.

There is no Link option. Further help needed.
/hans peter
Attached Images
File Type: jpg 20251018_114041.jpg (14.5 KB, 14 views)
Reply With Quote
  #5  
Old 10-18-2025, 02:12 PM
macropod's Avatar
macropod macropod is offline Make a link from a textstring in a cell Windows 10 Make a link from a textstring in a cell Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,479
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

All you need to do is choose Insert>Link, then navigate to your file location and select the file.

Note: you cannot insert a link and other content into the same cell.
Attached Images
File Type: png InsertLink.png (145.9 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 10-18-2025, 02:58 PM
Hans Peter Hans Peter is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Novice
Make a link from a textstring in a cell
 
Join Date: Aug 2025
Location: Solna, Sweden
Posts: 5
Hans Peter is on a distinguished road
Default

Sorry, Paul Edstein, I can only repeat what I wrote in my latest reply.
I highlight the word newfoundland and right-click on it. Then I get what I showed you in my last post, but no link-selection.
If I right-click on the cell itself, I get what you show in your last post. But that doesn't serve me.
There's something I'm doing wrong. But what?
K.r.
/hans peter
Reply With Quote
  #7  
Old 10-18-2025, 03:01 PM
macropod's Avatar
macropod macropod is offline Make a link from a textstring in a cell Windows 10 Make a link from a textstring in a cell Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,479
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You:
do not click on the text in Excel.
cannot insert a link into a cell that contains any existing content.
• should use the Insert>Link dialogue to insert the link into an empty cell.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 10-18-2025, 03:23 PM
Hans Peter Hans Peter is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Novice
Make a link from a textstring in a cell
 
Join Date: Aug 2025
Location: Solna, Sweden
Posts: 5
Hans Peter is on a distinguished road
Default

Hi again, to make it perfectly clear. So it's not possible to make a link from a single word in a cell. As I thought you could in the same way as you can do it in Word?
/hans peter
Reply With Quote
  #9  
Old 10-18-2025, 11:17 PM
ArviLaanemets ArviLaanemets is offline Make a link from a textstring in a cell Windows 8 Make a link from a textstring in a cell Office 2016
Expert
 
Join Date: May 2017
Posts: 950
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by macropod View Post
You:
...
cannot insert a link into a cell that contains any existing content.
You can, but the whole content of cell will be the text what the link displays there by default, and it will be replaced with link after it will be created. And of-course you can edit this text when in Creating Hyperlink window, and the link text displayed in cell will be changed after this.
Reply With Quote
  #10  
Old 10-18-2025, 11:39 PM
macropod's Avatar
macropod macropod is offline Make a link from a textstring in a cell Windows 10 Make a link from a textstring in a cell Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,479
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Hans Peter View Post
Hi again, to make it perfectly clear. So it's not possible to make a link from a single word in a cell. As I thought you could in the same way as you can do it in Word?
You cannot add a link to a cell containing any existing content. If you already have text there, you could cut it out, then insert the link and past the content from the clipboard into the display text for the link. That's about the best you can hope for.

Excel is not a word processor.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 10-19-2025, 12:25 AM
Hans Peter Hans Peter is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Novice
Make a link from a textstring in a cell
 
Join Date: Aug 2025
Location: Solna, Sweden
Posts: 5
Hans Peter is on a distinguished road
Default

Thank you all
/hans peter
Reply With Quote
  #12  
Old 10-19-2025, 12:40 AM
xor xor is offline Make a link from a textstring in a cell Windows 11 Make a link from a textstring in a cell Office 2021
Expert
 
Join Date: Oct 2015
Posts: 1,102
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Make a link from a text string

You can overlay an invisible shape on the desired word.
Attached Files
File Type: xlsm Link_from_word.xlsm (16.0 KB, 1 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I find the cell where the link to a source does not work? Manuel_RS Excel 0 08-24-2019 11:51 AM
Excel 2016: make a cell value from the number in a different cell nielsgeode Excel 1 03-07-2019 12:20 AM
Trying to link a cell from one worksheet to another gambo Excel 1 01-18-2019 10:26 AM
Is it possible to make Word link to the last record in Excel stephen_pen Word 0 09-22-2011 11:00 PM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft