Kuwonjezera Ma Excel Hyperlinks, Bookmarks, ndi Mailto Links

Kodi mumadabwa bwanji kuwonjezera ma hyperlinks, bookmarks ndi / kapena ma mailto ku Excel? Mayankho ali pomwe pano.

Choyamba, tiyeni tifotokoze zomwe timatanthauza pa nthawi iliyonse.

A hyperlink akhoza kudodometsedwa kuti adzalumphire kuchokera pa tsamba lofikira pa tsamba la webusaiti, ndipo angagwiritsidwe ntchito ku Excel kuti apereke mosavuta komanso mosavuta mabuku ena a Excel.

Bokosi lingagwiritsidwe ntchito popanga chiyanjano ku malo ena omwe ali pakali pano kapena pa tsamba lina lamasamba mkati mwa fayilo yomweyo ya Excel pogwiritsira ntchito ma selo.

Mzere wa makalata ndi chiyanjano cha imelo. Kusindikiza pa tsambato imelo imatsegula zenera zatsopano pa pulogalamu ya imelo yosasintha ndipo imayika imelo yadilesi pambuyo pa kulumikizana ndi Kulowera kwa uthenga.

Mu Excel, ma hyperlink ndi ma bookmarks akukonzedwa kuti zikhale zosavuta kuti ogwiritsa ntchito aziyenda pakati pa madera ofanana. Mauthenga a Mailto amakupangitsa kukhala kosavuta kutumiza uthenga wa imelo kwa munthu kapena bungwe. Nthawi zonse:

• Ziribe kanthu mtundu wa chiyanjano umene unalengedwa - hyperlink, bookmark, kapena linkto link - ilowetsedwa mu Insert Hyperlink dialog box.
• Monga momwe zilili pa ma tsamba a pa intaneti, maulaliki a Excel akuphatikizidwa ndi malemba oyimilira omwe ali mu selo lopangira.
• Kuwonjezera malemba a anchor musanatsegule bokosi la bokosi kumachepetsa ntchito yolenga chiyanjano, koma ikhozanso kutsekedwa mukatha kukambirana.

Tsegulani Bokosi la Zokambirana la Hyperlink

Mgwirizano wofunikira kuti mutsegule bokosi la Mauthenga a Hyperlink ndi Ctrl + K pa PC kapena Command + K pa Mac.

1. Mu tsamba la Excel, dinani selo limene liri ndi hyperlink kuti likhale selo yogwira ntchito.
2. Lembani mawu kuti agwiritse ntchito ngati malemba a anchor monga "Spreadsheets" kapena "June_Sales.xlsx" ndipo pindani mu Enter key pa makiyi.
3. Dinani mu selo ndi malemba a ancholo kachiwiri.
4. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
5. Dinani ndi kutulutsa katsulo K kowunikira kuti mutsegule bokosi la dialog Insert .

Mmene Mungatsegule Bokosi Lokambirana la Hyperlink Pogwiritsa Ntchito Insert Menu

1. Mu tsamba la Excel, dinani selo limene liri ndi hyperlink kuti likhale selo yogwira ntchito.
2. Lowetsani malemba a ancholo mu selo ndikusindikizira fungulo lolowamo ku Enter .
3. Dinani mu selo ndi malemba a ancholo kachiwiri.
4. Dinani ku Insert pa bar menyu.
5. Dinani pa chithunzi cha Hyperlink kuti mutsegule tsamba la Insert Hyperlink .

Kuwonjezera ma Hyperlink mu Excel

Mukhoza kukhazikitsa hyperlink kudumpha pa tsamba lamasamba kapena ku fayilo ya Excel. Nazi momwemo:

Kuwonjezera Hyperlink ku Webusaiti

1. Tsegulani bokosi la bokosi la Insert Insert pogwiritsa ntchito njira zomwe tatchula pamwambapa.
2. Dinani pa Tsambali Tsamba kapena Fayilo phukusi.
3. Mu adiresi yachinsinsi , lembani ma Adiresi athunthu.
4. Dinani OK kuti mutsirize hyperlink ndi kutseka bokosi la dialog.
5. Malemba a ancholo m'seri ya worksheet ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi hyperlink. Nthawi iliyonse ikasindikizidwa, idzatsegula webusaitiyi yovomerezeka mu msakatuli wosasinthika.

Kuwonjezera Hyperlink ku Excel File

1. Tsegulani bokosi la dialog la Insert .
2. Dinani pa Fayilo Loyamba kapena Tsambali Tsambali.
3. Dinani pa Sankhani ndi kutsegula kuti mupeze dzina la Excel file. Kusindikiza pa dzina la fayilo kumawonjezera ilo ku Address line mu dialog box.
4. Dinani OK kuti mutsirize hyperlink ndi kutseka bokosi la dialog.
5. Malemba a ancholo m'seri ya worksheet ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi hyperlink. Nthawi iliyonse ikasindikizidwa, idzatsegula buku lotchedwa Excel ntchito.

Kupanga Zowonjezera ku Tsamba Loyenera la Zolemba

Bukhu la Excel liri lofanana ndi liwu lokha kupatula kuti limagwiritsidwa ntchito popanga chiyanjano kumalo ena pa tsamba lapailesi kapena pa tsamba lina lolembedwa mu fayilo yomweyo ya Excel.

Ngakhale ma hyperlink amagwiritsa ntchito maina a fayilo kuti alumikize maofesi ena a Excel, zizindikiro zimagwiritsira ntchito maofesi a ma selo ndi ma tsamba a ntchito kuti alumikize.

Mmene Mungapangire Chizindikiro ku Tsamba Loyenera la Ntchito

Chitsanzo chotsatira chimapanga chizindikiro ku malo osiyana pa tsamba limodzi la Excel.

1. Lembani dzina mu selo limene lingakhale ngati lemba lachikale la bookmark ndikusindikiza ku Enter .
2. Dinani pa selo kuti mupange selo yogwira ntchito.
3. Tsegulani bokosi la dialog la Insert .
4. Dinani pa Tsambali lambendera.
5. Pogwiritsa ntchito selo yeniyeni , lowetsani selo loyang'ana malo osiyana pa tsamba limodzi - monga "Z100."
6. Dinani OK kuti mukwaniritse chizindikiro ndi kutseka bokosi la bokosi.
7. Malemba a ancholo m'seri ya worksheet ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi chizindikiro.
8. Dinani pa bokosiki ndi yogwiritsira ntchito selo lolozera likulowetsa ku zolembedwera zam'kati za bokosi.

Kupanga Ma Bookmarks ku Zolemba Zosiyanasiyana

Kupanga zikwangwani ku maofesi osiyanasiyana mkati mwa fayilo yomweyo ya Excel kapena buku lothandizira liri ndi sitepe yowonjezera yowunikira tsamba lopita kopita kwa bokosilo. Kukonzanso mapepala angapangitse kukhala kosavuta kupanga zolemba zizindikiro m'mafayi omwe ali ndi masamba ambiri.

1. Tsegulani buku la Excel pamapepala ambiri kapena onetsani mapepala owonjezera pa fayilo limodzi.
2. Pa tsamba limodzi, lembani dzina mu selo kuti mukhale ngati malemba a anchor a chizindikiro.
3. Dinani pa selo kuti mupange selo yogwira ntchito.
4. Tsegulani bokosi la dialog la Insert .
5. Dinani pa Tsambali lambendera.
6. Lowetsani selolo mumtunda pansi pa Mtundu wagawuni .
7. Mu Or chotsani malo mu tsamba ili , dinani pa tsamba lopitako. Mapepala osayina dzina amadziwika monga Sheet1, Sheet2, Sheet3 ndi zina zotero.
8. Dinani OK kuti mukwaniritse chizindikiro ndi kutseka bokosi la bokosi.
9. Malemba a ancholo m'seri ya worksheet ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi chizindikiro.
10. Dinani pa bokosilo ndi selo yogwiritsira ntchito seloyo ayenera kusunthira ku selo loyang'ana pa pepala loperekedwa kwa bokosi.

Lembani Mailto kuzilumikiza mu fayilo ya Excel

Kuwonjezera mauthenga okhudzana nawo ku Excel sheet sheet kumakhala kosavuta kutumiza imelo kuchokera mkati mwa chikalata.

1. Lembani dzina mu selo lomwe lingakhale ngati lemba lachikale lachinsinsi cha mailto. Dinani ku Enter .
2. Dinani pa selo kuti mupange selo yogwira ntchito .
3. Tsegulani bokosi la dialog la Insert .
4. Dinani pa tsamba la Email Address .
5. Mu email address field, lowetsani imelo ya wothandizira. Adilesi iyi imalowa mu Kulembera kwa uthenga watsopano wa imelo pamene mgwirizano ukutsekedwa.
6. Pansi pa Nkhaniyi , lowetsani phunziro la imelo. Lembali likulowetsedwa mu phunziro la uthenga watsopano.
7. Dinani OK kuti mutsirizitse chiyanjano cha mailto ndi kutseka bokosi la bokosi.
8. Malemba a ancholo m'seri ya worksheet ayenera tsopano kukhala a buluu mu mtundu ndi ndondomeko yosonyeza kuti ili ndi hyperlink.
9. Dinani pa mndandanda wamakalata, ndipo pulogalamu ya imelo yosasintha iyenera kutsegula uthenga watsopano ndi adiresi ndi malemba omwe alowe.

Kuchotsa Hyperlink Popanda Kuchotsa Text Anchor

Pamene simukusowa chithunzithunzi, mukhoza kuchotsa chiyanjanochi popanda kuchotsa mawu omwe anakhazikitsa ngati nangula.

1. Ikani pointer la mouse pa hyperlink kuti ichotsedwe. Mtsuko wamatsuko umasintha ku chizindikiro cha dzanja.
2. Dinani pakanema pamakalata ovomerezeka a hyperlink kuti mutsegule Menyu yotsitsa pansi.
3. Dinani pa Chotsani Hyperlink kusankha mndandanda.
4. Mtundu wabuluu ndi mzere wozunzikirapo ayenera kuchotsedwa palemba lachikale chomwe chikusonyeza kuti hyperlink yachotsedwa.