Dê uma olhada na função de planilha Hyperlink.
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)
Por exemplo:
=HYPERLINK(B1, "Click for report")