hyperlinks formula

Frequent Contributor

hi all

wanted to ask regarding hyperlink formula

if i have a cell with address like [Book1]Sheet2!$C$9, when using hyperlink formula i can simply write hyperlink("#sheet2!$c$9","link"), sometimes i see there is quotation in the sheets like 'sheet2!$c$9' , how to use it properly? please advise 


1 Reply


Basically, everything that works is right and everything that doesn't work can only be wrong (Nikolino's Law :)).

Here are some links with detailed information about links.

HYPERLINK function

Work with links in Excel


Hope I could help you with these information / links.



I know I don't know anything (Socrates)