Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-08-2008, 02: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, 03:53 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
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, 06:15 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 462
Matrix is on a distinguished road
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, 11:27 AM
turnbuk turnbuk is offline Windows XP Office 2003
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, 06:34 AM
Novice
 
Join Date: Dec 2008
Location: Hong Kong
Posts: 7
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-08-2009, 10:31 PM
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

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft