Snippets home page
 
 
register
 
 
how to

How do I go about converting hyperlinks to urls in Excel?

asked by carol16 (8)

You have 50 words left!
 
 
related questions

How do you create array using countif in Excel?

How do you cross reference in Excel?

How do you make a new line character in a Microsoft Excel cell?

How do you merge your excel bar chart from two worksheets into the same workbook?

How do you open hyperlinks in an email message?

How do you put formulas in excel with multiple conditions?

What is not enough system resource in Excel mean?

Tags:  computer  how to

answers

First open the excel worksheet and then click the insert menu of the menu bar then menu options are displayed then click hyperling option in buttom of the menu icons now a time hyperling box are displayed and then give a webpage name.

reply
posted by depika3 (154)
7 votes

To convert Hyperlinks into Urls in excel, you need to select the Cell containing the Hyperlink and press CTRL And the letter K in the selected Cell. You then have to Right click the cell and select EDIT HYPERLINK to change the text or hyperlink to a certain URL you desired before.

reply
posted by Marc44 (32)
7 votes

Fisr of all right click on the cell showing hyperlink and select Edit Hyperlink, then Change the Text to display to the same as the URL you want to show that's it.

7 votes

Select the cell and Right Click. Click on Hyperlink and then on Edit Hyperlink. Change the "Text to display" to the same as the URL. To make a URL as the hyperlink text, you can type the URL directly in the cell, as long as you begin the address with http://

reply
posted by hamsa (133)
7 votes

Enter the Link you want to convert the the URL in the cell and right click on the cell and edit Hyperlink. There you enter the link in Address tab.

7 votes

Its very easy. You can do in three steps. Step 1: Open the Excel file. Step 2: Go to the cell where hyperlink appears select the cell then right click on the cell. Step 3: Edit hyperlink change the text to display to the same as th URL. Go back to the cell now hyperlink gets converted to URL.

7 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy