Uke wazibuza ukuthi ungeza kanjani ama-hyperlink, amabhukumaka kanye / noma izixhumanisi ze-mail ku-Excel? Izimpendulo zilapha.
Okokuqala, ake sicacise ukuthi sisho ukuthini ngekota ngayinye.
I- hyperlink ingacaciswa ukuze igxume kusuka ephepheni lokusebenzela ekhasini lewebhu, futhi lingasetshenziswa ku-Excel ukunikeza ukufinyelela okusheshayo nokulula kwamanye ama-workbook e-Excel.
Ibhukhimakhi lingasetshenziselwa ukudala isixhumanisi endaweni ethile kwiphepha lokusebenzela lamanje noma kwiphepha lokusebenzela elihlukile ngaphakathi kwefayela elifanayo le-Excel ngokusebenzisa izinkomba zocingo.
Isixhumanisi se-imeyili siyisixhumanisi sekheli le-imeyli. Ukuchofoza kusixhumanisi se-mail kuvula iwindi lomlayezo omusha ohlelweni lwe-imeyli elizenzakalelayo bese kufaka ikheli le-imeyili ngemuva kwesixhumanisi ku-Umzila womlayezo.
Ku-Excel, kokubili ama-hyperlink namabhukhimakhi ahloselwe ukwenza kube lula kubasebenzisi ukuthi bahambe phakathi kwezindawo zedatha ehlobene. Ama-mailto links enza kube lula ukuthumela umyalezo we-imeyili kumuntu ngamunye noma inhlangano. Kuzo zonke izimo:
- Kungakhathaliseki ukuthi yikuphi uhlobo lokuxhumanisa oludalwa - i-hyperlink, ibhukhimakhi, noma isixhumanisi se-mail - ifakwe ebhokisini lebhokisi lengxoxo ye- Insert Hyperlink .
- Njengezixhumanisi kumakhasi wewebhu, izixhumanisi ku-Excel zinamathele embhalweni we-anchor osesithombeni sephepha lokusebenzela.
- Ukwengeza lo mbhalo we-anchor ngaphambi kokuvula ibhokisi lengxoxo kucacisa umsebenzi wokudala isixhumanisi, kodwa ungangeniswa ngemuva kokuba ibhokisi lengxoxo livuliwe.
Vula ibhokisi lokuxhuma le-Hyperlink
Inhlanganisela eyinhloko yokuvula ibhokisi lokungena le- Hyperlink i- Ctrl + K ku-PC noma i- Command + K kwi-Mac.
- Ekhasini lokusebenzela lase-Excel, chofoza kuseli okumele libe ne-hyperlink ukwenza kube iseli elisebenzayo.
- Thayipha igama ukuze usebenze njengombhalo we-anchor njenge "Amaspredishithi" noma "Juni_Sales.xlsx" bese ucindezela ukhiye we- Enter ekhibhodi.
- Chofoza kuseli ngombhalo wesikebhe okwesibili.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula ikhi le- K ekhibhodi ukuvula ibhokisi lengxoxo ye- Hyperlink .
Indlela Yokuvula Ibhokisi Lezingxoxo ze-hyperlink usebenzisa iMenyu Yokufaka
- Ekhasini lokusebenzela lase-Excel, chofoza kuseli okumele libe ne-hyperlink ukwenza kube iseli elisebenzayo.
- Faka umbhalo we-anchor esitokisini bese ucindezela ukhiye we- Enter ekhibhodi.
- Chofoza kuseli ngombhalo wesikebhe okwesibili.
- Chofoza ku- Faka ku-bar yemenyu.
- Chofoza ku-icon ye- Hyperlink ukuze uvule ibhokisi lengxoxo ye- Insert Hyperlink .
Ukungeza ama-Hyperlink ku-Excel
Ungasetha i hyperlink ukuze ugxume ekhasini lewebhu noma kwifayela le-Excel. Nansi indlela:
Ukungeza i-Hyperlink ekhasini lewebhu
- Vula ibhokisi lengxoxo ye- Hyperlink usebenzisa enye yezindlela ezichazwe ngenhla.
- Chofoza kwi- Web Page noma ithebhu yefayela .
- E- Address line, thayipha ikheli le-URL eligcwele.
- Chofoza OK ukuqedela oxhumano bese uvala ibhokisi lengxoxo.
- Umbhalo we-anchor esitokisini sephepha lokusebenzela kufanele manje ube obala okwesibhakabhaka futhi ugcizelelwe ubonisa ukuthi uqukethe uxhumano. Noma nini uma uchofozwa, izovula iwebhusayithi ekhethiwe kwisiphequluli esizenzakalelayo.
Ukungeza i-Hyperlink kufayela le-Excel
- Vula ibhokisi lengxoxo ye- Hyperlink .
- Chofoza kwifayela elikhona noma ithebhu lewebhu lewebhu .
- Chofoza ku- Khetha bese upheqa ukuze uthole igama lefayela le-Excel. Ukuchofoza igama lefayili kuyanezela ekhelini lekheli kwibhokisi lengxoxo.
- Chofoza OK ukuqedela oxhumano bese uvala ibhokisi lengxoxo.
- Umbhalo we-anchor esitokisini sephepha lokusebenzela kufanele manje ube obala okwesibhakabhaka futhi ugcizelelwe ubonisa ukuthi uqukethe uxhumano. Noma nini uma uchofozwa, izovula i-Excel yokusebenzela ibhuku.
Ukudala amabhukhimakhi kuWebhu lokusebenzela elifanayo le-Excel
Ibhukumaka ku-Excel ifana ne-hyperlink ngaphandle kokuba isetshenziselwa ukwakha isixhumanisi endaweni ethile kwiphepha lokusebenzela langamanje noma kwiphepha elihlukile lomsebenzi ngaphakathi kwefayela elifanayo le-Excel.
Ngenkathi ama-hyperlink esebenzisa amagama wefayela ukudala izixhumanisi kwamanye amafayela e-Excel, amabhukhimakhi asebenzisa amareferensi weselula namagama wephepha lokusebenzela ukudala izixhumanisi.
Indlela Yokwakha Ibhukhimakhi ekhasini elifanayo lomsebenzi
Isibonelo esilandelayo sakha ibhukhimakhi endaweni ehlukile kwipheshethi elifanayo le-Excel.
- Thayipha igama esitokisini elizokwenza njengombhalo we-anchor webhukimakhi bese ucindezela u- Enter .
- Chofoza kulelo seli ukuze lenze iseli elisebenzayo.
- Vula ibhokisi lengxoxo ye- Hyperlink .
- Chofoza kuThebhu Le Matokhumenti .
- Ngaphansi kohlobo lweferensi yeseli , faka ireferensi yeseli endaweni ehlukile ekhasini elifanayo lomsebenzi - njenge "Z100."
- Chofoza u- OK ukuqedela ibhukumaka bese uvale ibhokisi lengxoxo.
- Umbhalo we-anchor esitokisini sephepha lokusebenzela kumele ube nobuluhlaza okwesibhakabhaka futhi ugcizelelwe obonisa ukuthi uqukethe ibhukumaka.
- Chofoza kubhukimakhi futhi isikhombisi esisebenzayo sesikhombisi sithuthela kufereferensi yeseli efakwe kubhukimakhi.
Ukudala amabhukhimakhi kuya kumafomu okusebenza ahlukene
Ukudala amabhukimakhi kumashidi okusebenza ahlukene ngaphakathi kwefayela elifanayo le-Excel noma ibhuku elinomsebenzi unesinyathelo esengeziwe sokukhomba ishidi lokusebenzela eliya khona lebhukimakhi. Ukuqamba kabusha ama-worksheets kungenza kube lula ukudala amabhukumaka kumafayela anenani elikhulu lamashidi okusebenza.
- Vula ibhuku le-Excel ye-multiple-sheet noma wengeze amanye amashidi efayeleni elilodwa leshidi.
- Ngenye yamashidi, thayipha igama esitokisini ukuze wenze njengombhalo we-anchor webhukimakhi.
- Chofoza kulelo seli ukuze lenze iseli elisebenzayo.
- Vula ibhokisi lengxoxo ye- Hyperlink .
- Chofoza kuThebhu Le Matokhumenti .
- Faka ireferensi yeseli emkhakheni ngaphansi kohlobo olusethempelini yeseli .
- Ku- Or ukhethe indawo kule nkundla yedokhumenti , chofoza igama leshidi eliya khona. Amashidi angashiwo amagama abhekwa njengeSheet1, Sheet2, Sheet3 njalonjalo.
- Chofoza u- OK ukuqedela ibhukumaka bese uvale ibhokisi lengxoxo.
- Umbhalo we-anchor esitokisini sephepha lokusebenzela kumele ube nobuluhlaza okwesibhakabhaka futhi ugcizelelwe obonisa ukuthi uqukethe ibhukumaka.
- Chofoza kubhukimakhi futhi isikhombisi esisebenzayo sesikhumbuzo kufanele sithuthele esitokisini sesithenjwa kushidi elifakwe kubhukimakhi.
Faka i-Mailto Xhuma kwifayela le-Excel
Ukwengeza ulwazi lokuxhumana kuphepha lokusebenzela le-Excel kwenza kube lula ukuthumela i-imeyili evela ngaphakathi kwedokhumenti.
- Thayipha igama esitokisini elizokwenza njengombhalo we-anchor wokuxhumanisa ngeposi. Cindezela u- Enter .
- Chofoza kulelo seli ukuze lenze iseli elisebenzayo .
- Vula ibhokisi lengxoxo ye- Hyperlink .
- Chofoza kuthebhu yekheli le-imeyli .
- Ku- imeyili yekheli lekheli , faka ikheli le-imeyili lomamukeli wesikhangiso. Leli kheli lifakwe kulayini lomlayezo omusha we-imeyili uma isixhumanisi sikchofoza.
- Ngaphansi kolayini we- Subject , faka isihloko se-imeyili. Lo mbhalo ufakwe ohlwini lokufunda emlayezo omusha.
- Chofoza u- OK ukuqedela isixhumanisi se-mail bese uvale ibhokisi lengxoxo.
- Umbhalo we-anchor esitokisini sephepha lokusebenzela kufanele manje ube obala okwesibhakabhaka futhi ugcizelelwe ubonisa ukuthi uqukethe uxhumano.
- Chofoza kusixhumanisi se-mail, futhi uhlelo oluzenzakalelayo lwe-imeyili kufanele luvule umlayezo omusha nekheli kanye nombhalo ongena kuwo.
Ukususa i-Hyperlink ngaphandle kokukhipha umbhalo we-Anchor
Uma ungasayidingi i-hyperlink, ungakwazi ukususa ulwazi lokuxhumanisa ngaphandle kokukhipha umbhalo owakhonza njengehange.
- Beka i-pointer yegundane phezu kwe-hyperlink ukuze isuswe. I-pointer yomcibisholo kufanele ishintshe esandleni sophawu.
- Chofoza ngakwesokudla umbhalo wokuxhumanisa we-hyperlink ukuvula imenyu ye - Context dropdown.
- Chofoza ku- Susa I-Hyperlink inketho kwimenyu.
- Umbala okwesibhakabhaka nomgqa ophansi kufanele ususwe embhalweni we-anchor obonisa ukuthi hyperlink isusiwe.