Dala futhi ususe izixhumanisi ku-Microsoft Office Excel

Usebenzisa ama-hyperlinks e-Excel, ungaxhuma kwamanye amaseli, amatafula, amashidi, izincwadi ze-Excel, amafayela wezinye izinhlelo zokusebenza (izithombe, njll.), Izinto ezahlukahlukene, izinsiza zewebhu, njll. Basebenza ukugxuma ngokushesha entweni ebekiwe lapho uqhafaza kuseli efakwe kulo. Kuyiqiniso, kumbhalo ohlelwe ngokudizayina, ukusetshenziswa kwaleli thuluzi kukhuthazwa kuphela. Ngakho-ke, umsebenzisi ofuna ukufunda ukwenza kahle ku-Excel, umane nje kudingeka kahle ikhono lokwakha nokususa izixhumanisi.

Kuyathakazelisa: Ukwakha izihlanganisi ku-Microsoft Word

Ukungeza izixhumanisi

Okokuqala, sizobheka izindlela zokungeza izixhumanisi kudokhumenti.

Indlela yoku-1: Faka ama-Unchannel Hyperlink

Indlela elula ukufaka isixhumanisi esingafakwanga ekhasini le-web noma ikheli le-imeyili. I-hyperlink ye-anchorless - lokhu kusixhumanisi, ikheli lakhona elibhaliswe ngqo esitokisini futhi liyabonakala ephepheni ngaphandle kokukhohlisa okwengeziwe. Isici sohlelo lwe-Excel ukuthi noma yisiphi isixhumanisi esingesona se-anchor esifakiwe esitokisini siphenduka isixhumanisi.

Faka isixhumanisi kunoma iyiphi indawo eshidi.

Manje, uma uqhafaza kule seli, isiphequluli esifakwe ngokuzenzakalela sizoqala futhi siye ekhelini elibekiwe.

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

Indlela 2: isixhumanisi sefayela noma ikhasi lewebhu ngemenyu yokuqukethwe

Indlela ethandwa kakhulu yokwengeza izixhumanisi eshidini ukusebenzisa imenyu yokuqukethwe.

1. Khetha iseli esizofaka kuso isixhumanisi. Qhafaza kwesokudla kuso. Imenyu yokuqukethwe iyavula. Kuyo, khetha into "Ihyperlink ...".



2. Ngokushesha emva kwalokho, iwindi lokufaka liyavuleka. Izinkinobho zitholakala ohlangothini lwesobunxele lwewindi, ngokuchofoza lapho umsebenzisi kufanele akhombise ukuthi uluhlobo luni lwento afuna ukuyihlanganisa neseli:
   • ngefayela langaphandle noma ikhasi lewebhu;
   • nendawo embhalweni;
   • ngedokhumenti entsha;
   • nge-imeyili.

   Njengoba sifuna ukukhombisa ngale ndlela yokwengeza oxhumano kusixhumanisi sefayela noma ikhasi lewebhu, sikhetha into yokuqala. Empeleni, awudingi ukuyikhetha, ngoba kuboniswa ngokuzenzakalelayo.



3. Engxenyeni ephakathi yewindows indawo I-conductor ukukhetha ifayela. Ngokuzenzakalelayo Isihloli Kuvulwe kumkhombandlela ofanayo njengencwadi yamanje ye-Excel. Uma into oyifunayo itholakala kwenye ifolda, bese uchofoza inkinobho Ukucinga kwefayelaitholakala ngenhla kwendawo yokubuka.



4. Ngemuva kwalokho, iwindi lokukhetha ifayela elijwayelekile liyavuleka. Siya kumkhombandlela esiwudingayo, thola ifayili esifuna ukusihlanganisa neseli, silikhethe bese uchofoza inkinobho "Kulungile".

   

   Ukunaka! Ukuze ukwazi ukuhlanganisa iseli nefayela nganoma yikuphi ukunwetshwa ewindini lokucinga, udinga ukuhambisa uhlobo lokushintsha ifayela ku "Wonke amafayela".

5. Ngemuva kwalokho, izixhumanisi zefayela elicacisiwe liwela emkhakheni we- "Ikheli" wewindi lokufakwa kwehyperlink. Vele uchofoze inkinobho "Kulungile".

Manje i-hyperlink iyangezwa futhi uma uqhafaza kuseli elihambisanayo, ifayela elicacisiwe lizovula ohlelweni olufakiwe ukulibheka ngokuzenzakalelayo.

Uma ufuna ukufaka isixhumanisi kusisetshenziswa sewebhu, bese uyinkambu "Ikheli" udinga ukufaka i-url noma ukukopisha lapho. Bese ucindezela inkinobho "Kulungile".

Indlela 3: xhuma endaweni esembhalweni

Ngaphezu kwalokho, kungenzeka ukuxhumanisa iseli nanoma iyiphi indawo kudokhumenti yamanje.

1. Ngemuva kokuba iseli elifunayo selikhethiwe kanye nefasitela lokufakwa kwehyperlink libizwa ngemenyu yokuqukethwe, shintsha inkinobho ngakwesobunxele sewindi liye endaweni "Xhuma ukuze ubeke kudokhumenti".



2. Ensimini "Faka ikheli leselula" Kufanele ucacise izixhumanisi zeseli ohlela ukuzisebenzisa.

   

   Esikhundleni salokho, enkambeni engezansi, ungaphinde ukhethe ishidi lale dokhumenti, lapho ukuguqulwa kuzokwenziwa khona lapho uchofoza kuseli. Ngemuva kokuthi ukhetho lwenziwe, chofoza inkinobho "Kulungile".

Manje iseli lizohlotshaniswa nendawo ethile encwadini yamanje.

Indlela 4: isixhumanisi sedokhumenti entsha

Enye inketho isixhumanisi sedokhumenti entsha.

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



2. Engxenyeni emaphakathi yewindi enkundleni "Igama ledokhumenti elisha" kufanele ukhombise ukuthi le ncwadi izobizwa kanjani.



3. Ngokuzenzakalelayo, leli fayela lizobekwa enkombeni efanayo nencwadi yamanje. Uma ufuna ukushintsha indawo, kufanele uchofoze inkinobho "Shintsha ...".



4. Ngemuva kwalokho, iwindi elijwayelekile lokwakha idokhumenti liyavula. Uzodinga ukukhetha ifolda yokubekwa kwayo nefomethi. Ngemuva kwalokho chofoza inkinobho "Kulungile".



5. Ebhuthini yezilungiselelo "Ungahlela nini idokhumenti entsha" Ungasetha enye yamapharamitha alandelayo: khona manje vula idokhumenti ukuze uyihlele, noma uqale wakhe idokhumenti uqobo nesixhumanisi, futhi lapho kuphela, ngemuva kokuvala ifayela lamanje, ulihlele. Ngemuva kokuthi wonke amasethingi enziwe, chofoza inkinobho "Kulungile".

Ngemuva kokwenza lesi senzo, iseli eshidi lamanje lizoxhunyaniswa ngoxhumano lwefayela elisha.

Indlela yesi-5: Ukuxhumana nge-imeyili

Iseli elisebenzisa isixhumanisi lingahlotshaniswa ne-imeyili.

1. Ewindini Faka i-Hyperlink chofoza inkinobho Xhuma ku-imeyili.
2. Ensimini Ikheli le-imeyili faka i-imeyili esifuna ukuyihlanganisa neseli. Ensimini Itimu Ungabhala umugqa wesihloko. Ngemuva kokuthi izilungiselelo seziqediwe, chofoza inkinobho "Kulungile".

Iseli manje selizohlotshaniswa nekheli le-imeyili. Uma uchofoza kukho, kuzokwethulwa iklayenti le-imeyili elizenzakalelayo. Ewindini lawo, i-imeyili ne-imeyli ebekiwe ngaphambili kuzogcwaliswa kusixhumanisi.

Indlela yesi-6: faka oxhumano ngenkinobho ekubambeni

Ungafaka futhi isixhumanisi ngokusebenzisa inkinobho ekhethekile kubambo.

1. Iya kuthebhu Faka. Chofoza inkinobho "Ihyperlink"etholakala ethepheni kubhulokhi bamathuluzi "Izixhumanisi".



2. Ngemuva kwalokho, iwindows iyaqala Faka i-Hyperlink. Zonke ezinye izinto ziyafana ncamashi lapho unamathisela imenyu yokuqukethwe. Zincike ekutheni hlobo luni lwesixhumanisi ofuna ukusisebenzisa.

Indlela yesi-7: Umsebenzi weHyperlink

Ngaphezu kwalokho, i-hyperlink ingadalwa kusetshenziswa umsebenzi okhethekile.

1. Khetha iseli okuzofakwa kulo isixhumanisi. Chofoza inkinobho "Faka umsebenzi".



2. Ewindini elivulayo, i-Function Wizard ibheka igama "HYPERLINK". Ngemuva kokuthi irekhodi litholakele, likhethe bese uchofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana ngomsebenzi liyavula. I-HYPERLINK inezimpikiswano ezimbili: ikheli negama. Okokuqala kwalokhu kuyimpoqo, kanti okwesibili kungokuzithandela. Ensimini "Ikheli" ikhombisa ikheli lendawo, i-imeyili noma indawo yefayela kwi-hard drive ofuna ukuyihlanganisa neseli. Ensimini "Igama", uma ufisa, ungabhala noma yiliphi igama elizobonakala esitokisini, ngaleyo ndlela libe yi-anchor. Uma ushiya le nkambu ingenalutho, isixhumanisi siyovele sikhonjiswe kuseli. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho "Kulungile".

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

Isifundo: Umsebenzi Wizard e-Excel

Isusa izixhumanisi

Akubalulekile kangako umbuzo wokuthi ungawasusa kanjani ama-hyperlinks, ngoba angaphelelwa yisikhathi noma ngenxa yezizathu ezithile kuzodingeka ukuthi kuguqulwe ukwakheka kombhalo.

Kuyathakazelisa: Ungasusa kanjani izixhumanisi ezilinganayo kwiMicrosoft Word

Indlela yoku-1: susa usebenzisa imenyu yokuqukethwe

Indlela elula yokususa isixhumanisi ukusebenzisa imenyu yokuqukethwe. Ukuze wenze lokhu, chofoza nje kuseli lapho isixhumanisi sitholakala khona, chofoza kwesokudla. Kumenyu yokuqukethwe, khetha Susa i-Hyperlink. Ngemuva kwalokho kuzosuswa.

Indlela 2: khipha umsebenzi woxhumano

Uma unesixhumanisi esitokisini usebenzisa umsebenzi okhethekile I-HYPERLINK, bese uyisusa ngendlela engenhla ayisebenzi. Ukususa, khetha iseli bese uchofoza inkinobho Susa kwikhibhodi.

Lokhu kuzosusa hhayi isixhumanisi uqobo, kodwa futhi nombhalo, ngoba kulo msebenzi baxhumeke ngokuphelele.

Indlela 3: susa izixhumanisi ezinkulu (Excel 2010 and future)

Kepha kuthiwani uma kunama-hyperlink amaningi kudokhumenti, ngoba ukususwa ngesandla kuzothatha isikhathi eside? Ku-Excel 2010 nangaphezulu, kunomsebenzi okhethekile ongasusa kuwo ubudlelwano obuningi kumaseli ngasikhathi sinye.

Khetha amaseli lapho ufuna ukususa izixhumanisi. Qhafaza kwesokudla ukuletha imenyu yokuqukethwe bese ukhetha Susa izixhumanisi.

Ngemuva kwalokho, izixhumanisi ezisele kumaseli akhethiwe zizosuswa, futhi umbhalo uqobo uzohlala.

Uma ufuna ukususa lonke idokhumenti, qala ngokuthayipha isinqamuleli sekhibhodi kukhibhodi I-Ctrl + A. Lokhu kukhetha lonke ishidi. Ngemuva kwalokho, ngokuchofoza kwesokudla, shayela imenyu yokuqukethwe. Kuyo, khetha Susa izixhumanisi.

Ukunaka! Le ndlela ayifanele ukususa izixhumanisi uma uxhumanisa amaseli usebenzisa umsebenzi I-HYPERLINK.

Indlela 4: ukususa ngobuningi izixhumanisi (izinguqulo ngaphambili kwe-Excel 2010)

Yini okufanele uyenze uma une-version ngaphambili kwe-Excel 2010 efakwe kukhompyutha yakho? Ngabe zonke izixhumanisi zizosuswa ngesandla? Kulokhu, kukhona futhi indlela yokuphuma, yize kuyinkimbinkimbi ngokwedlula inqubo echazwe kwendlela edlule. Ngendlela, inketho efanayo ingafakwa uma ifiseleka ezinguqulweni zakamuva.

1. Khetha noma isiphi isitokisi esingenalutho eshidini. Sibeka kuyo inombolo 1. Chofoza inkinobho Kopisha kuthebhu "Ikhaya" noma vele uthayiphe isinqamuleli sekhibhodi I-Ctrl + C.



2. Khetha amaseli lapho ama-hyperlink akhiwe khona. Uma ufuna ukukhetha ikholamu yonke, bese uchofoza igama layo kupaneli evundlile. Uma ufuna ukukhetha lonke ishidi, thayipha inhlanganisela yezinkinobho I-Ctrl + A. Qhafaza kwesokudla entweni ekhethiwe. Kumenyu yokuqukethwe, chofoza kabili entweni "Faka okhethekile ...".



3. Kuvulwa iwindi elikhethekile lokufaka. Ebhuthini yezilungiselelo "Ukusebenza" beka inkinobho eshintshiwe Kakhulu. Chofoza inkinobho "Kulungile".

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

Njengoba ukwazi ukubona, ama-hyperlink angaba ithuluzi lokuhamba elingena kalula elixhumanisa hhayi kuphela amaseli ahlukile ombhalo owodwa, kepha futhi lenze ukuxhumana ngezinto zangaphandle. Ukususa izixhumanisi kulula ukukwenza ezinhlotsheni ezintsha ze-Excel, kepha futhi ezinhlelweni ezindala zohlelo kukhona nekhono lokwenza ukususwa kwesisindo kwezixhumanisi usebenzisa amaqhinga ahlukile.