Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Writing a friendly name for a hyperlink in Excel 2000

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-02-2011
Member
 
Join Date: Jan 2011
Posts: 27
Writing a friendly name for a hyperlink in Excel 2000
  

I have installed an Excel 2000 on my machine and operating system of this machine is windows xp sp2. I have created some Excel files on this machine in which I am looking for a hyperlink function that can take me to another excel file that has been placed on a network, Though the same file is on my hard drive as well. So does anybody know that how can I hyperlink a cell of excel file to navigate to another file?

Reply With Quote
  #2  
Old 25-02-2011
Member
 
Join Date: Nov 2008
Posts: 1,514
Re: Writing a friendly name for a hyperlink in Excel 2000

Excel 2000: it is possible to create a shortcut or hyperlink that opens another document stored on your hard drive, a network server, an intranet or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file stored at "Link_location. To do this, simply enter the following formula:

= HYPERLINK (Link_location; friendly_name).

The argument is the text of friendly_name reference or numeric value that appears in the cell. The contents of the cell is displayed in blue and underlined. If you omit the argument friendly_name, the cell displays as text Link_location court.
Reply With Quote
  #3  
Old 25-02-2011
Member
 
Join Date: Mar 2009
Posts: 1,360
Re: Writing a friendly name for a hyperlink in Excel 2000

Please note that both the arguments must be quoted. Here I have provided you couple of example that can give you ideas about the hyperlinking in Excel file. You can create hyperlinks using the following formula:

= HYPERLINK ("http://www.entreprise.com/report/budget.xls", "Click here to view the report). This example opens the Spreadsheet Report "budget.xls" stored on the Internet at "www.enterprise.com/ report and displays the text" Click here to view the report. "

The following example creates a hyperlink to cell F10 on the worksheet "Annual" Report of the workbook "budget.xls", which is stored on the Internet at "www.entreprise.com / report". The cell in the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text:

= HYPERLINK ("[www. enterprise.com/report/budget.xls] Annual! F10", D1)
Reply With Quote
  #4  
Old 25-02-2011
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Writing a friendly name for a hyperlink in Excel 2000

There is an individual but an easier way to create a cell of an Excel file as a hyperlink. Directly enter a URL in the text. When you type an Internet address in a cell, for example www. example.microsoft.com, Excel routinely converts the address into a hyperlink. To store the address in the form of regular text, type an apostrophe (') previous to the address. For example, if you type 'www. example.microsoft.com, the text of the address displayed in the cell devoid of the apostrophe, and does not become visible as a hyperlink. If Excel has already turned into a hyperlink address, you can disable it: Click the right mouse button on the cell, point to Hyperlink on the shortcut menu, then click Remove Hyperlink.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Writing a friendly name for a hyperlink in Excel 2000"
Thread Thread Starter Forum Replies Last Post
Hyperlink not working in Excel 2007 Technocrat52 Windows Software 4 28-03-2012 01:24 PM
Automatic Filter on Hyperlink in Excel Mike Chester Software Development 2 17-03-2012 01:36 PM
Want to hyperlink only one word in a cell of Excel Iyyappan MS Office Support 2 23-02-2012 07:24 PM
why hyperlink not working on Excel? Chheda Windows Software 4 04-01-2012 08:32 PM
Macro for hyperlink on Word/Excel Mindstorm Windows Software 3 07-05-2009 04:13 PM


All times are GMT +5.5. The time now is 05:42 AM.