Ukongeza ii-Excel Hyperlinks, Bookmarks, kunye ne-Mailto Links

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:

Vula ibhokisi yoxilongo ye-Hyperlink

Incoko ebalulekileyo yokuvula ibhokisi yencoko ye- Hyperlink ibhokisi yiCtrl + K kwi-PC okanye i- Command + K kwi-Mac.

  1. Kwiphepha lokusebenzela lase-Excel, nqakraza kwiseli ekufuneka iqulethe i-hyperlink ukwenza iseli esebenzayo.
  2. Thayipha igama ukuba usebenze njengombhalo we-anchor njenge "Spreadsheets" okanye "Juni_Sales.xlsx" kwaye ucinezela ukhiye wokungena kwikhibhodi.
  3. Cofa kwiseli kunye nombhalo we-anchor okwesihlandlo sesibini.
  4. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  5. Cinezela kwaye ukhulule itekisi K kwikhibhodi ukuvula ibhokisi yencoko ye- Hyperlink .

Indlela yokuvula iifayile ye-Hyperlink yebhokisi ye-Dialogl esebenzisa Imenyu yokufaka

  1. Kwiphepha lokusebenzela lase-Excel, nqakraza kwiseli ekufuneka iqulethe i-hyperlink ukwenza iseli esebenzayo.
  2. Faka umbhalo we-anchor kwiseli kwaye ucinezela ukhiye wokungena kwikhibhodi.
  3. Cofa kwiseli kunye nombhalo we-anchor okwesihlandlo sesibini.
  4. Cofa kwi-bar menu.
  5. 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

  1. Vula ibhokisi yencoko ye- Hyperlink ibhokisi usebenzisa enye yeendlela ezichazwe ngasentla.
  2. Cofa kwiWebhu Page okanye ifayile yefayile .
  3. Kwi- Address line, thayipha idilesi epheleleyo ye-URL.
  4. Cofa Kulungile ukuqedela i hyperlink uze uvale ibhokisi yencoko.
  5. 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

  1. Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
  2. Cofa kwiFayile ekhoyo okanye iTebhu lekhasi leWebhu .
  3. Cofa kwi Khetha kwaye upheqa ukuze ufumane igama lefayile ye-Excel. Ukucofa kwigama lefayili longezela kwiNgcaciso yeDilesi kwibhokisi yencoko.
  4. Cofa Kulungile ukuqedela i hyperlink uze uvale ibhokisi yencoko.
  5. 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.

  1. Thayipha igama kwiseli eliya kwenza njengombhalo we-anchor webhukumaka kwaye cinezela u- Enter .
  2. Cofa kwilo lisele ukwenza iseli esebenzayo.
  3. Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
  4. Cofa kwiTebhu leTebhu.
  5. Ngaphantsi kohlobo lweferensi yeselfayile , faka iselferensi yesalathisi kwindawo eyahlukileyo kwiphepha elifanayo lomsebenzi - njenge "Z100."
  6. Cofa u- OK ugcwalise ibhukmakhi uze uvale ibhokisi yencoko.
  7. Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe ibhukumaka.
  8. 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.

  1. Vula incwadi ye-Excel yamaphepha okanye udibanise amanye amaphepha kwifayile enye.
  2. Kwelinye lamakhishithi, thayipha igama kwiseli ukuze usebenze njengombhalo we-anchor webhukimakhi.
  3. Cofa kwilo lisele ukwenza iseli esebenzayo.
  4. Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
  5. Cofa kwiTebhu leTebhu.
  6. Faka iselferensi yeseli kwintsimi phantsi kohlobo Tshintsha kwifowuni .
  7. Kwimpawu ze- Or ukhethe indawo kule fom yecatshulwa, nqakraza kwigama legama elikuyo. Amakhishithi angabhalwa ngamagama ayaziwa njengeSheet1, iSheet2, iSheet3 njalonjalo.
  8. Cofa u- OK ugcwalise ibhukmakhi uze uvale ibhokisi yencoko.
  9. Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe ibhukumaka.
  10. 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.

  1. Thayipha igama kwiseli eya kwenza njengombhalo we-anchor kwikhonkco yeposi. Cinezela Faka .
  2. Cofa kwilo lisele ukwenza iseli esebenzayo .
  3. Vula ibhokisi yencoko ye- Hyperlink ibhokisi.
  4. Cofa kwi- imeyile Idilesi yeeyile .
  5. Kwi- imeyile yedilesi yedilesi , faka idilesi ye-imeyili yommkeli wekhonkco. Le dilesi ingeniswe kumgca womyalezo omtsha we-imeyili xa ikhonkco iqhosha.
  6. Ngaphantsi komgca weSihloko , faka isihloko malunga ne-imeyile. Lo mbhalo ungeniswe kumgca wesifundo kumyalezo omtsha.
  7. Cofa u- OK ugcwalise ikhonkco yeposi kwaye uvale ibhokisi yencoko.
  8. Umbhalo we-anchor kwiseli yomsebenzi kufuneka ube ngokuluhlaza okwesibhakabhaka kumbala kwaye ucaciswe ngokucacileyo ukuba uqulethe i hyperlink.
  9. 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.

  1. Beka i-pointer ye mouse kwi-hyperlink ukuba isuswe. Isalathisi selotshi kufuneka sitshintshe kwisimboli sandla.
  2. Ukuchofoza ngakwesokudla kwimbhalo yesikhombi sokuxhumela ukuvula imenyu yeDontext drop down.
  3. Cofa kwi Susa Imenyu ye-Hyperlink kwimenyu.
  4. Umbala obomvu kunye nesigxina kufuneka kususwe kumbhalo we-anchor obonisa ukuba i-hyperlink isusiwe.