Indlela yokusindisa ingoma ye-mp3 ku-Audacity

Ngosizo lwe-hyperlink ku-Excel, ungaxhuma kwamanye amaseli, amathebula, amashidi, ama-workbook e-Excel, amafayela ezinye izinhlelo zokusebenza (izithombe, njll), izinto ezihlukahlukene, izinsiza zewebhu, njll. Bakhonza ngokushesha ukuba bafinyelele into ecacisiwe uma bechofoza esitokisini lapho bafakwa khona. Yiqiniso, kumadokhumende ohlelekile, ukusebenzisa leli thuluzi wamukelekile. Ngakho-ke, umsebenzisi ofuna ukufunda kahle ukuthi angasebenza kanjani ku-Excel nje kudingeka adalule ikhono lokudala nokususa ama-hyperlink.

Okuthakazelisayo: Ukudala ama-hyperlink ku-Microsoft Word

Ukungeza ama-hyperlink

Okokuqala, cabanga ukuthi ungeza kanjani ama-hyperlink kulo mbhalo.

Indlela 1: Faka ama-Hyperlink Anchorless

Indlela elula yokufaka isixhumanisi esingenakuxhumanisa ekhasini lewebhu noma ikheli le-imeyili. I-Bezankornaya hyperlink - lokhu yisixhumanisi esinjalo, ikheli lalo elibhalwa ngokuqondile esitokisini futhi liyabonakala kushidi ngaphandle kokusebenza okungeziwe. Ubuqili be-Excel yukuthi noma yikuphi ukuxhumanisa kwe-bezankorny okufakwe esitokisini, kuphenduka i-hyperlink.

Faka isixhumanisi kunoma iyiphi indawo yeshidi.

Manje uma uchofoza kule seli, isiphequluli esifakiwe ngokuzenzakalelayo siqala phezulu bese siya ekhelini elicacisiwe.

Ngokufanayo, ungafaka isixhumanisi ikheli le-imeyili, futhi lizosebenza ngokushesha.

Indlela 2: isixhumanisi kwifayela noma ikhasi lewebhu nge imenyu yesimo

Indlela evelele kakhulu yokwengeza izixhumanisi ohlwini usebenzise imenyu yokuqukethwe.

1. Khetha iseli lapho sizofaka khona isixhumanisi. Chofoza inkinobho yegundane kwesokudla kuso. Imenyu yomongo ivulwa. Kulo, khetha into "I-Hyperlink ...".



2. Masinyane emva kwalokhu, iwindi lokufaka livula. Kukhona izinkinobho ngakwesokunxele kwewindi, ngokuchofoza komunye umsebenzisi okufanele acacise ukuthi yiluphi uhlobo lento ayifunayo ukuhlanganisa iseli nge:
   • nefayela langaphandle noma ikhasi lewebhu;
   • enezindawo kulo mbhalo;
   • ngedokhumenti entsha;
   • nge-imeyili.

   Njengoba sifuna ukubonisa ukuxhumanisa kwefayela noma ikhasi lewebhu ngale ndlela yokwengeza i-hyperlink, sikhetha into yokuqala. Eqinisweni, akudingekile ukuyikhetha, ngoba iboniswa ngokuzenzakalelayo.



3. Engxenyeni ephakathi kwewindi yindawo Umqhubi ukukhetha ifayela. Ngokuzenzakalelayo I-Explorer vula esihlalweni esifanayo njengencwadi yokusebenza ye-Excel yamanje. Uma into oyifunayo ingenye kwenye ifolda, bese uchofoza inkinobho "Usesho lwefayela"etholakala ngenhla ngaphezu kwendawo yokubuka.



4. Emva kwalokho, ifasitela lokukhetha ifayela elijwayelekile livulwa. Iya kusiqondisi esiyidingayo, thola ifayela lapho sifuna ukuxhumanisa khona iseli, ukhethe bese uchofoza inkinobho "Kulungile".

   

   Qaphela! Ukuze ukwazi ukuhlanganisa iseli nefayela nganoma yisiphi isandiso efasiteleni lokusesha, udinga ukuhlela kabusha ushintsho lohlobo lwefayela "Wonke Amafayela".

5. Ngemuva kwalokho, izixhumanisi zefayela elicacisiwe ziwela engxenyeni ethi "Ikheli" lewindi lokufaka i-hyperlink. Vele uchofoze inkinobho "Kulungile".

Manje i-hyperlink yengezwe, futhi uma uchofoza kwiseli elihambelanayo, ifayela elicacisiwe lizovuleka ohlelweni olufakiwe ukulibuka ngokuzenzakalelayo.

Uma ufuna ukufaka isixhumanisi kumthombo wewebhu, bese usensimini "Ikheli" udinga ukufaka ngesandla i-url noma uyikopishe lapho. Bese uchofoza inkinobho. "Kulungile".

Indlela 3: Xhumanisa endaweni enedokhumenti

Ngaphezu kwalokho, kungenzeka ukuba hyperlink iseli kunoma iyiphi indawo kumqulu wamanje.

1. Ngemuva kokuthi i-cell edingekayo ikhethiwe futhi iwindi lokufaka i-hyperlink libizwa nge-menu yemongo, shintsha inkinobho ngakwesokunxele kwewindi ukuya endaweni "Xhumanisa endaweni eya kumadokhumenti".



2. Ensimini "Faka ikheli leseli" udinga ukucacisa izixhumanisi zeseli okufanele zifakwe kuzo.

   

   Kunalokho, ensimini engezansi, ungakhetha futhi ishidi lale dokhumenti, lapho ushintsho luzokwenzeka uma uchofoza esitokisini. Emva kokukhetha, kufanele uchofoze inkinobho. "Kulungile".

Manje iseli lizohlanganiswa nendawo ethize yencwadi yamanje.

Indlela 4: hyperlink kudokhumenti entsha

Enye indlela i-hyperlink kudokhumenti entsha.

1. Ewindini "Faka i-Hyperlink" khetha into "Xhumanisa kudokhumenti entsha".



2. Engxenyeni ephakathi kwefasitela ensimini "Igama lomqulu omusha" kufanele ikhombise lokho okuzobizwa ngokuthi le ncwadi.



3. Ngokuzenzakalelayo, leli fayela lizotholakala esihlalweni esifanayo njengencwadi yamanje. Uma ufuna ukushintsha indawo, udinga ukuchofoza inkinobho "Shintsha ...".



4. Emva kwalokho, ifasitela lokudala idokhumenti evamile livuleka. Kuzodingeka ukhethe ifolda yendawo kanye nesakhiwo. Emva kwalokho chofoza inkinobho "Kulungile".



5. Ebhokisini lesethingi "Nini ukuhlela idokhumenti entsha" Ungasetha enye yezinketho ezilandelayo: vula idokhumenti ngokuhlela manje, noma udale idokhumenti nokuxhumanisa kuqala, bese kuthi emva kokuvala ifayela lamanje, lihlele. Ngemuva kokuthi zonke izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".

Ngemuva kokwenza lesi senzo, iseli eshadini samanje lizoxhunyaniswa nefayela elisha.

Indlela 5: Isixhumanisi se-imeyili

Iseli ingaxhunyaniswa nesixhumanisi ngisho ne-e-mail.

1. Ewindini "Faka i-Hyperlink" chofoza inkinobho "Xhumanisa ku-imeyili".
2. Ensimini "Ikheli le-imeyli" faka i-e-mail esifuna ukuxhumanisa nayo iseli. Ensimini "Isihloko" Ungabhala isihloko sencwadi. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".

Manje iseli lizohlanganiswa nekheli le-imeyili. Uma uchofoza kuso, iklayenti leposi elizenzakalelayo liqala. I-e-mail echazwe ngaphambilini kanye nesifundo somlayezo izobe sezigcwalisiwe efasiteleni layo.

Indlela 6: Faka i hyperlink ngokusebenzisa inkinobho ebhethini

I-hyperlink ingabuye ifakwe ngokusebenzisa inkinobho ekhethekile kwi-tape.

1. Iya kuthebhu "Faka". Sicindezela inkinobho "I-Hyperlink"etholakala kuthempini ematheni amathuluzi "Izixhumanisi".



2. Emva kwalokho, iwindi iqala. "Faka i-Hyperlink". Zonke izenzo ezengeziwe zifana ncamashi lapho kudlulisa imenyu yemongo. Baxhomeke kuhlobo luni lokuxhumanisa ofuna ukuyisebenzisa.

Indlela 7: Umsebenzi we-HYPERLINK

Ngaphezu kwalokho, i-hyperlink ingadalwa isebenzisa umsebenzi okhethekile.

1. Khetha iseli lapho isixhumanisi sizofakwa khona. Chofoza inkinobho "Faka umsebenzi".



2. Esikhathini sokuvula ifasitela iMasters sibheke igama. "HYPERLINK". Ngemuva kokuba irekhodi litholakala, khetha bese uchofoza inkinobho "Kulungile".



3. Iwindi lempikiswano yokusebenza ivula. HYPERLINK Inemibono emibili: ikheli kanye negama. Owokuqala ungazikhethela, kanti owesibili ukhetha ukuzikhethela. Ensimini "Ikheli" Cacisa ikheli lewebhusayithi, ikheli le-imeyli noma indawo yefayela kwi disk eyinkimbinkimbi ofuna ukuhlanganisa nayo iseli. Ensimini "Igama"uma ufisa, ungabhala noma yiliphi igama elizobonakala esitokisini, ngaleyo ndlela libe ihange. Uma ushiya le ndawo kungenalutho, isixhumanisi sizoboniswa esitokisini. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".

Emva kwalezi zenzo, iseli lizohlanganiswa nento noma isayithi elichazwe kusixhumanisi.

Isifundo: I-Excel Function Wizard

Susa ama-hyperlink

Okubaluleke nakakhulu umbuzo wokukhipha ama-hyperlink, ngoba angase aphelelwe yisikhathi noma ngezinye izizathu kuzodingeka ushintshe isakhiwo somqulu.

Okuthakazelisayo: Ungasusa kanjani ama-hyperlink ku-Microsoft Word

Indlela 1: susa usebenzisa imenyu yesimo

Indlela elula yokususa isixhumanisi ukusebenzisa imenyu yokuqukethwe. Ukuze wenze lokhu, mane uchofoze kuseli lapho isixhumanisi sitholakala khona, chofoza ngakwesokudla. Kumenyu yesimo, khetha into "Susa i-hyperlink". Emva kwalokho izosuswa.

Indlela 2: susa umsebenzi we-HYPERLINK

Uma unesixhumanisi esitokisini usebenzisa umsebenzi okhethekile HYPERLINKke ususe ngendlela engenhla ngeke isebenze. Ukuze ususe, khetha iseli bese uchofoza inkinobho. Susa kwikhibhodi.

Lokhu kuzosusa hhayi kuphela isixhumanisi ngokwaso, kodwa futhi umbhalo, kusukela kulo msebenzi baxhumeke ngokuphelele.

Indlela ye-3: Ama-hyperlink okususa ama-Bulk (i-Excel version 2010 nangaphezulu)

Kodwa yini okufanele uyenze uma kunama-hyperlink amaningi kule dokhumenti, ngoba ukususwa kwebhuku kuzothatha isikhathi esiningi? Esikhathini se-Excel 2010 nangaphezulu kunomsebenzi okhethekile ongasusa izixhumanisi eziningana kumaseli ngesikhathi esisodwa.

Khetha amaseli ofuna ukususa izixhumanisi. Chofoza ngakwesokudla ukuletha imenyu yesimo bese ukhetha "Susa ama-Hyperlink".

Emva kwalokho, kumaseli akhethiwe, ama-hyperlink azosuswa, futhi umbhalo ngokwawo uzohlala.

Uma ufuna ukususa kulo lonke idokhumenti, qala uthayiphe inhlanganisela yekhibhodi ekhibhodi Ctrl + A. Lokhu kuzogqamisa lonke ishidi. Khona-ke, ngokuchofoza inkinobho yegundane kwesokudla, shayela imenyu yokuqukethwe. Kulo, khetha into "Susa ama-Hyperlink".

Qaphela! Le ndlela ayifanele ukususa izixhumanisi uma uxhuma amaseli asebenzisa lo msebenzi HYPERLINK.

Indlela ye-4: Ama-hyperlink asusa ama-Bulk (izinguqulo ngaphambi kuka-Excel 2010)

Yini okufanele uyenze uma une-version ngaphambi kwe-Excel 2010 efakwe kukhompyutha yakho? Ingabe zonke izixhumanisi kufanele zisuswe ngesandla? Kulesi simo, kunendlela yokuphuma, nakuba kuyiyinkimbinkimbi kunendlela echazwe ngendlela eyedlule. Ngendlela, ukhetho olufanayo lungasetshenziswa uma lufiswa, futhi ngezihumusho zamuva.

1. Khetha noma iyiphi iseli elingenalutho kushidi. Faka inombolo kuyo 1. Chofoza inkinobho "Kopisha" kuthebhu "Ikhaya" noma mane uthayiphe isinqamuleli sekhibhodi Ctrl + C.



2. Khetha amaseli lapho ama-hyperlink atholakalayo. Uma ufuna ukukhetha lonke ikholomu, bese uchofoze egameni laso kwibha yezingqimba. Uma udinga ukukhetha lonke ishidi, thayipha inhlanganisela yokhiye Ctrl + A. Chofoza kwento ekhethiwe nge inkinobho yesinxele yegundane. Kumenyu yesimo, chofoza kabili entweni. "Faka okukhethekile ...".



3. Iwindi ekhethekile yokufaka iwindi ivuleka. Ebhokisini lesethingi "Ukusebenza" beka inkinobho endaweni "Yandisa". Sicindezela inkinobho "Kulungile".

Ngemva kwalokho, wonke ama-hyperlink azosuswa, futhi ukufometha kwamaseli akhethiwe kuzosetha kabusha.

Njengoba ubona, ama-hyperlink angaba yithuluzi lokuhambisa elilula, axhumanisa amangqamuzana ahlukene awedokhumenti efanayo, kodwa futhi axhuma ezintweni zangaphandle. Ukususa izixhumanisi kulula ukwenza izinguqulo ezintsha ze-Excel, kodwa kuzinguqulo ezindala zalolu hlelo, kungenzeka futhi ukususa ngokukhululeka kwezixhumanisi ngosizo lwezinhlelo ezihlukile.