hyperlinks formula

Iron 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

@chahine 

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.

 

NikolinoDE

I know I don't know anything (Socrates)