Ungayenza kanjani noma ususe ama-hyperlinks ku-Excel

Ngosizo lwama-hyperlinks ku-evelle, ungabhekisa kwamanye amaseli, amatafula, amashidi, izincwadi ze-Excel, amafayela ezinye izinhlelo zokusebenza (izithombe, njll.), Izinto ezahlukahlukene, izinsizakusebenza zeWebhu, njll. Basebenza ukuthi basheshe baye entweni ebekiwe lapho bechofoza esitokisini lapho befakiwe khona. Vele, kudokhumenti ehlelwe kanzima, ukusetshenziswa kwaleli thuluzi kwamukelekile. Ngakho-ke, umsebenzisi ofuna ukufunda ukusebenza kahle ku-Afpelle kumane nje kudingekile ukuze akwazi kahle ikhono lokudala nokususa ama-hyperlink.

Kuyathakazelisa: Ukwakha i-hyperlink ku-Microsoft Word

Ukungeza i-Hypersrils

Okokuqala, cabanga ngezindlela zokwengeza i-hyperlink kudokhumenti.

Indlela 1: Ukufaka i-Nonsense Hyperlink

Indlela elula yokufaka isixhumanisi esingenangqondo ekhasini le-Web noma ikheli le-imeyili. Isixhumanisi esingenangqondo - lesi sixhumanisi esinjalo, ikheli layo elinqunywe ngqo esitokisini futhi liyabonakala ephepheni ngaphandle kokukhohlisa. Isici sohlelo lwe-Excel ukuthi noma iyiphi ireferensi engenangqondo efakwe esitokisini iphenduka kwi-hyperlink.

Faka isixhumanisi kunoma iyiphi indawo yeshidi.

Manje, uma uqhafaza kuleli ngqathiso, isiphequluli sizoqala, esisethwe ngokuzenzakalelayo, bese sihamba ekhelini elibekiwe.

Ngokufanayo, ungabeka isixhumanisi ekhelini le-imeyili, futhi lizosebenza ngokushesha.

Indlela 2: Ukuxhumana ngefayela noma ikhasi le-Web ngokusebenzisa imenyu yokuqukethwe

Indlela ethandwa kakhulu yokwengeza izixhumanisi zokuxhumanisa ukusebenzisa imenyu yokuqukethwe.

1. Sigqamisa iseli lapho sizofaka ukuxhumana khona. Qhafaza kwesokudla kulo. Imenyu yomongo iyavula. Kuyo, khetha into "hyperlink ...".



2. Masinyane nje emva kwalokho iwindi lokufaka livuleka. Ngakwesobunxele kwewindi, izinkinobho zitholakala ngokuchofoza komunye umsebenzi okufanele akwazise ngazo ngento ethile efuna ukubopha iseli:
   • ngefayela langaphandle noma ikhasi le-web;
   • nendawo edokhumenti;
   • ngedokhumenti entsha;
   • nge-imeyili.

   Njengoba sifuna ukukhombisa ngale ndlela ukwengeza i-hyperlink ngesixhumanisi esinefayili noma ikhasi le-web, sikhetha into yokuqala. Empeleni, akudingekile ukuyikhetha, njengoba kuboniswa ngokuzenzakalelayo.



3. Engxenyeni ephakathi yewindows kukhona indawo yomqhubi ukukhetha ifayela. Ngokuzenzakalelayo, umqhubi we-conductor uvulekile kwisikhombi esifanayo lapho kutholakala khona incwadi yamanje ye-Excel. Uma into oyifunayo ingenye ifolda elinye, kufanele uchofoze inkinobho ethi "Ukucinga Kwefayela", etholakala ngenhla kwendawo ye-Ferris.



4. Ngemuva kwalokho, iwindi lokukhetha ifayela elijwayelekile liyavula. Iya ku-Directory oyidingayo, sithola ifayela esifuna ukuluxhumanisa nalo iseli, sabela bese sichofoza inkinobho ethi "KULUNGILE".

   

   QAPHELA! Ukuze ukwazi ukuhlobanisa iseli ngefayela nganoma yisiphi isandiso ebhokisini lokusesha, udinga ukuhlela kabusha izinhlobo zefayela Shita ku- "Wonke amafayela".

5. Ngemuva kwalokho, izixhumanisi zefayela elibekiwe liwela emkhakheni we- "ikheli" lokufakwa kwe-hyperlink. Mane ucindezele inkinobho ethi "Kulungile".

Manje i-hyperlink ingeziwe nokuthi uchofoza nini kuseli elifanele, ifayela elicacisiwe lizovuleka kulolu hlelo olufakiwe ukuze lukubuke ngokuzenzakalelayo.

Uma ufuna ukufaka isixhumanisi kumthombo wewebhu, khona-ke enkombeni yekheli odinga ukuyifaka ngesandla i-URL noma uyikopishe lapho. Ngemuva kwalokho kufanele uchofoze inkinobho ethi "Kulungile".

Indlela 3: Ukuxhumana nendawo edokhumenti

Ngaphezu kwalokho, kungenzeka ukuhlobanisa iseli le-hyperlink nganoma iyiphi indawo kudokhumenti yamanje.

1. Ngemuva kokuthi iseli elifiselekayo likhethiwe futhi libangelwa yimenyu yokuqukethwe yewindi lokufaka le-hyperlink, sishintsha inkinobho ngakwesobunxele sewindows "isikhundla sedokhumenti".



2. Esigabeni "faka ikheli leselula" udinga ukucacisa izixhumanisi zamaseli okufanele ubhekiswe kukho.

   

   Esikhundleni salokho, ishidi lale dokhumenti lingakhethwa nasensimini ephansi lapho kuguqulwa khona lapho uchofoza esitokisini. Ngemuva kokukhethwa kwenziwa, kufanele uchofoze inkinobho ethi "KULUNGILE".

Manje iseli lizohlotshaniswa nendawo ethile yencwadi yamanje.

Indlela 4: I-Hyperlink kudokhumenti entsha

Enye inketho i-hyperlink kudokhumenti entsha.

1. Ewindini elithi "Insert Hyperlinks", khetha into ethi "Thinta ngedokhumenti entsha".



2. Engxenyeni ephakathi yewindi "egameni le-New Donserm", kufanele usho ukuthi incwadi eyenziwe ngayo izobizwa kanjani.



3. Ngokuzenzakalelayo, leli fayela lizofakwa kwisikhombi esifanayo nencwadi yamanje. Uma ufuna ukushintsha indawo, udinga uchofoze inkinobho ethi "Hlela ...".



4. Ngemuva kwalokho, iwindi lokudalwa kwamadokhumenti ajwayelekile liyavuleka. Uzodinga ukukhetha ifolda yokubekwa kwayo nefomethi yayo. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



5. Ku-block yezilungiselelo "Uma ufaka idokhumenti entsha", ungabeka enye yamapharamitha alandelayo: manje vula idokhumenti ukuze ushintshe, noma okokuqala dala idokhumenti uqobo kanye nesixhumanisi, futhi vele ngemuva kokuvala ifayela lamanje, likuhlele. Ngemuva kokuba konke izilungiselelo kwenziwe, chofoza inkinobho ethi "Kulungile".

Ngemuva kokwenza lesi senzo, iseli eshidini lamanje lizoxhunyaniswa yi-hyperlink enefayela elisha.

Indlela 5: Ukuxhumana nge-imeyili

Iseli elisebenzisa isixhumanisi lingahlotshaniswa ngisho nange-imeyili.

1. Ewindini elithi "Insert Hyperlinks", chofoza inkinobho ethi "Tie nge-imeyili".
2. Emkhakheni we- "imeyili Ikheli", faka i-imeyili esifuna ukuhlobana ngayo iseli. In the "Theme" field, ungabhala isihloko sezinhlamvu. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho ethi "Kulungile".

Manje iseli lizohlotshaniswa nekheli le-imeyili. Uma uqhafaza kuyo, iklayenti le-imeyili elisethwe ngokuzenzakalelayo selikathunyelwa. Iwindi layo lizogcwaliswa isixhumanisi se-imeyili kanye nesihloko somlayezo.

Indlela 6: Ukufaka ama-hyperlink ngokusebenzisa inkinobho ku-Ribbon

I-hyperlink ingafakwa futhi ngenkinobho ekhethekile ku-ribbon.

1. Iya kuthebhu ethi "Insert". Sichofoza inkinobho ethi "hyperlink", etholakala ethepheni amathuluzi "ezixhumanisi".



2. Emva kwalokho, iwindi le- "Insert Hyperlinks" liqala. Zonke ezinye isenzo ziyefana ngokufanayo nalapho zifaka imenyu yokuqukethwe. Zincike kuhlobo luni lwesixhumanisi ofuna ukusifaka.

Indlela 7: Umsebenzi we-Hyperlink

Ngaphezu kwalokho, i-hyperlink ingadalwa kusetshenziswa umsebenzi okhethekile.

1. Sigqamisa iseli lapho kuzofakwa khona isixhumanisi. Chofoza inkinobho ethi "PASTE function".



2. Ewindini elisebenzayo lemisebenzi yeWizard, lifuna igama elithi "hyperlink". Ngemuva kokuqoshwa kutholakele, sikugqamisa bese sichofoza inkinobho ethi "Kulungile".



3. Ukuphikisana nomsebenzi kuyavuleka. I-hyperlink inezimpikiswano ezimbili: ikheli negama. Owokuqala uyaphoqelekile, futhi owuthandayo. Insimu ethi "Ikheli" ikhombisa ikheli lesayithi, i-imeyili noma indawo yefayela kwi-hard disk lapho ufuna ukuxhuma khona iseli. In the "Igama" field, uma lifiswa, ungabhala noma yiliphi igama elizobonakala esitokisini, ngaleyo ndlela waba yi-anchor. Uma ushiya le nkambu ingenalutho, isixhumanisi sizokhonjiswa esitokisini. Ngemuva kokuthi izilungiselelo zenziwa, chofoza inkinobho ethi "Kulungile".

Ngemuva kwalezi zenzo, iseli lizohlotshaniswa nento noma isayithi, elibhalwe kusixhumanisi.

Isifundo: Imisebenzi yeWizard ku-Excel

I-Physersril Removal

Akubalulekile ukuthi umbuzo wokuthi ungazisusa kanjani izixhumanisi, ngoba zingathukuthela noma ngenxa yezinye izizathu ozodinga ukushintsha ukwakheka kwedokhumenti.

Kuyathakazelisa: Ungazisusa Kanjani Izixhumanisi KuMicrosoft Word

Indlela 1: Ukususa usebenzisa imenyu yokuqukethwe

Indlela elula yokususa isixhumanisi ukusebenzisa imenyu yokuqukethwe. Ukuze wenze lokhu, vele uchofoze esitokisini, lapho isixhumanisi sitholakala khona, chofoza kwesokudla. Kumenyu yokuqukethwe, khetha into ethi "Delete Hyperlink". Ngemuva kwalokho, izosuswa.

Indlela 2: Ukususa umsebenzi we-hyperlink

Uma unesixhumanisi esitokisini usebenzisa isici esikhethekile se-hyperlink, khona-ke ngeke kwenzeke ukukususa ngale ndlela engenhla. Ukususa, udinga ukugqamisa iseli bese uqhafaza inkinobho yokususa kwikhibhodi.

Kulokhu, hhayi nje isixhumanisi uqobo kuphela esizosuswa, kodwa futhi nombhalo, ngoba axhumeke ngokuphelele kulo msebenzi.

Indlela 3: Ukususwa kweMisa lama-Hyperlinks (inguqulo ye-Excel 2010 nangaphezulu)

Kepha yini okufanele yenze uma kunesixhumanisi esiningi kudokhumenti, ngoba ukususwa kwe-Manual kuzothatha isikhathi esiningi? Ku-Excel 2010 nangaphezulu, kunomsebenzi okhethekile ongawukhipha kuwo ukuxhumana okuningana ngasikhathi sinye kumaseli.

Khetha amaseli ofuna ukususa izixhumanisi. Qhafaza kwesokudla imenyu yokuqukethwe bese ukhetha u- "Delete Hyperlinks".

Ngemuva kwalokho, kumaseli akhethiwe ama-hyperlink azosuswa, futhi umbhalo uqobo uzosala.

Uma ufuna ukususa kulo lonke idokhumenti, uqala ukushayela uCtrl + okhiye kwikhibhodi. Ngalokhu, ugcizelela lonke ishidi. Ngemuva kwalokho, ngokuchofoza inkinobho yegundane kwesokudla, shayela imenyu yokuqukethwe. Kuyo, khetha u- "Delete Hyperlinks".

QAPHELA! Le ndlela ayifanele ukususa izixhumanisi uma ubopha amaseli usebenzisa umsebenzi we-hyperlink.

Indlela 4: Ukususwa Okusisindo Kwama-Hyperlink (inguqulo phambilini phambilini ngo-2010)

Kuthiwani uma unenguqulo yangaphambilini ye-Excel 2010 kwikhompyutha yakho? Ngabe zonke izixhumanisi kufanele zisuswe ngesandla? Kulokhu, futhi kunendlela yokuphuma, yize kuyinkimbinkimbi kakhulu kunenqubo echazwe ngendlela eyedlule. Ngendlela, inketho efanayo ingafakwa uma ufisa ezinguqulweni zakamuva.

1. Sigqamisa noma yisiphi iseli esingenalutho eshidini. Sibeka idijithi kuyo 1. Chofoza inkinobho ethi "Kopisha" kuthebhu "Yasekhaya" noma umane uthole inhlanganisela ye-CTRL + C.



2. Khetha amaseli lapho ama-hyperlink atholakala khona. Uma ufuna ukukhetha ikholomu yonke, bese uchofoza igama laso kwiphaneli evundlile. Uma ufuna ukugqamisa lonke ishidi, thayipha ikhibhodi ye-CTRL + ikhibhodi. Chofoza endaweni egqanyisiwe ngenkinobho yegundane efanele. Kumenyu yokuqukethwe, chofoza kabili ku- "Faka okukhethekile ..." into.



3. Kuvulwa iwindi elikhethekile. In the Izilungiselelo "Operation" ZAMAHHALA, Sibeka i-Shintle esimweni esithi "SUMPMPTPPL". Chofoza inkinobho ethi "KULUNGILE".

Ngemuva kwalokho, wonke ama-hyperlink azosuswa, futhi ukufometha kwamaseli akhethiwe kusethwe kabusha.

Njengoba ukwazi ukubona, ama-hyperlink angaba yithuluzi elilungele ukuzulazula elixhuma hhayi amaseli ahlukene kuphela wedokhumenti elilodwa, kodwa futhi enze ukuxhumana ngezinto zangaphandle. Ukususa izixhumanisi kulula ukwenza ngezinguqulo ezintsha ze-Excel, kepha futhi nasezinhlotsheni zakudala zohlelo, kukhona nethuba elisebenzisa ukukhohlisa okukodwa ukukhiqiza ukususwa kweMisa.