$worksheet->Hyperlinks->Add({   
   Anchor          =>  $range1,
   Address         =>  $adr,
   TextToDisplay   =>  $txt,
   ScreenTip       =>  $tip1,
});