How to hide Hypyerlink cell contents ?

W

Wellie

I used the hyperlink() function in a cell to point to
either a specific section of a doc or a cell of another
spreadsheet. For example: In cell A10, enter the
following:
=hyperlink("[C:\$ISC\Proj-3\05 Risks\My Documnet.doc]
My_Role","My Role")

When I click on it and it works. When I place the cell
on the cell, I can see the above entire content of the
cell shows up on the formula bar. Tried to right click
the cell use the "Edit Hyperlink" fix it, no such command.

Question: Can I hide the contents of the cell and have
it show the word "My Role" there instead ?

I have seen other people use the web hyperlink feature to
achieve the same result but I don't know how to do it.

Can someone please help me as what I have to do to hide
the cell contents ?
 
F

firefytr

Hi,

If I understand you correctly, you can right click on a blank cell an
choose Hyperlink.. Navigate to your file and select it. At the top o
the window is Text to Display, type in My Role, or whatever you want.
This should give you what you're looking for I think
 
D

Dave Peterson

Another way, but it might be too restrictive:

Select your cell with the hyperlink formula.
Format|cells|protection tab
check "hidden"

Then protect the worksheet:
tools|protection|protect sheet

But there are lots of things that the user cannot do to a protected sheet--so it
might not be a viable option.

(and worksheet protection is very simple to break--so that could be a problem,
too.)
I used the hyperlink() function in a cell to point to
either a specific section of a doc or a cell of another
spreadsheet. For example: In cell A10, enter the
following:
=hyperlink("[C:\$ISC\Proj-3\05 Risks\My Documnet.doc]
My_Role","My Role")

When I click on it and it works. When I place the cell
on the cell, I can see the above entire content of the
cell shows up on the formula bar. Tried to right click
the cell use the "Edit Hyperlink" fix it, no such command.

Question: Can I hide the contents of the cell and have
it show the word "My Role" there instead ?

I have seen other people use the web hyperlink feature to
achieve the same result but I don't know how to do it.

Can someone please help me as what I have to do to hide
the cell contents ?
Click to expand...
 
Top