Pangani ndi kufufuta ma hyperlink mu Microsoft Office Excel

Pogwiritsa ntchito ma hyperlinks ku Excel, mutha kulumikizana ndi ma cell ena, matebulo, ma sheet, mabuku a Excel, mafayilo a mapulogalamu ena (zithunzi, ndi zina), zinthu zosiyanasiyana, zothandizira pa intaneti, ndi zina zambiri. Amathandizira kudumpha mwachangu pa chinthu chomwe mwayika mukadula foni yomwe aikemo. Zachidziwikire, muzolemba zopangidwa zovuta, kugwiritsa ntchito chida ichi kumalimbikitsidwa. Chifukwa chake, wogwiritsa ntchito amene akufuna kuphunzira momwe angagwirire bwino ntchito ku Excel, amangofunikira luso la kulenga ndi kuchotsa ma hyperlink.

Chosangalatsa: Kupanga ma Hyperlink mu Microsoft Mawu

Powonjezera ma Hyperlink

Choyamba, tayang'ana njira zowonjezera zolembalemba zikuluzikulu.

Njira 1: Ikani Ma Hyperlink a Unchannel

Njira yosavuta ndiyo kukhazikitsa ulalo wosagwirizana patsamba la tsamba kapena imelo. Hyperlink ya anchorless - uku ndi kulumikizana kotero, adilesi yomwe amalembetsa mwachindunji mu cell ndipo amawonekera papepala popanda zowonjezera. Chowonera papulogalamu ya Excel ndikuti ulalo uliwonse wosakhala nangula womwe walowetsedwa mu khungu umasinthidwa kukhala chosakanizira.

Lowetsani ulalo m'mbali iliyonse ya pepalalo.

Tsopano, mukadina foni iyi, asakatuli omwe adaikiratu amayamba ndi kupita ku adilesi yomwe mwatsimikiza.

Momwemonso, mutha kuyika ulalo ku imelo, ndipo imayamba kukhala yogwira ntchito.

Njira 2: kulumikizana ndi fayilo kapena tsamba lawebusayiti kudzera pa menyu

Njira yodziwika kwambiri yowonjezerera maulalo ndi pepala ndikugwiritsa ntchito menyu.

1. Sankhani khungu lomwe tikuyika ulalo. Dinani kumanja pa icho. Zosankha zam'mawu zimatsegulidwa. Mmenemo, sankhani chinthucho "Hyperlink ...".



2. Zitangochitika izi, zenera loyika limatseguka. Mabataniwo ali kudzanja lamanzere la zenera, ndikudina pomwe wina azigwiritsa ntchito chinthu chomwe akufuna kuphatikiza khungu:
   • ndi fayilo yakunja kapena tsamba la webusayiti;
   • ndi malo mu chikalata;
   • ndi chikalata chatsopano;
   • ndi imelo.

   Popeza tikufuna kuwonetsa mwanjira iyi yowonjezera ulalo wolumikizana ndi fayilo kapena tsamba lawebusayiti, timasankha chinthu choyamba. Kwenikweni, simuyenera kuyisankha, chifukwa imawonetsedwa.



3. Chapakati pazenera ndi malo Kondakitala kusankha fayilo. Mwa kusakhulupirika Wofufuza Itsegulidwa mchidule chofananira ndi buku lakale la Excel. Ngati chinthu chomwe mukufuna chili mufoda ina, ndiye dinani batani Fufuzani Fayiloili pamwamba pomwe pamawonekedwe.



4. Pambuyo pake, zenera losankha fayilo limayamba. Timapita ku fayilo yomwe tikufuna, tipeze fayilo yomwe tikufuna kuyanjanitsa khungu, kusankha ndikudina batani "Zabwino".

   

   Yang'anani! Kuti mutha kugwirizanitsa khungu ndi fayilo ndi chowonjezera chilichonse pawindo losakira, muyenera kusuntha mtundu wamtundu wa fayilo kupita "Mafayilo onse".

5. Pambuyo pake, zogwirizanitsa ndi fayilo yomwe idafotokozedwayo imagwera gawo la "Adilesi" la zenera la hyperlink. Ingodinani batani "Zabwino".

Tsopano Hyperlink imawonjezeredwa ndipo mukadina foni yofananira, fayilo yomwe itchulidwa idzatsegulidwa mu pulogalamu yomwe idayikidwa kuti iwone mwangozi.

Ngati mukufuna kuyika ulalo wa webusayiti, ndiye kumunda "Adilesi" muyenera kuyika pamanja url kapena kukopera pamenepo. Kenako dinani batani "Zabwino".

Njira 3: kulumikizana ndi malo chikalata

Kuphatikiza apo, ndizotheka kulumikiza khungu ndi malo aliwonse cholembedwa pano.

1. Maselo ofunikira atasankhidwa ndipo zenera lofanizira limayitanitsidwa kudzera pazakudya, sinthani batani kumanzere kwa zenera kupita pamalo "Lumikizanani ndi kuyika chikalata".



2. M'munda Lowetsani adilesi yafoni " Muyenera kutchulanso zoyanjanira za selo zomwe mukufuna kuzitengera.

   

   M'malo mwake, m'munsi, mutha kusankhanso pepala ili, pomwe angasinthe mukangodina foni. Chisankho chikapangidwa, dinani batani "Zabwino".

Tsopano khungu lidzalumikizidwa ndi malo ena ake m'buku lapano.

Njira 4: kulumikizana ku zolemba zatsopano

Njira ina ndi kuphatikiza pa chikalata chatsopano.

1. Pazenera Hyperlink Ikani sankhani Lumikizani ku chikalata chatsopano.



2. Pakati pazenera m'munda "Mbiri yatsopano chikalata" muyenera kuwonetsa zomwe bukulo lidzatchedwa.



3. Mwa kusakhazikika, fayiloyi idzayikidwa mu mndandanda wofanana ndi bukhu lapano. Ngati mukufuna kusintha malowa, muyenera dinani batani "Sinthani ...".



4. Pambuyo pake, zenera labwino pakupanga chikalata limatsegulidwa. Muyenera kusankha chikwatu cha mtundu wake ndi mtundu. Pambuyo pake, dinani batani "Zabwino".



5. Mu makatani "Mukasintha nthawi yanji chikalata chatsopano" Mutha kukhazikitsa umodzi mwa magawo otsatirawa: pomwepo tsegulani chikalatacho kuti musinthe, kapena pangani kaye cholembedwacho ndi ulalo, ndipo pokhapokha, mutatseka fayilo yaposachedwa, sinthani. Pambuyo mawonekedwe onse atapangidwa, dinani batani "Zabwino".

Pambuyo pochita izi, khungu pa pepala lomwe lilipo lidzalumikizidwa ndi choyerekeza ndi fayilo yatsopano.

Njira 5: Kuyankhulana kwa Imelo

Selo logwiritsa ntchito ulalo limatha kuphatikizidwa ndi imelo.

1. Pazenera Hyperlink Ikani dinani batani Lumikizani Imelo.
2. M'munda Imelo Adilesi lowetsani imelo yomwe tikufuna kuyanjanitsa foni. M'munda Mutu Mutha kulemba mzere wamutu. Zosintha zikamalizidwa, dinani batani "Zabwino".

Selo iphatikizidwa ndi adilesi ya imelo. Mukamayang'ana, makasitomala osakhulupirika amayambitsidwa. Pazenera lake, maimelo omwe adafotokozedweratu ndi mesejiyo adzadzaza mu ulalo.

Njira 6: ikani chithokomiro kudzera pa batani pa riboni

Mutha kuyikanso chophatikizira pogwiritsa ntchito batani lapadera pa riboni.

1. Pitani ku tabu Ikani. Dinani batani "Pikokoyamaula"ili pa tepi pachiboliboli chida "Maulalo".



2. Pambuyo pake, zenera limayamba Hyperlink Ikani. Zochita zina zonse ndizofanana ndendende ndikadyetsa menyu. Zimatengera mtundu wa ulalo womwe mukufuna kutsatira.

Njira 7: Ntchito ya Hyperlink

Kuphatikiza apo, Hyperlink imatha kupangidwa pogwiritsa ntchito ntchito yapadera.

1. Sankhani khungu lomwe cholumikizacho chidzaikiramo. Dinani batani "Ikani ntchito".



2. Pazenera lomwe limatsegulira, Wizard Yogwira Ntchito amayang'ana dzinalo "HYPERLINK". Nyimbozo zikapezeka, sankhani ndikudina batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imatsegulidwa. HYPERLINK ili ndi mfundo ziwiri: adilesi ndi dzina. Yoyamba ya izi ndi yokakamiza, ndipo yachiwiri ndiyochita kusankha. M'munda "Adilesi" imawonetsa adilesi ya tsamba, imelo kapena malo omwe fayiloyo ili pa hard drive yomwe mukufuna kuyanjanitsa nayo foni. M'munda "Dzinalo", ngati mungafune, mutha kulemba mawu aliwonse omwe adzawonekere m'chipindacho, potenga nangula. Ngati mungasiye mundawo mulibe kanthu, ndiye kuti ulalo ungowonetsedwa mu foni. Masanjidwewo atapangidwa, dinani batani "Zabwino".

Zitachitika izi, khungu lidzalumikizidwa ndi chinthu kapena tsamba lomwe laikidwa pa ulalo.

Phunziro: Ntchito Wizard ku Excel

Kuchotsa Zophatikiza

Chosafunanso kwenikweni ndi funso loti mungachotse bwanji ma hyperlink, chifukwa atha kukhala achikale kapena pazifukwa zina ndikofunikira kusintha mawonekedwe a chikalatacho.

Chosangalatsa: Momwe mungachotsere zopanira mu Microsoft Mawu

Njira 1: chotsani kugwiritsa ntchito menyu

Njira yosavuta yochotsera ulalo ndikugwiritsa ntchito menyu. Kuti muchite izi, ingodinani foni komwe kulumikizanako, dinani kumanja. Pazosankha zofanizira, sankhani Chotsani Hyperlink. Pambuyo pake, idzachotsedwa.

Njira 2: santhani ntchito ya Hyperlink

Ngati muli ndi cholumikizira mu khungu pogwiritsa ntchito ntchito yapadera HYPERLINK, ndiye kuti ichotse mwanjira yomwe ili pamwambapa sikugwira ntchito. Kuti muchotse, sankhani khungu ndikudina batani Chotsani pa kiyibodi.

Izi sizichotsanso ulalo wokha, komanso lembalo, popeza muntchitoyi amalumikizidwa kwathunthu.

Njira 3: kufufuta zochulukirapo (Excel 2010 ndi mtsogolo)

Koma bwanji ngati pali zolemba zambiri m'lemba, chifukwa kuchotsedwa pamanja kumatenga nthawi yambiri? Mu mtundu Excel 2010 ndi pamwambapa, pali ntchito yapadera yomwe mungachotse maubwenzi angapo m'melo kamodzi.

Sankhani ma cell omwe mukufuna kuchotsa maulalo. Dinani kumanja kuti mubweretse menyu yankhaniyo ndikusankha Chotsani Hyperlinks.

Pambuyo pake, ma hyperlink omwe ali m'maselo osankhidwa amachotsedwa, ndipo malembawo pawokha sangathe.

Ngati mukufuna kuchotsa chikalata chonse, choyamba lembani njira yaying'ono pa kiyibodi Ctrl + A. Izi zimasankha pepala lonse. Kenako, ndikudina kumanja, yimbani menyu. Mmenemo, sankhani Chotsani Hyperlinks.

Yang'anani! Njirayi sioyenera kuchotsa maulalo ngati mutalumikiza maselo ogwiritsa ntchito HYPERLINK.

Njira 4: chotsani zotsatsa (zochulukira kale kuposa Excel 2010)

Zoyenera kuchita ngati muli ndi mtundu kale kuposa Excel 2010 woyika pa kompyuta? Kodi maulalo onse ayenera kuchotsedwa pamanja? Pankhaniyi, palinso njira yotuluka, ngakhale ndizovuta kwambiri kuposa momwe tafotokozera kale. Mwa njira, njira yomweyi ingagwiritsidwe ntchito ngati mukufuna mumitundu ina.

1. Sankhani selo iliyonse yopanda pepala. Timayika manambala 1. Dinani batani Copy pa tabu "Pofikira" kapena ingolembani njira yaying'ono Ctrl + C.



2. Sankhani ma cell omwe ma hyperlink amapezeka. Ngati mukufuna kusankha mzere wonse, ndiye dinani pa dzina lake pagawo loyambira. Ngati mukufuna kusankha pepala lonse, lembani zophatikiza Ctrl + A. Dinani kumanja pazinthu zomwe zasankhidwa. Pazosankha, onaninso kawiri pazinthuzo "Ikani mwapadera ...".



3. Windo lolowetsa lapadera limatseguka. Mu makatani "Ntchito" ikani kusintha Kuchulukitsa. Dinani batani "Zabwino".

Pambuyo pake, ma hyperlink onse amachotsedwa, ndikuyika maselo osankhidwa adzakonzedwanso.

Monga mukuwonera, ma hyperlink amatha kukhala chida chosavuta chogwirizira osati ma cell osiyanasiyana a chikalata chimodzi, komanso chimalumikizana ndi zinthu zakunja. Kuchotsa maulalo kumakhala kosavuta kuchita muzosintha zatsopano za Excel, komanso munjira zakale za pulogalamuyi palinso mwayi wina wochotsa maulalo pogwiritsa ntchito zobwezera zina.