Kindly Request for Excel Help in Cell Formating

Closed
grampsgary Posts 2 Registration date Wednesday March 20, 2013 Status Member Last seen March 20, 2013 - Mar 20, 2013 at 05:01 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 21, 2013 at 04:24 PM
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
Related:

3 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 20, 2013 at 05:07 PM
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.
grampsgary Posts 2 Registration date Wednesday March 20, 2013 Status Member Last seen March 20, 2013
Mar 20, 2013 at 09:02 PM
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

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 21, 2013 at 04:24 PM
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