Results 1 to 4 of 4

Thread: Writing a friendly name for a hyperlink in Excel 2000

  1. #1
    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?

  2. #2
    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.

  3. #3
    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)

  4. #4
    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.

Similar Threads

  1. Hyperlink not working in Excel 2007
    By Technocrat52 in forum Windows Software
    Replies: 4
    Last Post: 28-03-2012, 12:24 PM
  2. Automatic Filter on Hyperlink in Excel
    By Mike Chester in forum Software Development
    Replies: 2
    Last Post: 17-03-2012, 12:36 PM
  3. Want to hyperlink only one word in a cell of Excel
    By Iyyappan in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 06:24 PM
  4. why hyperlink not working on Excel?
    By Chheda in forum Windows Software
    Replies: 4
    Last Post: 04-01-2012, 07:32 PM
  5. Macro for hyperlink on Word/Excel
    By Mindstorm in forum Windows Software
    Replies: 3
    Last Post: 07-05-2009, 03:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •