Kindly Request for Excel Help in Cell Formating

[Closed]
Report
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,





If you have some time, can you please try to help me, I would greatly appreciate any help

I am entering a web site name into an excel spreadsheet cell,
normally, I can click on the cell and get access to the web site
but, I must have changed some parameter, now I can not go to the web site

3 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi Gary,

Use the following steps to turn the link again to Hyperlink:

1. Paste the website address in the cell.
2. Right click the cell.
3. Select "Hyperlink...".
4. Click OK, the address will again change to Hyperlink

Do reply with results.
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013

Thanks for trying to help. I appreciate your assistance
but, I still have a problem
I think that I need to format the cell

I would appreciate any other suggestions

Kindly thanks for your time and help

Gary

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi Gary,

If the address does not begin with any qualifier for websites such as "www" or "[http://]" it is difficult for Microsoft Excel to identify it as address. For example: the address "en.kioskea.net" when pasted as plain text or without any formatting the address will not be detected as a webpage by Microsoft Excel. However, if I add the prefix "[http://]" to it, it will change to a webpage hyperlink. So, the first method you can use to change the address is by adding the prefix "[http://]" to it. Second method is to convert it to a hyperlink using the steps provided in my previous post. The only difference I recommend this time is to put the same address in "Address" field of the "Edit Hyperlink" dialog box. You can check the below mentioned link for a pictorial view of this step:

http://s24.postimg.org/64j0f1ied/image.jpg

Do reply with results.

Thanks & Regards
Zohaib R
#iworkfordell