Gudaha Microsoft Excel , isticmaaluhu wuxuu isticmaali karaa hyperlink si uu ugu xidho dukumeentiga ku jira xaashida shaqada boggaga internetka, faylasha jira, iyo buugaagta kale ee shaqada. Dhigista Hyperlink ee dukumeenti waxay abuurtaa marin gaaban si loo helo macluumaadka la xidhiidha. Microsoft Excel waxay leedahay astaamo dhowr ah si ay u abuurto hyperlink xaashidaada shaqo. Isku-xidhka sare ayaa hal dukumeenti ku xidhaya mid kale, oo lagu hawlgeliyay iyada oo la dooranayo qoraal ama muuqaal muuqda.

Sida loo abuuro hyperlink gudaha Excel inta u dhaxaysa xaashida

Fur Microsoft Excel

Dooro unug aad rabto inaad dhigto hyperlink.

Guji tabka^(Insert) Gelida

Gelida tab^(Insert) ee kooxda isku xidhka, dhagsii badhanka ^(Links)isku xidhka^(Link) .

Gali sanduuqa wada hadalka Hyperlink^{(Insert Hyperlink)} ayaa soo bixi doona.

Gudaha geli sanduuqa wada-hadalka Hyperlink , ee liiska ^{(Insert Hyperlink)}isku xidhka^(Link) ee bidix ee sanduuqa wada-hadalka, dooro Fayl jira ama Bogga Shabkada^{(Existing File or Web Page)} ; tani waxay u ogolaanaysaa isticmaaluhu inuu ku xidho faylka fayl jira oo kombayutarka ama bogga shabakada

Liiska Fiiri ee^(Look-in) sanduuqa wada-hadalka waxa uu ku siinayaa doorashooyin aad ku baadho faylasha; Xulashooyinkani waa Folders Hadda^{(Current Folders)} , Bogag La Daalacday^{(Browsed Pages)} , iyo Faylalkii^{(Recent Files)} U Danbeeyay .

Waxa kale oo aad ka raadin kartaa faylasha ciwaanka ciwaanka adiga oo gujinaya galka oo dooranaya fayl.

Marka aad dhammayso xulashada faylka sanduuqa wada hadalka, dhagsii OK .

Hyperlink ee^(Hyperlink) dukumeenti aad dooratay ayaa ka muuqda dukumeentiga.

Guji Hyperlink.

Sanduuqa hadalka ee Ogaysiiska Amniga Microsoft Excel^{(Microsoft Excel Security Notice)} ayaa soo muuqan doona, isagoo weydiinaya ogolaansho si loo furo isku xirka galka jira.

Guji Haa^(Yes) .

Daaqad ayaa ku furmi doonta faylka jira.

Xulashada kale ee lagu furayo hyperlink ee faylka jira waa inaad midigta gujiso unugga; Liiska hoos-u-dhaca ah, dooro Links .

Sanduuqa wada hadalka Insert Hyperlink^{(Insert Hyperlink)} ayaa soo bixi doona; raac isla nidaamka kore si aad isku xirto hyperlink iyo fayl jira.

Akhri soo socda^{(Read next)} : Sida loo tirtiro asalka sawirka ee Excel^{(How to remove a picture background in Excel)} .

How to create Hyperlink in Excel between Sheets

In Microsoft Excel, the user can use a hyperlink to connect the document in the worksheet to webpages, existing files, and other workbooks. Placing a Hyperlink into a document creates a shortcut to find related information. Microsoft Excel has several features to create a hyperlink in your worksheet. A hyperlink links one document to another, activated by selecting a highlighted text or image.

How to create hyperlink in Excel between sheets

Open Microsoft Excel

Select a cell where you want to place the hyperlink.

Click the Insert tab.

On the Insert tab in the Links group, click the Link button.

An Insert Hyperlink dialog box will appear.

Inside the Insert Hyperlink dialog box, in the Link list on the left of the dialog box, select an Existing File or Web Page; this allows the user to link the file to an existing file on the  PC or a web Page.

The Look-in list in the dialog box gives you options for searching for files; these options are Current Folders, Browsed Pages, and Recent Files.

You can also search for files from the address bar by clicking the folder and choosing a file.

Once you finish selecting a file from the dialog box, click Ok.

A Hyperlink to the existing document you have selected appears in the document.

Click on the Hyperlink.

A Microsoft Excel Security Notice dialog box will appear, asking permission to open the hyperlink to the existing file.

Click Yes.

A window will open with the existing file.

The other option to open a hyperlink for an existing file is to right-click the cell; in the drop-down list, select Links.

An Insert Hyperlink dialog box will appear; follow the same procedure above to link a hyperlink to an existing file.

Read next: How to remove a picture background in Excel.

Related posts

• Sida loo isticmaalo Excel Hyperlink Function

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo isticmaalo shaqada Mode ee Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

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

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga