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

3 replies

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.
0
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

0
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
0