Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Excel
Creating Hyperlinks Creating Hyperlinks
Register FAQ Members List Social Groups Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-08-2008, 04:51 PM
Banned
  
Join Date: Dec 2008
Posts: 1
alicein1derville is on a distinguished road
Default Creating Hyperlinks
Can you format cells to automatically create hyperlinks? If so, how?
Reply With Quote
  #2  
Old 12-08-2008, 05:53 PM
caholmes caholmes is offline Windows Vista Office 2007 (Version 12.0)
Advanced Beginner
  
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 42
caholmes is on a distinguished road
Default Automatic Hyperlinks
A hyperlink is not a format. You will need to create a macro (VBA) to automate this process
Reply With Quote
  #3  
Old 12-08-2008, 08:15 PM
Matrix Matrix is offline Windows XP Office 2007 (Version 12.0)
Admin
  
Join Date: Jan 2005
Posts: 348
Matrix has disabled reputation
Default
If the content of a cell is an URL such as http://www.msofficeforums.com/, Excel will make it clickable by default.
Reply With Quote
  #4  
Old 12-10-2008, 01:27 PM
turnbuk turnbuk is offline Windows XP Office 2003 (Version 11.0)
Novice
  
Join Date: Dec 2008
Posts: 6
turnbuk is on a distinguished road
Default
You can format a cell in ACCESS to automatically create a hyperlink from any text you type in...but you'll still have to adjust the address of the link.
Reply With Quote
  #5  
Old 12-12-2008, 08:34 AM
Novice
  
Join Date: Dec 2008
Location: Hong Kong
Posts: 8
Emily is on a distinguished road
Default
Excel function Hyperlink but not automatically create link

HYPERLINK(link_location,friendly_name)
Reply With Quote
  #6  
Old 02-09-2009, 12:31 AM
Novice
  
Join Date: Feb 2009
Posts: 1
Gary Winnick is on a distinguished road
Default
Hyperlink is very easy.
Select the column In upper toolbar globe type icon click on it and put url on it. You column will be hyper.
Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook hyperlinks don't work. russia5 Office 1 05-21-2009 05:20 PM
Word to Excel hyperlinks and spaces gak Word 1 09-14-2008 11:38 AM
hyperlinks from copying in web browser are long format... BERKEY Word 0 12-14-2007 12:33 PM
Hyperlinks dont work iturnrocks Outlook 0 11-21-2006 12:19 PM
Creating new project Using PDS myanilkumar Project 0 01-05-2006 02:35 AM


All times are GMT -4. The time now is 10:37 PM.

Contact Us - Top

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.