Shaqada Hyperlink waxay abuurtaa wadooyin gaaban oo u booda meel kale. Shaqada Hyperlink waxay abuuri kartaa isku xirka buugaagta shaqada, dukumeentiyada lagu kaydiyo server-ka shabakada, intranetka, ama internetka markaan gujino unug leh shaqo Hyperlink . Excel wuxuu furi doonaa dukumeentiga la cayimay ama aadi doona meesha ku qoran. Qaabka loo shaqeeyo Hyperlink waa: HYPERLINK (link_location, [friendly_name]) .

Habka isku- xidhka shaqada^{(Hyperlink Function)}

• Link_location : Waddada iyo magaca faylka la furayo, waa loo baahan yahay.
• Friendly_name : Qoraalka ama lambarka ka muuqda unugga. Magaca saaxiibka^{(Friendly_name)} ah waa ikhtiyaari.

Maqaalkani wuxuu sharxi doonaa sida loo abuuro hyperlink xaashida shaqada ee excel iyadoo la adeegsanayo Hyperlink .

Sida loo isticmaalo Excel Hyperlink Function

Tababarkan, waxaanu u samayn doonaa xidhiidhiye sare oo loogu talagalay shakhsiyaadka taariikhiga ah qaarkood ee shaxda.

Guji^(Click) unugga meesha aad rabto in natiijadu noqoto.

Ku qor qaacidada =HYPERLINK ka dib garabka.

Waxaan gali doonaa Link_location^{(Link_location)} . Tusaalaha (fiiri sawirka kore) meesha aad ku aragto URL -ka boggaga, ku qor B2 sababtoo ah goobta aad rabto inaad ku xidho waxay ku taal tiirka URL .

Hadda geli magaca_saaxiibtinimada^{(Friendly_name)} . Magaca saaxiibtinimo ayaa noqon doona xogta ku taal tiirka sawirka taariikhiga ah. Nooca A2 , sababtoo ah waxaan rabnaa inaan isku xirno xogta ku jirta URL iyo tirooyinka taariikhiga ah si wadajir ah. Xir xidhid

Riix Gelida^{(Enter )} waxaad arki doontaa natiijadaada.

Ka soo qaad^(Suppose) inaad rabto inaad aragto natiijooyinka xogta kale adoo isticmaalaya shaqada Hyperlink . Guji^(Click) unugga oo hoos u jiid.

Doorashada kale waa inaad aado Formula . Kooxda Laybareeriga Function^{(Function Library)} , guji Raadinta iyo Tixraaca^{(Lookup and Reference)} ; Liiska hoos-u-dhaca ah, dooro Hyperlink.  Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

On sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , meesha aad ku aragto Link_location , ku qor unugga B2 galay sanduuqa gelitaanka.

Meesha aad ku aragto Friendly_name , ku qor unugga A2 sanduuqa gelitaanka.

Guji, OK ; waxaad arki doontaa natiijada.

Waxaan rajeynayaa in tani ay caawineyso.

How to use Excel Hyperlink Function

Τhe Hyperlink function creates shortcuts that leap to another location. The Hyperlink function can create links to workbooks, documents stored on a network server, intranet, or the internet when we click on a cell with a Hyperlink function. Excel will open the document specified or go to the location listed. The formula for the Hyperlink function is: HYPERLINK (link_location, [friendly_name]).

The syntax for the Hyperlink Function

• Link_location: The path and file name to be open, it is required.
• Friendly_name: The link text or number displayed in the cell. Friendly_name is optional.

This article will explain how to create a hyperlink in an excel worksheet using a Hyperlink function.

How to use Excel Hyperlink Function

In this tutorial, we are going to create a hyperlink for some historical figures in the table.

Click the cell where you want the result to be.

Type the formula =HYPERLINK then bracket.

We are going to enter Link_location. In the example (see in the image above) where you see the URL of the sites, type B2 because the site you want to link to is in the URL column.

Now enter the Friendly_name. The friendly name will be the data located in the historical figure column. Type A2, because we want to link the data in the URL and historical figures column together. Close bracket.

Press Enter you will see your result.

Suppose you want to see results for the other data using the Hyperlink function. Click the cell and drag it down.

The other option is to go to Formula. In the Function Library group, click Lookup and Reference; in the drop-down menu, select Hyperlink. A Function Arguments dialog box will appear.

On the Function Arguments dialog box, where you see Link_location, type the cell B2 into the entry box.

Where you see Friendly_name, type the cell A2 into the entry box.

Click, OK; you will see the result.

I hope this helps.

Related posts

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo isticmaalo Saacadda, Daqiiqada, iyo Shaqada Labaad ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo shaqada IF ee Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10