Momwe mungapangire kapena kuchotsa hyperlinks mu Excel

Mothandizidwa ndi ma hyperlink pa bwino, mutha kutanthauza maselo, matele, mabuku apamwamba, mafayilo ena (zithunzi, zinthu zosiyanasiyana, zowonjezera, etc. Amatumikirapo kuti apite ku chinthu chomwe chimafotokozedwa mwachangu akamadina pa selo yomwe amayikidwira. Zachidziwikire, mu chikalata chopangidwa kovuta, kugwiritsa ntchito chida ichi kumandilandiridwa kokha. Chifukwa chake, wogwiritsa ntchito yemwe akufuna kuphunzira kugwira ntchito bwino kwambiri ndikofunikira kudziwa luso lopanga ndikuchotsa ma cyperlink.

Chosangalatsa: Kupanga Hyperlink mu Microsoft Mawu

Kuwonjezera hypersiril

Choyamba, lingalirani njira zomwe mungawonjezere hyperlink ku chikalatacho.

Njira 1: Kuyika Nify

Njira yosavuta yoikirani ulalo wopanda pake ku tsamba kapena imelo. Matenda osokoneza bongo - ulalo woterewu, adilesi yomwe imaperekedwa mwachindunji pa cell ndipo ikuwoneka papepala popanda zowonjezera. Gawo la pulogalamu ya Excel ndi kuti chilichonse chamthupi chophatikizidwa mu cell chimasandulika kukhala hyperlink.

Lowetsani ulalo kudera lililonse la pepalalo.

Tsopano, mukadina pafoni iyi, wosakatula adzayamba, womwe umakhazikitsidwa mwachisawawa, ndipo amapita ku adilesi yomwe yatchulidwa.

Momwemonso, mutha kuyika cholumikizira ku imelo adilesi, ndipo nthawi yomweyo imayamba kugwira ntchito.

Njira 2: Kuyankhulana ndi fayilo kapena tsamba la webusayiti kudzera pa menyu

Njira yotchuka kwambiri yowonjezera ulalo wolumikizana ndikugwiritsa ntchito menyu.

1. Tikutsindika mu khungu lomwe tiyika kulumikizana. Dinani kumanja pa icho. Mndandanda wa nkhaniyo umatseguka. Mmenemo, sankhani chinthucho "hyperlink ...".



2. Pambuyo pake itatu pazenera imatseguka. Kumanzere kwa zenera, mabatani amapezeka podina imodzi yomwe wogwiritsa ntchito ayenera kutchulapo kanthu kuti ndi mtundu wanji womwe mukufuna kuti muimbe:
   • ndi fayilo yakunja kapena tsamba lawebusayiti;
   • ndi malo mu chikalata;
   • ndi chikalata chatsopano;
   • ndi imelo.

   Popeza tikufuna kuwonetsa mwanjira iyi kuti iwonjezere hyperlink ndi ulalo ndi fayilo kapena tsamba lawebusayiti, timasankha chinthu choyamba. Kwenikweni, sikofunikira kuti musankhe, monga zikuwonekera mosasunthika.



3. Mu gawo lapakati pazenera pali gawo loyendetsa kuti musankhe fayilo. Mwachidule, wochititsayo ndi wotseguka mu Directory yomweyo pomwe buku la Explyl limapezeka. Ngati chinthu chomwe mukufuna chili mu chikwatu china, muyenera dinani batani la "File Sece", yomwe ili pamwamba pa malo a Ferris.



4. Pambuyo pake, zenera losankha fayilo litatsegulidwa. Pitani ku chikwatu chomwe mukufuna, timapeza fayilo yomwe tikufuna kulumikiza foni, mugawane ndikudina batani la "OK".

   

   Chidwi! Pofuna kugwirizanitsa khungu ndi fayilo iliyonse mu bokosi losakira, muyenera kukonzanso mtundu wa fayilo kusinthana ndi "mafayilo onse".

5. Pambuyo pake, magwiridwe ake a fayilo yomwe idafotokozedwayo imagwera mu "adilesi" ya kuyika kwa hyperlink. Ingoni batani la "OK".

Tsopano ma hyperlink awonjezeredwa ndipo mukadina pafoni yoyenera, fayilo yomwe yatchulidwa idzatsegulidwa mu pulogalamuyi yomwe idakhazikitsidwa kuti muwone.

Ngati mukufuna kuyika ulalo wa tsamba la tsamba, kenako mu adilesi yanu muyenera kulowa ulalo kapena kutupa. Kenako muyenera kudina batani la "OK".

Njira 3: Kuyankhulana ndi malo mu chikalatacho

Kuphatikiza apo, ndizotheka kugwirizanitsa khungu la hyperlink ndi malo aliwonse mu chikalata chapano.

1. Pambuyo pa khungu lomwe lingasankhidwe ndi lomwe limayambitsidwa ndi zomwe zili pazenera lazolowera pazenera la hyperlink, timasinthira batani kumanzere kwazenera "malo omwe ali ndi chikalatacho".



2. Gawolo "Lowani adilesi ya cell" muyenera kutchula mgwirizano wama cell kuti atchulidwe.

   

   M'malo mwake, pepala la chikalatachi likhozanso kusankhidwa m'munsi m'munsi momwe kusinthaku ndikudina pafoni. Pambuyo kusankha kupangidwa, muyenera dinani batani la "OK".

Tsopano khungu lidzalumikizidwa ndi malo enieni a buku lapano.

Njira 4: Hyperlink ku chikalata chatsopano

Njira ina ndi njira yothandizira kulembedwa.

1. Mu "Ikani ma hyperlinks" zenera, sankhani chinthucho "chimangani ndi chikalata chatsopano".



2. Mu gawo lalikulu la zenera mu "dzina la chikalata chatsopano" m'munda watsopano ", muyenera kutchula momwe bukuli lidzatchedwa.



3. Mwachisawawa, fayiloyi imayikidwa mu chikwatu chomwecho ngati buku lapano. Ngati mukufuna kusintha malo, muyenera dinani pa "Sinthani ..." batani.



4. Pambuyo pake, zenera lopanga chikalata chitseguka. Muyenera kusankha chikwatu cha malo ndi mawonekedwe ake. Pambuyo pake, dinani batani la "OK".



5. Mu malo okhazikika "mukalowa chikalata chatsopano", mutha kukhazikitsa imodzi mwa magawo awa: Pompano tsegulani chikalata chosintha, kapena choyamba kuti mulembetse chikalatacho. Pambuyo makonda onse amapangidwa, dinani batani la "OK".

Pambuyo pochita izi, khungu lomwe lili pa pepalali lidzalumikizidwa ndi hyperlink ndi fayilo yatsopano.

Njira 5: Kuyankhulana ndi Imelo

Selo pogwiritsa ntchito ulalo zimatha kuphatikizidwa ngakhale ndi imelo.

1. Mu "Ikani ma hyperlinks" zenera, dinani pa "chingwe ndi imelo".
2. Mu "Imelo Adilesi", lowetsani imelo yomwe tikufuna kuphatikiza foni. Mu "munda wa" Mutu wa "Mutha kulemba mutu wa makalata. Zikhazikiko zitatha, dinani batani la "OK".

Tsopano khungu lidzalumikizidwa ndi imelo adilesi. Mukadina pa iyo, kasitomala wa imelo amasungunuka. Windo lake lidzadzaza kale mu utoto wa imelo ndi mutu wa uthengawo.

Njira 6: Kuyika ma hyperlinks kudzera pa batani pa nthiti

The hyperlink imatha kuyikidwanso kudzera mu batani lapadera pa riboni.

1. Pitani ku "kuyika" tabu. Tidina batani la "Hyperlink", lomwe lili pa tepi mu "ulusi".



2. Pambuyo pake, "ikani ma hyperlinks" pawindo. Zochita zina zonse ndizofanana monga momwe zimakhalira ndi mndandanda wankhani. Zimadalira mtundu wanji womwe mukufuna kulembetsa.

Njira 7: Hyperlink ntchito

Kuphatikiza apo, ma hyperlink amatha kupangidwa pogwiritsa ntchito ntchito yapadera.

1. Tikutsindika maselo omwe ulalo udzayikidwa. Dinani pa batani la "phala ntchito".



2. Pazenera logwirira ntchito wa phompho limagwira ntchito, ndikuyang'ana dzina "Hyperlink". Pambuyo kujambulayo ikapezeka, tikuutsimikizira ndikudina batani la "Ok".



3. Kukangana kwa ntchito kumatseguka. The Hyperlink ili ndi mikangano iwiri: adilesi ndi dzina. Choyamba ndi chovomerezeka, komanso chachiwiri. Udindo wa "Adilesi" ukuwonetsa adilesi ya tsambalo, imelo kapena malo a fayilo pa hard disk yomwe mukufuna kuti mulumikizane ndi khungu. Mu "Dzinalo", ngati mukufuna, mutha kulemba liwu lirilonse lomwe lidzaonekere mu cell, potero kukhala nangula. Mukachoka m'munda uno mulibe kanthu, ndiye kuti ulalo udzawonetsedwa mu khungu. Zikhazikiko zitatha, dinani batani la "OK".

Pambuyo pa zochita izi, khungu lidzalumikizidwa ndi chinthu kapena tsambalo, lomwe lalembedwa mu ulalo.

Phunziro: Mzere wa Wizard mu Excel

Kuchotsedwa hypersiril

Palibenso funso lofunika kwambiri kuchotsa ma hyperlinks, chifukwa amatha kukwiya kapena pazifukwa zina zomwe mungafunike kusintha kapangidwe ka chikalatacho.

Chosangalatsa: Momwe mungachotsere ma hyperlinks mu Microsoft Mawu

Njira 1: Kuchotsa Zosankha

Njira yosavuta yochotsera ulalo ndikugwiritsa ntchito menyu. Kuti muchite izi, ingodinani pa selo, momwe ulalo umapezeka, wonani. Pa mndandanda wazosankha, sankhani "Chotsani Hyperlink". Pambuyo pake, idzachotsedwa.

Njira 2: Kuchotsa Ntchito ya Hyperlink

Ngati muli ndi ulalo mu cell pogwiritsa ntchito mawonekedwe apadera a hyperlink, ndiye kuti sizingatheke kuzichotsa pamwambapa. Kuti muchotse, muyenera kutsimikiza khungu ndikudina batani la Delete pa kiyibodi.

Pankhaniyi, sichokhachokha chogwirizanacho chidzachotsedwa, komanso lembalo, popeza ndizolumikizidwa kwathunthu pantchito imeneyi.

Njira 3: Kuchotsa kwa ma hyperlinks (Excel 2010 Version ndi pamwambapa)

Koma zoyenera kuchita ngati pali hyperlink yambiri mu chikalatacho, chifukwa kuchotsedwa pamanja kumatenga nthawi yayitali? Kupambana 2010 ndi pamwambapa, pali ntchito yapadera yomwe mungachotsere maulalo angapo nthawi imodzi m'maselo.

Sankhani maselo omwe mukufuna kufufuta maulalo. Dinani kumanja kapena kusankha "Chotsani ma hyperlinks".

Pambuyo pake, m'maselo osankhidwa a Hyperlinks adzachotsedwa, ndipo lembalo lidzakhalapobe.

Ngati mukufuna kufufuta mu chikalata chonse, mumayamba kuyimba foni ya ctrl + imodzi pa kiyibodi. Mwa izi, mumatsindika za pepala lonse. Kenako, dinani batani lamanja mbewa, itanani menyu. Mmenemo, sankhani "chotsani ma hyperlinks".

Chidwi! Njirayi sioyenera kuchotsa maulalo ngati mumamangirira maselo pogwiritsa ntchito mawu onyenga.

Njira 4: Kuchotsa kwa Matenda a Hyperlink (mtundu womwe udadziwika bwino 2010)

Kodi mungatani ngati muli ndi mtundu wakale wa 2010 pa kompyuta yanu? Kodi maulalo onse amayenera kuchotsedwa pamanja? Poterepa, palinso njira yothetsera, ngakhale ndi yovuta kwambiri kuposa njira yofotokozedwera. Mwa njira, njira yomweyo ingagwiritsidwe ntchito ngati mungafune pambuyo pake.

1. Tikuwonetsa khungu lililonse lopanda kanthu. Timayika digito mmenemo 1. Dinani pa batani la "Copy" mu "Home" tabu kapena kungophatikizira kilogalamu ya ctrl + c kiyibodi.



2. Sankhani maselo omwe ma hyperlink amapezeka. Ngati mukufuna kusankha gawo lonse, kenako dinani dzina lake pagawo lopingasa. Ngati mukufuna kuwonetsa pepala lonse, lembani ctrl + kiyibodi. Dinani pa chinthu chotsimikizika ndi batani la mbewa lamanja. Pankhani yankhani, dinani kawiri pa "yapadera ..." chinthu.



3. NJIRA yapadera itseguka. Mu "ntchito" zosintha, timasinthiratu kuti "kuchulukitsa". Dinani pa batani la "OK".

Pambuyo pake, ma hyperlink onse adzachotsedwa, ndipo ma cell osankhidwa amakonzedwanso.

Monga mukuwonera, ma hyperlinks amatha kukhala chida chosasinthika cholumikiza osati maselo osiyanasiyana a chikalata chimodzi, komanso kumalumikizana ndi zinthu zakunja. Kuchotsa maulalo ndikosavuta kugwira nawo ntchito zatsopano, komanso mu maskitala akale a pulogalamuyi, palinso mwayi wogwiritsa ntchito njira zoperekera maulalo ambiri.