Asked By
zoegordon
0 points
N/A
Posted on - 03/06/2012
Hello,
I am posting this impossible (I think) question hoping I could get some fresh ideas. I have an online database in which people can sometimes add numbered entries.
Each entry has its own webpage. Instead of clicking the number in the Excel to go to webpage when people type the number, will it be possible to get the hyperlink in the same box so that the web page can be reached easily?
Thanks.
Online Database problem with numbered entries
Hi Zoegordon,
I you can simply create the hyperlink on another editor such as ms word and copy-paste the linked text.
I think this should work with your suggestion.
Online Database problem with numbered entries
Dear Zoegordon,
Yes you can make a constant link for the cell remain unchanged even though you  changed the value on the cell or left it empty to do this follow this steps:
1- Right click on this cell and select hyperlink.
2- Specify the place of your link such as opening another page, folder or opening a web page.
3- Click ok you will notice the cell was filled with the address of you link.
4- You can edit this address and the link is still working.