Ndi chithandizo cha ma hyperlink ku Excel, mukhoza kugwirizanitsa ndi maselo ena, matebulo, mapepala, mabuku a ntchito ya Excel, mafayilo a ntchito zina (mafano, zina zotero), zinthu zosiyanasiyana, zinthu zamtaneti, ndi zina zotero. Amathamanga mofulumira ku chinthu chododometsedwa podindira pa selo limene amalowetsamo. Inde, mu zolembedwa zovuta, kugwiritsa ntchito chida ichi ndikulandiridwa. Choncho, wogwiritsa ntchito yemwe akufuna kuphunzira bwino momwe angagwiritsire ntchito Excel amangofunikira kudziwa luso lokhazikitsa ndi kuchotsa mafayilo a hyperlink.
Zosangalatsa: Kupanga ma hyperlink mu Microsoft Word
Kuwonjezera ma hyperlink
Choyamba, ganizirani momwe mungaperekere ma hyperlink ku chilembacho.
Njira 1: Yesani Ma Hyperlink Anchorless
Njira yosavuta yoika chiyanjano chosagwirizana ndi tsamba la webusaiti kapena imelo. Bezankornaya hyperlink - ichi ndi chiyanjano, adiresi yomwe imalembedwa mwachindunji mu selo ndipo ikuwoneka pa pepala popanda zina zowonjezera. Chinthu chodziwika bwino cha Excel ndi chakuti chilankhulo chilichonse cha bezankorny chophatikizidwa mu selo, chimasandulika kukhala hyperlink.
Lowani chiyanjano kumalo alionse a pepala.
Tsopano mukamalemba pa selo iyi, osatsegula omwe waikidwa mwachindunji akuyamba ndikupita ku adiresi yomwe yapatsidwa.
Mofananamo, mungathe kuyika mauthenga a imelo, ndipo idzayamba kugwira ntchito.
Njira 2: kulumikizana ndi fayilo kapena tsamba la intaneti kudzera mndandanda wamakono
Njira yodziwika kwambiri yowonjezera mauthenga ku mndandanda ndiyo kugwiritsa ntchito mndandanda wa mauthenga.
- Sankhani selo kuti tiike chiyanjanocho. Dinani botani lamanja la mouse pa ilo. Mndandanda wamakono umatsegulidwa. M'menemo, sankhani chinthucho "Hyperlink ...".
- Mwamsanga pambuyo pa izi, mawonekedwe obisala amawonekera. Pali mabatani kumbali ya kumanzere kwawindo, ndikudalira pa imodzi yomwe wogwiritsa ntchitoyo ayenera kufotokoza mtundu wa chinthu chomwe akufuna kuti agwirizane ndi selo ndi:
- ndi fayilo yakunja kapena tsamba la intaneti;
- ali ndi malo mu chilembacho;
- ndi chikalata chatsopano;
- ndi imelo.
Popeza tikufuna kusonyeza kulumikiza kwa fayilo kapena tsamba la intaneti mwa njira yowonjezera hyperlink, timasankha chinthu choyamba. Kwenikweni, sikofunika kuti muzisankhe, chifukwa zikuwonetsedwa mwachinsinsi.
- Pakatikati pazenera ndi malo Woyendetsa kusankha fayilo. Mwachinsinsi Explorer kutseguka mu bukhu lomwelo monga buku la Excel lomwe liripo. Ngati chinthu chofunidwa chiri mu foda ina, ndiye dinani batani "Fufuzani Fufuzani"ili pamwamba pa malo oyang'ana.
- Pambuyo pake, mawindo omwe amasankha mafayilo amatsegula. Pitani ku zolemba zomwe tikufunikira, fufuzani fayilo yomwe tikufuna kugwirizanitsa selo, iiseni ndi dinani pa batani "Chabwino".
Chenjerani! Kuti mukhoze kusonkhanitsa selo ndi fayilo ndizowonjezerapo muzenera lofufuzira, muyenera kuyambiranso kusinthitsa mtundu wa fayilo kuti "Mafayi Onse".
- Pambuyo pake, makonzedwe a fayilo yapadulidwa akulowa mu "Maadiresi" gawo la mawindo olowera. Ingolani pa batani "Chabwino".
Tsopano hyperlink yawonjezeredwa, ndipo pamene inu mutsegula pa selo lolingana, fayilo yomwe yatsimikizika idzatsegulidwa mu pulogalamuyi yoikidwa kuti iwonere izo mwachisawawa.
Ngati mukufuna kukhazikitsa chiyanjano ku intaneti, ndiye kumunda "Adilesi" mukuyenera kuti mulowetse url kapena kukopera izo pamenepo. Kenaka dinani pa batani. "Chabwino".
Njira 3: Yesani ku malo omwe alipo
Kuwonjezera apo, n'zotheka kuimitsa selo kumalo aliwonse pakalata.
- Selo yoyenera ikasankhidwa ndipo hyperlink yolowera mawindo imatchulidwa kudzera mndandanda wa masewera, sintha batani kumbali ya kumanzere kwawindo pa malo "Gwirizanitsani malo kumalo".
- Kumunda "Lowani adilesi ya selo" muyenera kufotokoza makonzedwe a selo kuti afotokozedwe.
M'malo mwake, m'munsimu, mungasankhe pepala lazomwe mukulemba, pamene kusinthako kudzachitika pamene mutsegula pa selo. Pambuyo pasankhidwa, muyenera kudinkhani pa batani. "Chabwino".
Tsopano selo lidzaphatikizidwa ndi malo enieni a bukhuli.
Njira 4: hyperlink ku chikalata chatsopano
Njira ina ndiyolankhulirana ndi chikalata chatsopano.
- Muzenera "Yesani Hyperlink" sankhani chinthu "Gwirizanitsani ndi chikalata chatsopano".
- Pakatikati pawindo pazomwemo "Dzina la chikalata chatsopano" ayenera kufotokoza zomwe bukhulo lidzatchedwa.
- Mwachindunji, fayiloyi idzakhala ili muzomwezo monga buku lomwe liripo. Ngati mukufuna kusintha malo, muyenera kutsegula pa batani "Sintha ...".
- Pambuyo pake, mawindo otsegulira chiwonetsero cha chilemba amatsegulidwa. Mudzafunika kusankha foda yake ndi fomu. Pambuyo pake dinani pa batani "Chabwino".
- Mu bokosi lokhalamo "Nthawi yolemba chikalata chatsopano" Mukhoza kusankha chimodzi mwazinthu zotsatirazi: kutsegula chikalata chokonzekera pakalipano, kapena pangani chikalata ndikugwirizanitsa choyamba, ndiyeno, mutatha kutseka fayilo yamakono, yesani. Pambuyo pokonza zonsezi, dinani batani. "Chabwino".
Pambuyo pochita izi, selo pa pepala laposachedwapa lidzakanizidwa ku fayilo yatsopano.
Njira 5: Mauthenga a Imeli
Selo ikhoza kugwirizanitsidwa ndi chiyanjano ngakhale ndi imelo.
- Muzenera "Yesani Hyperlink" dinani pa batani "Link kwa Email".
- Kumunda "Imelo Imelo" lowetsani makalata omwe tikufuna kulumikiza selo. Kumunda "Mutu" Mukhoza kulemba kalata. Pambuyo mapangidwe apangidwa, dinani pa batani. "Chabwino".
Tsopano selo lidzagwirizana ndi imelo adilesi. Mukamatula payekha, kasitomala wosasintha amayamba. Mauthenga oyamba omwe adatchulidwa ndi mauthenga a uthengawo adzadzazidwa kale pazenera.
Njira 6: Yesetsani kukhudzana pogwiritsa ntchito batani pa riboni
Hyperlink ingathenso kuikidwa kudzera mu batani lapadera pa tepi.
- Pitani ku tabu "Ikani". Timakanikiza batani "Hyperlink"yomwe ili pa tepi muzitali za zida "Zolumikizana".
- Pambuyo pake, zenera likuyamba. "Yesani Hyperlink". Zochita zonse zofanana ndizofanana ndi pamene mukudutsa mndandanda wamakono. Zimadalira pa mtundu wotani umene mukufuna kugwiritsa ntchito.
Njira 7: Ntchito ya HYPERLINK
Kuphatikizanso, chithunzithunzi chingathe kulengedwa pogwiritsa ntchito ntchito yapadera.
- Sankhani selo limene likulumikizidwa. Dinani pa batani "Ikani ntchito".
- Muzenera lotsegula mawindo Masters ife tikuyang'ana dzina. "HYPERLINK". Pambuyo pa mbiriyi, yikani ndipo dinani pa batani "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. HYPERLINK Lili ndi zifukwa ziwiri: adiresi ndi dzina. Yoyamba ndi yokha, ndipo yachiwiri ndi yokha. Kumunda "Adilesi" Tchulani adiresi yathu ya intaneti, adiresi ya e-mail kapena malo a fayilo pa diski yovuta imene mukufuna kusonkhanitsira selo. Kumunda "Dzina"ngati mukukhumba, mukhoza kulemba mawu aliwonse omwe angawoneke mu selo, motero akhale nangula. Ngati mutasiya mundawu musabisale, ndiye kulumikizana kudzawonetsedwa mu selo. Pambuyo mapangidwe apangidwa, dinani pa batani. "Chabwino".
Pambuyo pazimenezi, selo lidzagwirizanitsidwa ndi chinthu kapena malo omwe atchulidwa mu chiyanjano.
Phunziro: Wowonjezera Wogwira Ntchito
Chotsani hyperlinks
Funso la momwe mungachotsere ma hyperlink, chifukwa amatha kutuluka nthawi kapena zifukwa zina ayenera kusintha kapangidwe kake.
Zosangalatsa: Momwe mungachotsere ma hyperlink mu Microsoft Word
Njira 1: Chotsani kugwiritsa ntchito menyu yoyenera
Njira yosavuta yochotsera chiyanjano ndiyo kugwiritsa ntchito mndandanda wamakono. Kuti muchite izi, dinani kokha pa selo limene chilankhulocho chili, dinani pomwepo. Mu menyu yachidule, sankhani chinthucho "Chotsani hyperlink". Pambuyo pake idzachotsedwa.
Njira 2: chotsani ntchito ya HYPERLINK
Ngati muli ndi mgwirizano mu selo pogwiritsa ntchito ntchito yapadera HYPERLINKndiye kuchotsa izo muzomwezi sizingagwire ntchito. Chotsani, sankhani selo ndikusindikiza batani. Chotsani pabokosi.
Izi zidzachotsa osati chiyanjano chokha, komanso malemba, popeza ntchitoyi ndi yogwirizana.
Njira 3: Bulk yeretsani ma hyperlink (Excel version 2010 ndi pamwamba)
Koma choyenera kuchita ngati pali zowonjezereka zamakalata, chifukwa kuchotsa bukulo kumatenga nthawi yochuluka? M'masinthidwe a Excel 2010 ndi pamwambapo pali ntchito yapadera yomwe mungathe kuchotsa maulendo angapo m'maselo nthawi yomweyo.
Sankhani maselo amene mukufuna kuchotsa maulumikizi. Dinani pang'onopang'ono kuti mubweretse mndandanda wa masewerawo ndikusankha "Chotsani ma Hyperlink".
Pambuyo pake, mu maselo osankhidwa, ma hyperlink adzathetsedwa, ndipo mawu omwewo adzatsala.
Ngati mukufuna kuchotsa muzitsamba zonse, choyamba fanizani mgwirizano wa makiyi pa makiyi Ctrl + A. Izi zidzakweza pepala lonse. Kenaka, powanikiza botani lamanja la mbewa, dinani mndandanda wa mauthenga. M'menemo, sankhani chinthucho "Chotsani ma Hyperlink".
Chenjerani! Njira iyi si yoyenera kuchotsa maulumikizi ngati mutagwirizanitsa maselo ogwiritsira ntchito HYPERLINK.
Mchitidwe 4: Bulk chotsani ma hyperlink (malemba oyambirira kuposa Excel 2010)
Kodi mungatani ngati muli ndi ndondomeko yoyamba kuposa Excel 2010 yoikidwa pa kompyuta yanu? Kodi maulumikilo onse ayenera kuchotsedwa mwadala? Pankhaniyi, palinso njira yotulukira, ngakhale kuti ndi yovuta kwambiri kuposa momwe tafotokozera mu njira yapitayi. Mwa njira, njira yomweyo ingagwiritsidwe ntchito ngati ikukhutira, ndi kumasulira kwotsatira.
- Sankhani selo iliyonse yopanda kanthu pa pepala. Ikani chiwerengero chake 1. Dinani pa batani "Kopani" mu tab "Kunyumba" kapena kungoyimitsa njira yachinsinsi Ctrl + C.
- Sankhani maselo omwe ma hyperlink ali. Ngati mukufuna kusankha gawo lonse, ndiye dinani pa dzina lake mu bar. Ngati mukufuna kusankha pepala lonse, lembani mgwirizano Ctrl + A. Dinani pa chinthu chosankhidwa ndi batani labwino la mouse. Mu menyu yachidule, dinani kawiri pa chinthucho. "Kuika Mwapadera ...".
- Zowonjezera zowonjezera zenera zikutsegula. Mu bokosi lokhalamo "Ntchito" ikani kusinthana pa malo "Pitirizani". Timakanikiza batani "Chabwino".
Pambuyo pake, ma hyperlink onse adzachotsedwa, ndipo mapangidwe a maselo osankhidwa adzabwezeretsedwa.
Monga mukuonera, ma hyperlink akhoza kukhala chida chosavuta chogwiritsira ntchito, kugwirizanitsa osati maselo osiyana a zolembedwazo, komanso kugwirizanitsa ndi zinthu zakunja. Kuchotsa maulendo kumakhala kosavuta kuchita m'zinenero zatsopano za Excel, koma pazochitika zakale za pulogalamuyi, n'zotheka kuthetsa kuchotsa macheza pogwiritsa ntchito njira zosiyana.