Hyperlink Display problem

[Panama Red]

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

 

[Dave Peterson]

try:

tools|options|View tab
uncheck Formulas

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

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

 

[Panama Red]

Ctrl+~ did it. Easy fix to a silly problem. Thank you dave.