Hyperlink Display problem

P

Panama Red

:confused: I had a bunch of hyperlinks set up linked to different
worksheets within the same workbook. Everything has been working fine
for months, but today I hit what I think was Ctrl plus an unknown key.
And now the hyperlinks only display the full formula, not just th text
I want. The hyperlinks still work though. I can not figure out what I
did. Any help would be great. Here is an example of the formula:

=HYPERLINK("[Groups.xls]k!a1", K!C8)
and
=K!B13
 
D

Dave Peterson

try:

tools|options|View tab
uncheck Formulas

I bet you hit ctrl-~ (ctrl-tilde). It's the shortcut key for viewing formulas.

Panama said:
:confused: I had a bunch of hyperlinks set up linked to different
worksheets within the same workbook. Everything has been working fine
for months, but today I hit what I think was Ctrl plus an unknown key.
And now the hyperlinks only display the full formula, not just th text
I want. The hyperlinks still work though. I can not figure out what I
did. Any help would be great. Here is an example of the formula:

=HYPERLINK("[Groups.xls]k!a1", K!C8)
and
=K!B13
Click to expand...
 
Top