Home » Questions » Computers [ Ask a new question ]

Excel automatic hyperlinks

Excel automatic hyperlinks

After years of not wanting Word and Excel to automatically turn things into hyperlinks, the one time I want them to they refuse.

Asked by: Guest | Views: 148
Total answers/comments: 1
Guest [Entry]

"Take a look at Hyperlink worksheet function.

Creates a shortcut or jump that opens
a document stored on a network server,
an intranet, or the
Internet. When you click the cell that
contains the HYPERLINK function,
Microsoft Excel opens the file stored
at link_location.

Syntax

HYPERLINK(link_location,friendly_name)

For example:

=HYPERLINK(B1, ""Click for report"")"