Ngaba wazibuza ukuba ungongeza njani ii-hyperlinks, amabhukummark kunye / okanye i-mailto e-Excel? Iimpendulo zilapha apha.
Okokuqala, masikucacise oko sithethayo ngekota nganye.
I- hyperlink inokuqakraza ukuxhuma kwiphepha lokusebenzela kwiphepha lewebhu, kwaye lingasetyenziselwa kwi-Excel ukubonelela ngokukhawuleza nokulula kwezinye iincwadi zeencwadi ze-Excel.
Ibhukimakhi ingasetyenziselwa ukudala unxibelelwano kwindawo ethile kwiphepha lokusebenzela okanye kwiphepha lokusebenzela elingaphandle kwifayile efanayo ye-Excel usebenzisa iiferensi zeselfayile.
Ikhonkco yokuthumela i-imeyile ikhonkco kwidilesi ye-imeyile. Ukuchofoza kwi-imeyile ifowuni ivula iwindow entsha yomyalezo kwiprogram ye-imeyli engagqibekanga kwaye ifake idilesi ye-imeyile emva kwekhonkco ukuya kumgca womyalezo.
Kwi-Excel, zombini i-hyperlink kunye neebhukumaka zenzelwe ukwenza kube lula kubasebenzisi ukuba bahambe phakathi kweendawo ezinxulumene nedatha. Iifayile ze-mailto zenza kube lula ukuthumela umyalezo we-imeyili kumntu okanye kwintlangano. Kuzo zonke iimeko:
- Kungakhathaliseki ukuba luhlobo luni lwekhonkco lwenziwa - i-hyperlink, ibhukhimakhi okanye i-mailto link - ifakwe kwibhokisi yencoko yababini ye- Hyperlink .
- Njengoko kunxibelelwano kumaphepha ewebhu, iinqhagamshelo kwi-Excel zifakwe kwi-anchor text in a cell sheet sheet.
- Ukongeza lo mbhalo we-anchor ngaphambi kokuvula ibhokisi yencoko yebhokisi yencoko yenza lula umsebenzi wokudala ikhonkco, kodwa ingafakwa kwakhona emva kokuba ibhokisi yencoko yavuleka.
Vula ibhokisi yoxilongo ye-Hyperlink
Incoko ebalulekileyo yokuvula ibhokisi yencoko ye- Hyperlink ibhokisi yiCtrl + K kwi-PC okanye i- Command + K kwi-Mac.
- Kwiphepha lokusebenzela lase-Excel, nqakraza kwiseli ekufuneka iqulethe i-hyperlink ukwenza iseli esebenzayo.
- Thayipha igama ukuba usebenze njengombhalo we-anchor njenge "Spreadsheets" okanye "Juni_Sales.xlsx" kwaye ucinezela ukhiye wokungena kwikhibhodi.
- Cofa kwiseli kunye nombhalo we-anchor okwesihlandlo sesibini.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cinezela kwaye ukhulule itekisi K kwikhibhodi ukuvula ibhokisi yencoko ye- Hyperlink .
Indlela yokuvula iifayile ye-Hyperlink yebhokisi ye-Dialogl esebenzisa Imenyu yokufaka
- Kwiphepha lokusebenzela lase-Excel, nqakraza kwiseli ekufuneka iqulethe i-hyperlink ukwenza iseli esebenzayo.
- Faka umbhalo we-anchor kwiseli kwaye ucinezela ukhiye wokungena kwikhibhodi.
- Cofa kwiseli kunye nombhalo we-anchor okwesihlandlo sesibini.
- Cofa kwi-bar menu.
- Cofa kwi icon ye- Hyperlink ukuvula ibhokisi yencoko ye- Hyperlink ibhokisi.
Ukongeza ii-Hyperlink kwi-Excel
Ungasetha i hyperlink ukuza kwiphepha lewebhu okanye kwifayile ye-Excel. Nantsi indlela:
Ukongeza i-Hyperlink kwikhasi lewebhu
- Vula ibhokisi yencoko ye- Hyperlink ibhokisi usebenzisa enye yeendlela ezichazwe ngasentla.
- Cofa kwiWebhu Page okanye ifayile yefayile .
- Kwi- Address line, thayipha idilesi epheleleyo ye-URL.
- Cofa Kulungile ukuqedela i hyperlink uze uvale ibhokisi yencoko.
- Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe i hyperlink. Naliphi iqakraza, liya kuvula iwebhusayithi ekhethiweyo kwisiphequluli esingagqibekanga.
Ukongeza i-Hyperlink kwiFayile ye-Excel
- Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
- Cofa kwiFayile ekhoyo okanye iTebhu lekhasi leWebhu .
- Cofa kwi Khetha kwaye upheqa ukuze ufumane igama lefayile ye-Excel. Ukucofa kwigama lefayili longezela kwiNgcaciso yeDilesi kwibhokisi yencoko.
- Cofa Kulungile ukuqedela i hyperlink uze uvale ibhokisi yencoko.
- Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe i hyperlink. Naluphi na uqakraza, iya kuvula iincwadi ze-Excel ezikhethiweyo.
Ukudala amabhukumaka kwiSameyiet yeSameyile yeSameyile
Ibhukhimakhi kwi-Excel ifana ne hyperlink ngaphandle kokuba isetyenziselwa ukwenza ikhonkco kwindawo ethile kwiphepha lokusebenzela elikhoyo okanye kwiphepha lokusebenzela elihlukile kwifayile efanayo ye-Excel.
Ngelixa ii-hyperlink zisebenzisa amagama eefayile ukudala iikhonkco kwezinye iifayile ze-Excel, amabhukumaka asebenzisa iiselferensi zeeseli kunye namagama e-worksheet ekwenzeni izixhumanisi.
Indlela yokudala iMboniselo kwiFebhu elifanayo lokuSebenza
Umzekelo olandelayo udala ibhukumaka kwindawo ehlukileyo kwiphepha lokusebenzela elifanayo le-Excel.
- Thayipha igama kwiseli eliya kwenza njengombhalo we-anchor webhukumaka kwaye cinezela u- Enter .
- Cofa kwilo lisele ukwenza iseli esebenzayo.
- Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
- Cofa kwiTebhu leTebhu.
- Ngaphantsi kohlobo lweferensi yeselfayile , faka iselferensi yesalathisi kwindawo eyahlukileyo kwiphepha elifanayo lomsebenzi - njenge "Z100."
- Cofa u- OK ugcwalise ibhukmakhi uze uvale ibhokisi yencoko.
- Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe ibhukumaka.
- Cofa kwibhukumimethi kwaye isalathisi esesebenzayo ishukumisela kwisalathisi yesalathisi efakwe kwibhukumaka.
Ukudala amabhukumaka kwiifayile ezahlukeneyo zokusebenzela
Ukudala amabhukumaka kwiifayile ezisebenzayo ezahlukeneyo kwifayile efanayo ye-Excel okanye incwadi yesifundo inezinyathelo ezongezelelweyo zokuchonga iphepha lokusebenzela eliya kuyo. Ukuqamba kabusha ama-worksheets kunokukwenza kube lula ukwenza amabhukumaka kwiifayile kunye nenani elikhulu lamaphepha okusebenzela.
- Vula incwadi ye-Excel yamaphepha okanye udibanise amanye amaphepha kwifayile enye.
- Kwelinye lamakhishithi, thayipha igama kwiseli ukuze usebenze njengombhalo we-anchor webhukimakhi.
- Cofa kwilo lisele ukwenza iseli esebenzayo.
- Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
- Cofa kwiTebhu leTebhu.
- Faka iselferensi yeseli kwintsimi phantsi kohlobo Tshintsha kwifowuni .
- Kwimpawu ze- Or ukhethe indawo kule fom yecatshulwa, nqakraza kwigama legama elikuyo. Amakhishithi angabhalwa ngamagama ayaziwa njengeSheet1, iSheet2, iSheet3 njalonjalo.
- Cofa u- OK ugcwalise ibhukmakhi uze uvale ibhokisi yencoko.
- Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe ibhukumaka.
- Cofa kwibhukumimethi kunye nesalathisi esisebenzayo kufuneka ishukumele kwifowuni yesalathisi kwiphepha elifakwe kwibhukumaka.
Faka i-Mailto iqhagamshelo kwiFayile ye-Excel
Ukongeza ulwazi loqhagamshelwano kwiphepha lokusebenzela lase-Excel kwenza kube lula ukuthumela i-imeyili evela ngaphakathi kwidokhumenti.
- Thayipha igama kwiseli eya kwenza njengombhalo we-anchor kwikhonkco yeposi. Cinezela Faka .
- Cofa kwilo lisele ukwenza iseli esebenzayo .
- Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
- Cofa kwi- imeyile Idilesi yeeyile .
- Kwi- imeyile yedilesi yedilesi , faka idilesi ye-imeyili yommkeli wekhonkco. Le dilesi ingeniswe kumgca womyalezo omtsha we-imeyili xa ikhonkco iqhosha.
- Ngaphantsi komgca weSihloko , faka isihloko malunga ne-imeyile. Lo mbhalo ungeniswe kumgca wesifundo kumyalezo omtsha.
- Cofa u- OK ugcwalise ikhonkco yeposi kwaye uvale ibhokisi yencoko.
- Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe i hyperlink.
- Cofa kwikhonkco leposi, kunye nenkqubo ye-imeyli engagqibekanga kufuneka ivule umyalezo omtsha ngedilesi kunye nokufakwa kwesicatshulwa.
Ukususa i-Hyperlink ngaphandle kokususa i-Anchor Text
Xa ungasayidingi i-hyperlink, unokususa ulwazi lwekhonkco ngaphandle kokususa itekisi ekhonjiswe njenge-anchor.
- Beka i-pointer ye mouse kwi-hyperlink ukuba isuswe. Isalathisi selotshi kufuneka sitshintshe kwisimboli sandla.
- Ukuchofoza ngakwesokudla kwimbhalo yesikhombi sokuxhumela ukuvula imenyu yeDontext drop down.
- Cofa kwi Susa Imenyu ye-Hyperlink kwimenyu.
- Umbala obomvu kunye nesigxina kufuneka kususwe kumbhalo we-anchor obonisa ukuba i-hyperlink isusiwe.