|
|||||||
![]() |
|
|
LinkBack | Thread Tools |
|
|
#1 |
|
DriverHeaven Addict
Join Date: Sep 2002
Location: Elysium
Posts: 330
Rep Power: 0 ![]()
|
Hey everyone. I have an little conundrum which is driving me nuts. I want to turn text, such as mywebsite.net , into a hyperlink in M$ Excel. I have to apply it to a column with about 50 or so rows, in each case turning something.something into a clickable link which will open in my browser. I cant for the life of me figure it out. Does anyone out there have a silver bullet fot this?
|
|
|
|
|
|
#2 |
|
Bang. Bang. Bang.
|
If you highlight the Cell and press Ctrl + K it brings up the Hyperlink dialogue, you can insert a link and the text to display for it
|
|
|
|
|
|
#3 |
|
DriverHeaven Addict
Join Date: Sep 2002
Location: Elysium
Posts: 330
Rep Power: 0 ![]()
|
Thanks for the reply, Mousey! That works, but it also means I have to type in the http:// , THEN what I have already existing. So in A7 for example, I have asite.biz Now if I highlight it and ctrl-k I have to tell it to point to http://asite.biz which is actually more work than just copying and pasting the "asite.biz" directly to the browser. Im working with blocks of 50 or so DAILY. Having to add the http:// to each individually is a curse! I need a way to associate "asite.biz" to http://asite.biz. Is that possible?
EDIT: If its even possible in MS Word I could make that work. Does anyone know if it can be done in Word? Basically I want it to open in a browser without having to add the "http://" Last edited by Calinerti; May 1, 2008 at 06:08 AM. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| University football recruiters turn to text messaging | calidan | News | 0 | Jan 24, 2006 11:43 PM |
| Seņor_Mota's Old-Skool Gaming Thread!!!! | Senor_Mota | Gaming Discussion | 60 | Mar 10, 2005 12:21 AM |
| I think Roadee would approve, a Pete Seeger tune performed by the Byrds | Falstaff | Heavenly Echoes | 1 | Aug 13, 2004 09:03 PM |
| Maybe someone can provide insight | BMG_Cya=- | General Discussion | 1 | Oct 31, 2003 11:58 AM |
| System Tweaks for Gameing and Performance | Sourcer_2002 | Gaming Discussion | 10 | Jul 27, 2003 09:42 AM |