Momwe mungapangire kulumikizana. Kupanga maulalo kuti akweze pa pepala lina, pa buku lina, Hyperlink

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:

1. Maumboni omwe amagwiritsidwa ntchito mumitundu yosiyanasiyana, komanso mawonekedwe apadera.
2. 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.

chimodzi

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.

2.

3.

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.

zinai

zisanu

Ntchito ina ya masamu imatha kupangidwa chimodzimodzi. Mu purosesa yaulimi pali ziwiri zolumikizira:

1. Chowona - A1.
2. Mtundu wa R1c ndiye chisonyezo choyambirira chikuwonetsa kuchuluka kwa mzere, ndi 2nd - nambala ya mzati.

Njira yogwirizira panjira yosinthira mawonekedwe:

1. Pitani ku gawo la "Fayilo".

6.

1. Sankhani "magawo", omwe ali m'munsi mwa zenera.

7.

1. 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".

zisanu ndi zitatu

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:

1. Timasankha khungu ndikulowetsa ulalo wa khungu lina mmenemo. Mwachitsanzo, lembani: = B1.

zisanu ndi zinai

1. Mukalowa mawu, dinani "Lowani" kuti mutulutse zotsatira zomaliza.

10

1. Sunthani cholozera kumanja kwa chipinda cham'malo. Wolembayo adzatenga mawonekedwe ang'onoang'ono amdima. Kanikizani LKM ndikutambasulira mawuwo.

khumi chimodzi

1. Fomulawa idakopeka ndi ma cell apansi.

12

1. 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.

13

Tsopano lingalirani zaulanja zaulanja ndi maulalo ogwirizana. Kuwongolera kwa STRY ndi STRASE:

1. Pogwiritsa ntchito chikwangwani cha dollar "$" Timatulutsa ma adilesi a foni

khumi ndi mphabu zinayi

1. 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.

fifitini

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.

khumi ndi zisanu ndi chimodzi

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.

17.

Kuwongolera kwa STRY ndi STRASE:

1. Timasunthira ku selo lofunikira, lowetsani mawuwo "=". Tsekani LKM pa dzina la pepalalo, lomwe lili kumapeto kwa tebulo la tebulo.

khumi zisanu ndi zitatu

1. Tinasamukira ku pepala lachiwiri la chikalatacho. Mwa kukanikiza LCM, timasankha khungu lomwe tikufuna kuti likhale mu fomu.

khumi ndizisanu ndi zinai

1. Mukamaliza kuchita zonyansa zonse, dinani "Lowani". Tinapezeka kuti ali papepala loyambirira la ntchito, pomwe chiwerengero chomaliza chachotsedwa kale.

makumi awiri

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".

21.

Kuwongolera kwa STRY ndi STRASE:

1. Timasankha khungu lomwe tikufuna kuwonjezera njira. Timalowa mawuwo "=".

22.

1. Kusuntha m'buku lotseguka komwe khungu limapezeka, ulalo womwe tikufuna kuwonjezera. Dinani pa tsamba lofunikira, kenako pafoni yomwe mukufuna.

23.

1. Mukamaliza kuchita zonyansa zonse, dinani "Lowani". Tidakumana ndi pepala loyambirira lomwe zotsatira chomaliza lakhazikitsidwa kale.

24.

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:

28.

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:

1. Timapanga kusankha kwa selo yofunikira, kenako dinani pa "ikani ntchito" chinthucho, chomwe chili pafupi ndi mzere wolowa.

29.

1. Khomo likuwonetsa zenera lotchedwa "ntchito ikani". Sankhani gulu la "maulalo ndi arist".

makumi atatu

1. Dinani pa gawo la DAY. Mukamaliza kuchita zoipa zonse, dinani pa "Chabwino".

31.

1. 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".

32.

1. Takonzeka! Zotsatira zake zikuwonetsa zotsatira za ife.

33.

Kodi Hyperlink

Kupanga Hyperlink

Hyperlinks amalola kuti "atulutse" chidziwitso kuchokera maselo, komanso kusintha ku chinthu china. Gawo lotsogolera sitepe kuti mupange hyperlink:

1. 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.

34.

35.

1. Chophimba chikuwonetsa zenera lomwe limakupatsani mwayi wosintha mawu. Pali kusankha kwa zinthu zingapo. Tiyeni tikambirane njira iliyonse mwatsatanetsatane.

Momwe mungapangire zotupa pa excel ku chikalata china

Kuwongolera kwa STRY ndi STRASE:

1. Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
2. Mu "mzere", sankhani "fayilo, tsamba".
3. Mu "Search B", timasankha chikwatu chomwe fayilo ili momwe tikukonzekera kuti mulumikizane.
4. Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
5. Pambuyo pa zonse zonona, dinani pa "Chabwino".

36 Momwe Mungapangire Ma Hyperlink mu Excel patsamba

Kuwongolera kwa STRY ndi STRASE:

1. Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
2. Mu "mzere" mzere, sankhani "fayilo, tsamba" chinthu.
3. Dinani batani la "intaneti".
4. Mu "adilesi" mzere, yendetsani adilesi ya tsamba la pa intaneti.
5. Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
6. Pambuyo pa zonse zonona, dinani pa "Chabwino".

37 Momwe Mungapangire Ma Hyperlink mu Excel kudera linalake

Kuwongolera kwa STRY ndi STRASE:

1. Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
2. Mu "mzere", sankhani "fayilo, tsamba".
3. Dinani pa "tabu ..." ndikusankha pepalalo kuti mupange ulalo.
4. Pambuyo pa zonse zonona, dinani pa "Chabwino".

38 Momwe mungapangire zotupa mu Excel ku Bukhu Latsopano

Kuwongolera kwa STRY ndi STRASE:

1. Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
2. Mu mzere "mzere", sankhani "chikalata chatsopano".
3. Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
4. Mu "Chizindikiro Chatsopano" Chingwe, lowetsani dzina la chikalata chatsopano cha tabular.
5. Mu "Njira", zikuwonetsa kuti malo oti musunge chikalata chatsopano.
6. Mu mzere "nthawi yopanga chikalata chatsopano", sankhani gawo losavuta kwambiri kwa inu nokha.
7. Pambuyo pa zonse zonona, dinani pa "Chabwino".

39 Momwe Mungapangire Ma Hyperlink mu Excel kuti mupange imelo

Kuwongolera kwa STRY ndi STRASE:

1. Timatulutsa zenera lotseguka kuti lipange mawu onyenga.
2. Mu "mzere" mzere, sankhani imelo.
3. Mu mawu oti "mawu", timalowa mameseji, zomwe zidzaonetsedwa m'malo mobwereza.
4. Mu mzere "El. Makalata "akuwonetsa imelo ya wolandirayo.
5. Mu mzere wa "mutu", lembani dzina la kalatayo
6. Pambuyo pa zonse zonona, dinani pa "Chabwino".

40.

Momwe mungasinthire hyperlink mu Excel

Nthawi zambiri zimachitika kuti opangidwa mokakamira ayenera kusinthidwa. Pangani zosavuta. Kuwongolera kwa STRY ndi STRASE:

1. Timapeza foni yokhala ndi hyperlink.
2. Dinani pa PKM. Menyu yankhani yawululidwa, momwe mumasankha chinthucho "Sinthani hyperlink ...".
3. Pa zenera lomwe limawonekera, timapanga zina zonse zosintha.

41.

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:

1. Timasamukira ku "kunyumba" ndikusankha chinthu cha "masitaelo a cell".

42.

1. Dinani palemba "Hyperlink" ndi PKM ndikudina pa "Kusintha".
2. Pawindo lowonetsedwa, dinani batani la "Fomu".

43.

1. Mu "Font" ndi "Dzazani", mutha kusintha mapangidwe.

44.

Momwe Mungachotsere Hyperlink mu Excel

Chitsogozo cha sitepe ndi owongolera kuti muchotse ma hyperlinks:

1. Dinani PCM pafoni, komwe ili.
2. Mu menyu osatha, sankhani "Chotsani Hyperlink". Takonzeka!

45.

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.