Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 5, 2013, 02:21 PM   #1
bgsnmky
macrumors regular
 
Join Date: Sep 2012
Cut /paste hyperlink in Excel

Driving me crazy..

is there a way to copy the http:url and past it into the hyperlink window?

It is a very long url, and It appears I can only type it..but I really need to cut and paste it.

But it will not let me.
bgsnmky is offline   0 Reply With Quote
Old Jan 5, 2013, 02:26 PM   #2
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post
Driving me crazy..

is there a way to copy the http:url and past it into the hyperlink window?

It is a very long url, and It appears I can only type it..but I really need to cut and paste it.

But it will not let me.
By "hyperlink window" do you mean the address bar of your browser? If so:

Right-click on the cell with the hyperlink and copy, then paste into your browser.
Right-click on the cell with the hyperlink and select "Open Hyperlink"
GGJstudios is offline   0 Reply With Quote
Old Jan 5, 2013, 02:39 PM   #3
bgsnmky
Thread Starter
macrumors regular
 
Join Date: Sep 2012
Quote:
Originally Posted by GGJstudios View Post
By "hyperlink window" do you mean the address bar of your browser? If so:

Right-click on the cell with the hyperlink and copy, then paste into your browser.
Right-click on the cell with the hyperlink and select "Open Hyperlink"
not really...sorry..let me try again.

I go to the browser in safari..I can highlight and select copy

I got to excel - and in a cell - go to menu - select Insert and then Hyperlink.
The next window that pops up is the hyperlink window where you can type in the hyperlink and description.
But I just want to PASTE it in..and it doesn't let me
bgsnmky is offline   0 Reply With Quote
Old Jan 5, 2013, 02:40 PM   #4
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post
not really...sorry..let me try again.

I go to the browser in safari..I can highlight and select copy

I got to excel - and in a cell - go to menu - select Insert and then Hyperlink.
The next window that pops up is the hyperlink window where you can type in the hyperlink and description.
But I just want to PASTE it in..and it doesn't let me
That works for me, but why not just click on the cell where you want it and paste it there? Does that work? If not, have you checked to make sure it's not a protected cell?
GGJstudios is offline   0 Reply With Quote
Old Jan 5, 2013, 03:52 PM   #5
bgsnmky
Thread Starter
macrumors regular
 
Join Date: Sep 2012
Quote:
Originally Posted by GGJstudios View Post
That works for me, but why not just click on the cell where you want it and paste it there? Does that work? If not, have you checked to make sure it's not a protected cell?
I can insert in a cell just fine.

But sometimes you want the cell to say: Couples swept away, but it goes to the website that is like this: www.couples.com/sweptaway.com

basically I have tried everything to paste my url in the place where the error is.
This one is not long..but I have one that is ReALLY long

[IMG][/IMG]
bgsnmky is offline   0 Reply With Quote
Old Jan 5, 2013, 03:55 PM   #6
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post
I can insert in a cell just fine.

But sometimes you want the cell to say: Couples swept away, but it goes to the website that is like this: www.couples.com/sweptaway.com

basically I have tried everything to paste my url in the place where the error is.
This one is not long..but I have one that is ReALLY long
Try this: paste the link in a cell, then right-click the cell and Edit Hyperlink. The link should be populated and you can edit the display text.
GGJstudios is offline   0 Reply With Quote
Old Jan 5, 2013, 04:20 PM   #7
Darth.Titan
macrumors 68020
 
Darth.Titan's Avatar
 
Join Date: Oct 2007
You didn't mention how you're trying to paste into that field. I know from experience that right-click pasting into the "Edit hyperlink" dialog doesn't work in either the Mac or Windows versions of Excel.

However you can still paste with Command-V (or Ctrl-V in Windows)
Attached Thumbnails
Click image for larger version

Name:	Screen Shot 2013-01-05 at 4.19.02 PM.png
Views:	18
Size:	72.5 KB
ID:	388162  
Darth.Titan is offline   0 Reply With Quote
Old Jan 5, 2013, 04:23 PM   #8
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by Darth.Titan View Post
You didn't mention how you're trying to paste into that field. I know from experience that right-click pasting into the "Edit hyperlink" dialog doesn't work in either the Mac or Windows versions of Excel.

However you can still paste with Command-V (or Ctrl-V in Windows)
Good catch! I didn't even think of right-clicking to paste, since I'm so used to Command-V. It never occurred to me that someone might not try the keyboard command.
GGJstudios is offline   0 Reply With Quote
Old Jan 5, 2013, 04:31 PM   #9
bgsnmky
Thread Starter
macrumors regular
 
Join Date: Sep 2012
Quote:
Originally Posted by GGJstudios View Post
Good catch! I didn't even think of right-clicking to paste, since I'm so used to Command-V. It never occurred to me that someone might not try the keyboard command.


and I am so used to the mouse! and I do it in windows all the time.


so still can't get it to work..there has to be a way....
bgsnmky is offline   0 Reply With Quote
Old Jan 5, 2013, 04:45 PM   #10
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post


and I am so used to the mouse! and I do it in windows all the time.


so still can't get it to work..there has to be a way....
Did you try the suggestion in post #6?
GGJstudios is offline   0 Reply With Quote
Old Jan 5, 2013, 05:55 PM   #11
bgsnmky
Thread Starter
macrumors regular
 
Join Date: Sep 2012
Yes. When you right click and edit hyperlink. The link is in the dist text already. It looks like the picture I posted. And same thing. Cant get the link to paste

Does it work for you Guys

Last edited by bgsnmky; Jan 5, 2013 at 09:33 PM.
bgsnmky is offline   0 Reply With Quote
Old Jan 6, 2013, 12:36 AM   #12
Darth.Titan
macrumors 68020
 
Darth.Titan's Avatar
 
Join Date: Oct 2007
When I right click and edit the hyperlink, there's no problem pasting a link for me.
Darth.Titan is offline   0 Reply With Quote
Old Jan 6, 2013, 12:32 PM   #13
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post
Yes. When you right click and edit hyperlink. The link is in the dist text already. It looks like the picture I posted. And same thing. Cant get the link to paste
If you paste the link in the cell (just click on a cell and Command-V to paste), then afterwards you right-click the cell and Edit Hyperlink, you no longer have to paste the link, as it's already there. You can simply click in the Display field and edit that to your liking, but the link is already there.
GGJstudios is offline   0 Reply With Quote
Old Jan 7, 2013, 01:12 PM   #14
bgsnmky
Thread Starter
macrumors regular
 
Join Date: Sep 2012
Quote:
Originally Posted by GGJstudios View Post
If you paste the link in the cell (just click on a cell and Command-V to paste), then afterwards you right-click the cell and Edit Hyperlink, you no longer have to paste the link, as it's already there. You can simply click in the Display field and edit that to your liking, but the link is already there.
I am going to have to call apple care. I know you guys are saying that should work. BUT it doesn't.

It still shows in the Display field when I select edit hyperlink. It should be showing in the Link To, but the link actually shows up in teh Diplay field and not in the Link To field.
bgsnmky is offline   0 Reply With Quote
Old Jan 7, 2013, 01:18 PM   #15
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by bgsnmky View Post
I am going to have to call apple care. I know you guys are saying that should work. BUT it doesn't.

It still shows in the Display field when I select edit hyperlink. It should be showing in the Link To, but the link actually shows up in teh Diplay field and not in the Link To field.
So if you paste the link in a cell, then right-click in the cell and select Edit Hyperlink, you don't see the link in both the "Link to:" and "Display:" fields?
Click image for larger version

Name:	ScreenCap 2013-01-07 at Mon, Jan 7,1.16.07 PM .PNG
Views:	28
Size:	74.4 KB
ID:	388583
If so, you might try deleting the Excel plist and then relaunch Excel. The plist is located here:

/Users/yourusername/Library/Preferences/com.microsoft.Excel.plist
GGJstudios is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
can't cut and paste boynigel Mac mini 2 May 26, 2014 10:05 AM
Hyperlink iTunes playlist ported to Excel oscarodas Mac Basics and Help 0 Oct 12, 2013 02:42 AM
Paste into visible cells only (Excel 2011) moodiel Mac Applications and Mac App Store 3 Jan 15, 2013 04:39 AM
Cut paste darksiders Mac Basics and Help 6 Oct 5, 2012 03:05 PM
Unable to cut and paste Sairo OS X 10.8 Mountain Lion 13 Jul 30, 2012 01:42 AM

Forum Jump

All times are GMT -5. The time now is 07:48 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC