Kupanga zonena ndi njira yomwe munthu aliyense wogwiritsa ntchito patebulo lapadera akukumana nalo. Maulalo amagwiritsidwa ntchito pokhazikitsanso masamba apadera a masamba, komanso kulowa m'magawo kapena zikalata zilizonse kapena zikalata. M'nkhaniyi, tikambirana mwatsatanetsatane njira yopangira maulalo ndikuwona kuti pali mafowoleti omwe angachitike nawo.
Mitundu yolumikizira
Pali mitundu iwiri yayikulu ya maulalo:- Maumboni omwe amagwiritsidwa ntchito mumitundu yosiyanasiyana, komanso mawonekedwe apadera.
- Maumboni omwe amagwiritsidwa ntchito pokonzanso zinthu zina. Amatchedwa Hyperlinks.
Maulalo onse (maulalo) amagawidwanso m'mitundu iwiri.
- Mtundu wakunja. Ankakonda kukonzanso kwa gawo lomwe lili mu chikalata china. Mwachitsanzo, patsamba lina kapena tsamba la pa intaneti.
- Mtundu wamkati. Ankakonda kuwongoleranso chinthu chomwe chili m'buku lomweli. Amagwiritsidwa ntchito moyenera mu mawonekedwe a mfundo za wothandizira kapena zinthu zothandiza za formula. Lemberani kuti mufotokozere zinthu zina zomwe zili mu chikalatacho. Maulalo awa amatha kutsogolera zinthu zonse ziwiri zofananira ndi zinthu zomwe zatsalira zomwe zidatsala.
Pali zosiyana zambiri pakupanga maulalo. Njira iyenera kusankhidwa, poganiza kuti ndi maulalo amtundu wanji omwe amafunikira mu pepala logwira ntchito. Tidzafufuza mwatsatanetsatane.
Momwe mungapangire maulalo pa pepala limodzi
Lingaliro losavuta ndikutchula ma adilesi a cell mu fomu iyi: = B2.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_1](/userfiles/21/20388_1.webp)
Chizindikiro "=" ndiye gawo lalikulu la ulalo. Nditalemba chizindikiro ichi pamzere wolowamo, pulower pussesaur iyamba kuzindikira mtengowu ngati ulalo. Ndikofunikira kuti mulowetse adilesi ya selo kuti pulogalamuyo ipange zosintha zambiri. Mu zitsanzo, mtengo wake "= B2" amatanthauza kuti mu D3 munda womwe tidalowa ulalo udzatsogolere kuchokera ku cell ya B2.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_2](/userfiles/21/20388_2.webp)
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_3](/userfiles/21/20388_3.webp)
Zonsezi zimalola kuti pakhale mitundu yosiyanasiyana ya ogwiritsa ntchito mu processor. Mwachitsanzo, timalemba njira yotsatirayi mu D3 Field: = A5 + B2. Pambuyo polowa njirayi, akanikizire "Lowani". Zotsatira zake, timapeza chifukwa chowonjezera ma cell B2 ndi A5.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_4](/userfiles/21/20388_4.webp)
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_5](/userfiles/21/20388_5.webp)
Ntchito ina ya masamu imatha kupangidwa chimodzimodzi. Mu purosesa yaulimi pali ziwiri zolumikizira:
- Chowona - A1.
- Mtundu wa R1c ndiye chisonyezo choyambirira chikuwonetsa kuchuluka kwa mzere, ndi 2nd - nambala ya mzati.
Njira yogwirizira panjira yosinthira mawonekedwe:
- Pitani ku gawo la "Fayilo".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_6](/userfiles/21/20388_6.webp)
- Sankhani "magawo", omwe ali m'munsi mwa zenera.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_7](/userfiles/21/20388_7.webp)
- Chophimba chikuwonetsa zenera ndi magawo. Timasunthira kupita ku gawo lotchedwa "njira". Timapeza "kugwira ntchito ndi njira" ndikuyika chizindikiro pafupi ndi "gawo lolumikizana R1C1". Mukamaliza kuchita zoipa zonse, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_8](/userfiles/21/20388_8.webp)
Pali mitundu iwiri ya maulalo:
- Buku lotherali ku malo ena a chinthu china, mosasamala kanthu za chinthucho.
- Achibale amatchula malo omwe mbali zake ndi cell yomaliza ndi mawu ojambulidwa.
Mosakayikira, maulalo onse owonjezera amadziwika kuti ndi wachibale. Ganizirani zatsoka pankhani yopanda maumboni. Kuwongolera kwa STRY ndi STRASE:
- Timasankha khungu ndikulowetsa ulalo wa khungu lina mmenemo. Mwachitsanzo, lembani: = B1.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_9](/userfiles/21/20388_9.webp)
- Mukalowa mawu, dinani "Lowani" kuti mutulutse zotsatira zomaliza.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_10](/userfiles/21/20388_10.webp)
- Sunthani cholozera kumanja kwa chipinda cham'malo. Wolembayo adzatenga mawonekedwe ang'onoang'ono amdima. Kanikizani LKM ndikutambasulira mawuwo.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_11](/userfiles/21/20388_11.webp)
- Fomulawa idakopeka ndi ma cell apansi.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_12](/userfiles/21/20388_12.webp)
- Tikuwona kuti mu maselo apansi, ulalo womwe walowa wasintha kukhala gawo limodzi ndi malo amodzi. Zotsatira zake zinali chifukwa cha kugwiritsa ntchito kwa ophunzirira ena.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_13](/userfiles/21/20388_13.webp)
Tsopano lingalirani zaulanja zaulanja ndi maulalo ogwirizana. Kuwongolera kwa STRY ndi STRASE:
- Pogwiritsa ntchito chikwangwani cha dollar "$" Timatulutsa ma adilesi a foni
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_14](/userfiles/21/20388_14.webp)
- Timatambasulira, komanso chitsanzo pamwambapa, kalamula pansi. Tikuwona kuti maselo omwe ali pansipa amakhalanso zizindikilo zomwezo ngati mu chipinda choyamba. Ulalo wapathengo walemba mfundo zam'malo, ndipo tsopano sasintha pamene fomuyo imasungunuka.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_15](/userfiles/21/20388_15.webp)
China chilichonse, mu purosesa laulemu, mutha kugwiritsa ntchito ulalo pamtunda wa maselo. Choyamba, adilesi ya foni yakumanzere yalembedwa, kenako nkwakuti. Pakati pa mgwirizano ndi wolumikizira ":". Mwachitsanzo, chithunzi chomwe chili pansipa, mtundu wa A1 wafotokozedwa: C6. Ponena za mtundu uwu ndi: = A1: C6.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_16](/userfiles/21/20388_16.webp)
Kupanga ulalo pa pepala lina
Tsopano taganizirani momwe mungapangire zonena za ma sheet ena. Apa, kuwonjezera pa foni yam'manja, adilesi ya pepala linalake logwirizira limafotokozedwanso. Mwanjira ina, pambuyo pa chizindikirocho "=", dzina la ntchito yogwira ntchito imayambitsidwa, ndiye kuti chizindikirocho chalembedwa, ndipo adilesi ya chinthu chofunikira imawonjezedwa kumapeto. Mwachitsanzo, kulumikizana pa cell cell, komwe kumakhala papepala lotchedwa "mndandanda2", ndi motere: = Mndandanda2! C5.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_17](/userfiles/21/20388_17.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timasunthira ku selo lofunikira, lowetsani mawuwo "=". Tsekani LKM pa dzina la pepalalo, lomwe lili kumapeto kwa tebulo la tebulo.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_18](/userfiles/21/20388_18.webp)
- Tinasamukira ku pepala lachiwiri la chikalatacho. Mwa kukanikiza LCM, timasankha khungu lomwe tikufuna kuti likhale mu fomu.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_19](/userfiles/21/20388_19.webp)
- Mukamaliza kuchita zonyansa zonse, dinani "Lowani". Tinapezeka kuti ali papepala loyambirira la ntchito, pomwe chiwerengero chomaliza chachotsedwa kale.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_20](/userfiles/21/20388_20.webp)
Kutchula kunja kwa buku lina
Ganizirani momwe angagwiritsire ntchito ulalo wakunja ku buku lina. Mwachitsanzo, tifunika kukhazikitsa chilengedwe cha belo la B5, lomwe lili pazenera la buku lotseguka "limalumikizidwa.xlx".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_21](/userfiles/21/20388_21.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timasankha khungu lomwe tikufuna kuwonjezera njira. Timalowa mawuwo "=".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_22](/userfiles/21/20388_22.webp)
- Kusuntha m'buku lotseguka komwe khungu limapezeka, ulalo womwe tikufuna kuwonjezera. Dinani pa tsamba lofunikira, kenako pafoni yomwe mukufuna.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_23](/userfiles/21/20388_23.webp)
- Mukamaliza kuchita zonyansa zonse, dinani "Lowani". Tidakumana ndi pepala loyambirira lomwe zotsatira chomaliza lakhazikitsidwa kale.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_24](/userfiles/21/20388_24.webp)
Lumikizani kuti mupange fayilo pa seva
Ngati chikalatacho chili, mwachitsanzo, mu chikwatu cha seva ya kampani, ndiye kuti chitha kutchulidwa motere:25.Lumikizani kutchulidwa
Prosesar processor imakupatsani mwayi woti mupange ulalo wa mtundu wina womwe ukutchulidwa kudzera mwa "manejala a dzina". Kuti muchite izi, ingolowetsani dzina la magawo mu ulalowo pawokha:
26.Kutchula za mndandanda wotchulidwa m'bokosi lakunja, muyenera kumveketsa bwino dzina lake, komanso kutchula njira:
27.Lumikizani patebulo lanzeru kapena zinthu zake
Kugwiritsa ntchito wothandizira wa hyperslob, mutha kukhala ndi kulumikizana kwa tebulo la "luntha" kapena mbale yonse yonse. Zikuwoneka kuti:
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_25](/userfiles/21/20388_25.webp)
Kugwiritsa ntchito dvsl
Kuti mugwiritse ntchito ntchito zosiyanasiyana, mutha kugwiritsa ntchito ntchito yapadera ya DVSL. Kuwona kwa General: = DVSL (Cont_int_ichi; A1). Tidzakambirana mwatsatanetsatane mwachidule pa chitsanzo chapadera. Kuwongolera kwa STRY ndi STRASE:
- Timapanga kusankha kwa selo yofunikira, kenako dinani pa "ikani ntchito" chinthucho, chomwe chili pafupi ndi mzere wolowa.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_26](/userfiles/21/20388_26.webp)
- Khomo likuwonetsa zenera lotchedwa "ntchito ikani". Sankhani gulu la "maulalo ndi arist".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_27](/userfiles/21/20388_27.webp)
- Dinani pa gawo la DAY. Mukamaliza kuchita zoipa zonse, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_28](/userfiles/21/20388_28.webp)
- Chiwonetserochi chikuwonetsa zenera kuti mulowetse mikangano. Mu mzere "cholumikizira" Ndimadziwitsa gwiritsirani bwino khungu lomwe tikufuna kutchula. Mzere "A1" siyani opanda kanthu. Pambuyo pa zonona zonse, dinani batani la "OK".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_29](/userfiles/21/20388_29.webp)
- Takonzeka! Zotsatira zake zikuwonetsa zotsatira za ife.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_30](/userfiles/21/20388_30.webp)
Kodi Hyperlink
Kupanga Hyperlink
Hyperlinks amalola kuti "atulutse" chidziwitso kuchokera maselo, komanso kusintha ku chinthu china. Gawo lotsogolera sitepe kuti mupange hyperlink:
- Poyamba, ndikofunikira kulowa pazenera lapadera lomwe limakupatsani mwayi wopanga mawu. Pali njira zambiri zogwirira ntchito izi. Woyamba - Kanikizani PKM pafoni yofunikira ndipo muzosankha zankhaniyo Sankhani gawo "ulalo ...". Lachiwiri - sankhani foni yomwe mukufuna, ikani gawo "ndikusankha" ulalo ". Chachitatu - gwiritsani ntchito kofunikira "ctrl + k" k.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_31](/userfiles/21/20388_31.webp)
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_32](/userfiles/21/20388_32.webp)
- Chophimba chikuwonetsa zenera lomwe limakupatsani mwayi wosintha mawu. Pali kusankha kwa zinthu zingapo. Tiyeni tikambirane njira iliyonse mwatsatanetsatane.
Kuwongolera kwa STRY ndi STRASE:
- Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
- Mu "mzere", sankhani "fayilo, tsamba".
- Mu "Search B", timasankha chikwatu chomwe fayilo ili momwe tikukonzekera kuti mulumikizane.
- Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
- Pambuyo pa zonse zonona, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_33](/userfiles/21/20388_33.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
- Mu "mzere" mzere, sankhani "fayilo, tsamba" chinthu.
- Dinani batani la "intaneti".
- Mu "adilesi" mzere, yendetsani adilesi ya tsamba la pa intaneti.
- Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
- Pambuyo pa zonse zonona, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_34](/userfiles/21/20388_34.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
- Mu "mzere", sankhani "fayilo, tsamba".
- Dinani pa "tabu ..." ndikusankha pepalalo kuti mupange ulalo.
- Pambuyo pa zonse zonona, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_35](/userfiles/21/20388_35.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
- Mu mzere "mzere", sankhani "chikalata chatsopano".
- Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
- Mu "Chizindikiro Chatsopano" Chingwe, lowetsani dzina la chikalata chatsopano cha tabular.
- Mu "Njira", zikuwonetsa kuti malo oti musunge chikalata chatsopano.
- Mu mzere "nthawi yopanga chikalata chatsopano", sankhani gawo losavuta kwambiri kwa inu nokha.
- Pambuyo pa zonse zonona, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_36](/userfiles/21/20388_36.webp)
Kuwongolera kwa STRY ndi STRASE:
- Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
- Mu "mzere" mzere, sankhani imelo.
- Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
- Mu mzere "El. Makalata "akuwonetsa imelo ya wolandirayo.
- Mu mzere wa "mutu", lembani dzina la kalatayo
- Pambuyo pa zonse zonona, dinani pa "Chabwino".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_37](/userfiles/21/20388_37.webp)
Momwe mungasinthire hyperlink mu Excel
Nthawi zambiri zimachitika kuti opangidwa mokakamira ayenera kusinthidwa. Pangani zosavuta. Kuwongolera kwa STRY ndi STRASE:
- Timapeza foni yokhala ndi hyperlink.
- Dinani pa PKM. Menyu yankhani yawululidwa, momwe mumasankha chinthucho "Sinthani hyperlink ...".
- Pa zenera lomwe limawonekera, timapanga zina zonse zosintha.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_38](/userfiles/21/20388_38.webp)
Momwe mungapangire mawonekedwe a hyperlink mu Excel
Momwemonso, zomwe zimatanthauzira pa purosesa ya tebulo zimawonetsedwa ngati zolemba za buluu. Mtundu ukhoza kusinthidwa. Kuwongolera kwa STRY ndi STRASE:
- Timasamukira ku "kunyumba" ndikusankha chinthu cha "masitaelo a cell".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_39](/userfiles/21/20388_39.webp)
- Dinani palemba "Hyperlink" ndi PKM ndikudina pa "Kusintha".
- Pawindo lowonetsedwa, dinani batani la "Fomu".
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_40](/userfiles/21/20388_40.webp)
- Mu "Font" ndi "Dzazani", mutha kusintha mapangidwe.
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_41](/userfiles/21/20388_41.webp)
Momwe Mungachotsere Hyperlink mu Excel
Chitsogozo cha sitepe ndi owongolera kuti muchotse ma hyperlinks:
- Dinani PCM pafoni, komwe ili.
- Mu menyu osatha, sankhani "Chotsani Hyperlink". Takonzeka!
![Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink 20388_42](/userfiles/21/20388_42.webp)
Kugwiritsa ntchito zizindikiro zosagwirizana
Pali zochitika ngati wothandizira hyperlink imatha kuphatikizidwa ndi ntchito yopanga zilembo zosadziwika. Njira yodziwitsa yomwe imalowa m'malo mwa chizolowezi cholumikizira ndi chizindikiro chilichonse chosayenera.46.Mapeto
Tidazindikira kuti pagombe la tebulo apamwamba pali njira zambiri zomwe zimakupatsani mwayi woti mupange ulalo. Kuphatikiza apo, tinadziwana ndi momwe tingapangire zotupa zopita ku zinthu zosiyanasiyana. Ndikofunika kudziwa kuti kutengera kaonedwe kake kaumboni, njira yogwiritsira ntchito kusintha kwa zosintha.
Mauthenga Momwe mungapangire ulalo wa Excel. Kupanga zolemba kuposa tsamba lina, pa buku lina, mawu onyengawa adawonekera koyamba kuzaukadaulo.