Momwe mungapangire ulalo ku Excel. Kupanga maulalo mu Excel ku pepala lina, ku bukhu lina, hyperlink

Kupanga maulalo ndi njira yomwe wogwiritsa ntchito aliyense wa Excel spreadsheet amakumana nayo. Maulalo amagwiritsidwa ntchito kuyika zolozera kumasamba enaake, komanso kupeza magwero aliwonse akunja kapena zolemba. M'nkhaniyi, tiwona mwatsatanetsatane njira yopangira maulalo ndikupeza zomwe zingagwiritsidwe ntchito nawo.

Mitundu yosiyanasiyana ya maulalo

Pali mitundu iwiri yayikulu yamalumikizidwe:

1. Maumboni omwe amagwiritsidwa ntchito mumitundu yosiyanasiyana yowerengera, komanso ntchito zapadera.
2. Maulalo omwe amagwiritsidwa ntchito polowera kuzinthu zinazake. Iwo amatchedwa hyperlink.

Maulalo onse (maulalo) amagawidwanso m'mitundu iwiri.

• mtundu wakunja. Amagwiritsidwa ntchito kulondolera ku chinthu chomwe chili muzolemba zina. Mwachitsanzo, pa chizindikiro china kapena tsamba la webusayiti.
• Mtundu wamkati. Amagwiritsidwa ntchito kulondolera ku chinthu chomwe chili m'buku lomwelo. Mwachikhazikitso, amagwiritsidwa ntchito ngati mawonekedwe a opareshoni kapena zinthu zina zachilinganizo. Amagwiritsidwa ntchito kutchula zinthu zina mkati mwa chikalata. Maulalo awa amatha kutsogolera zonse kuzinthu za pepala limodzi komanso kuzinthu zamasamba ena a chikalata chomwecho.

Pali mitundu ingapo yamapangidwe olumikizirana. Njirayo iyenera kusankhidwa, poganizira za mtundu wanji wofunikira mu chikalata chogwira ntchito. Tiyeni tiwunike njira iliyonse mwatsatanetsatane.

Momwe mungapangire maulalo papepala lomwelo

Ulalo wosavuta ndikutchula ma adilesi am'manja motere: =B2.

Chizindikiro "=" ndiye gawo lalikulu la ulalo. Pambuyo polemba munthu uyu pamzere wolowetsa mafomula, spreadsheet iyamba kuona mtengo uwu ngati kalozera. Ndikofunikira kuti mulowetse bwino adilesi ya selo kuti pulogalamuyo igwire bwino chidziwitsocho. Mu chitsanzo chomwe chaganiziridwa, mtengo "= B2" umatanthauza kuti mtengo wochokera ku selo B3 udzatumizidwa kumunda D2, momwe tinalowamo.

Ndikoyenera kudziwa! Ngati tisintha mtengo mu B2, ndiye kuti isintha nthawi yomweyo mu cell D3.

Zonsezi zimakupatsani mwayi wochita masamu osiyanasiyana mu purosesa ya spreadsheet. Mwachitsanzo, tiyeni tilembe chilinganizo chotsatirachi pagawo la D3: =A5+B2. Mukalowetsa fomuyi, dinani "Enter". Zotsatira zake, timapeza zotsatira zowonjezera ma cell B2 ndi A5.

Ntchito zina za masamu zikhoza kuchitidwa mofananamo. Pali mitundu iwiri yolumikizirana mu spreadsheet:

1. Mawonekedwe okhazikika - A1.
2. Mtundu R1C Chizindikiro choyamba chikuwonetsa nambala ya mzere, ndipo chachiwiri chikuwonetsa nambala yagawo.

Njira yosinthira kalembedwe ka coordinate ndi motere:

1. Timapita ku gawo la "Fayilo".

2. Sankhani "Zosankha" zomwe zili m'munsi kumanzere kwa zenera.

3. Zenera lokhala ndi zosankha limawonekera pazenera. Timapita ku gawo lotchedwa "Formulas". Timapeza "Kugwira ntchito ndi mafomu" ndikuyika chizindikiro pafupi ndi chinthu "Reference style R1C1". Pambuyo pochita zosintha zonse, dinani "Chabwino".

Pali mitundu iwiri ya maulalo:

• Mtheradi kutanthauza malo a chinthu china, mosasamala kanthu za chinthu chomwe chaperekedwa.
• Chibale chimatanthawuza malo a zinthu okhudzana ndi selo lomaliza ndi mawu olembedwa.

Tcherani khutu! M'maumboni mtheradi, chizindikiro cha dola "$" chimaperekedwa patsogolo pa dzina lazambiri ndi nambala ya mzere. Mwachitsanzo, $B $3.

Mwachikhazikitso, maulalo onse owonjezeredwa amaganiziridwa kuti ndi achibale. Taganizirani chitsanzo cha kuwongolera maulalo achibale. Kuyenda:

1. Timasankha selo ndikulowetsa ulalo wa cell ina momwemo. Mwachitsanzo, tiyeni tilembe: =V1.

2. Mukalowa mawuwo, dinani "Enter" kuti muwonetse zotsatira zomaliza.

3. Sunthani cholozera ku ngodya yakumanja ya selo. Cholozeracho chidzakhala ngati chizindikiro chaching'ono chamdima chophatikiza. Gwirani LMB ndikukokera mawuwo pansi.

4. Fomula yake yakoperedwa m'maselo apansi.

5. Timazindikira kuti m'maselo apansi ulalo wolowetsedwa wasintha ndi malo amodzi ndikusintha kwa sitepe imodzi. Chotsatirachi chimabwera chifukwa chogwiritsa ntchito chidziwitso chogwirizana.

Tsopano tiyeni tione chitsanzo cha kusokoneza mtheradi maumboni. Kuyenda:

1. Pogwiritsa ntchito chizindikiro cha dola "$" timakonza adilesi ya selo patsogolo pa dzina lazambiri ndi nambala ya mzere.

2. Timatambasula, monga mu chitsanzo pamwambapa, chilinganizo pansi. Timazindikira kuti maselo omwe ali pansipa ali ndi zizindikiro zofanana ndi zomwe zili mu selo yoyamba. Kufotokozera mtheradi kunakhazikitsa ma cell, ndipo tsopano sasintha fomulo likasinthidwa.

Kuphatikiza apo, mu spreadsheet, mutha kukhazikitsa ulalo wama cell angapo. Choyamba, adilesi ya cell yakumanzere kwambiri imalembedwa, kenako cell yakumanja yakumanja. Colon ":"" imayikidwa pakati pa ma coordinates. Mwachitsanzo, pa chithunzi pansipa, mtundu A1: C6 wasankhidwa. Kufotokozera kwamtunduwu kumawoneka ngati: =A1:C6.

Pangani ulalo kutsamba lina

Tsopano tiyeni tiwone momwe tingapangire maulalo kumasamba ena. Apa, kuwonjezera pa kugwirizanitsa kwa selo, adiresi ya pepala linalake limasonyezedwanso. Mwa kuyankhula kwina, pambuyo pa chizindikiro cha "=", dzina la tsamba la ntchito likulowetsedwa, ndiye chizindikiro chofuula chimalembedwa, ndipo adiresi ya chinthu chofunikacho ikuwonjezeredwa kumapeto. Mwachitsanzo, ulalo wa cell C5, womwe uli patsamba lotchedwa "Sheet2", umawoneka motere: = Sheet2! C5.

Kuyenda:

1. Pitani ku cell yomwe mukufuna, lowetsani chizindikiro "="". Dinani LMB pa dzina la pepala, lomwe lili pansi pa mawonekedwe a spreadsheet.

2. Tasamukira ku pepala lachiwiri la chikalatacho. Mwa kuwonekera pa batani lakumanzere la mbewa, timasankha selo lomwe tikufuna kugawa fomula.

3. Pambuyo pochita zosintha zonse, dinani "Enter". Tinadzipeza tokha patsamba loyambirira, momwe chizindikiro chomaliza chawonetsedwa kale.

Ulalo wakunja kwa buku lina

Ganizirani momwe mungagwiritsire ntchito ulalo wakunja kubuku lina. Mwachitsanzo, tifunika kukhazikitsa ulalo wa cell B5, yomwe ili patsamba lotseguka la "Links.xlsx".

Kuyenda:

1. Sankhani selo lomwe mukufuna kuwonjezera fomula. Lowetsani chizindikiro "="".

2. Timasunthira ku bukhu lotseguka momwe selo lilili, ulalo womwe tikufuna kuwonjezera. Dinani pa pepala lofunika, ndiyeno pa cell yomwe mukufuna.

3. Pambuyo pochita zosintha zonse, dinani "Enter". Tinathera pa pepala loyambirira, momwe zotsatira zomaliza zawonetsedwa kale.

Lumikizani ku fayilo pa seva

Ngati chikalatacho chili, mwachitsanzo, mufoda yogawidwa ya seva yamakampani, ndiye kuti ikhoza kufotokozedwa motere:

Kutengera mtundu womwe watchulidwa

Spreadsheet imakupatsani mwayi wopanga zolozera kumtundu womwe watchulidwa, wokhazikitsidwa kudzera mu "Name Manager". Kuti muchite izi, muyenera kungoyika dzina lamitundu mu ulalo womwewo:

Kuti mutchule ulalo wamtundu womwe watchulidwa mu chikalata chakunja, muyenera kufotokoza dzina lake, komanso kufotokoza njira:

Lumikizani ku tebulo lanzeru kapena zinthu zake

Pogwiritsa ntchito HYPERLINK, mutha kulumikizana ndi chidutswa chilichonse cha tebulo la "smart" kapena patebulo lonse. Zikuwoneka motere:

Kugwiritsa ntchito INDIRECT

Kuti mugwiritse ntchito ntchito zosiyanasiyana, mutha kugwiritsa ntchito INDIRECT yapadera. Maonedwe onse a wogwiritsa ntchito: =INDIRECT(Cell_reference,A1). Tiyeni tiwunike woyendetsa mwatsatanetsatane pogwiritsa ntchito chitsanzo chapadera. Kuyenda:

1. Timasankha selo lofunika, ndiyeno dinani chinthu cha "Insert Function", chomwe chili pafupi ndi mzere wolowetsa mafomu.

2. Zenera lotchedwa "Insert Function" linawonetsedwa pazenera. Sankhani gulu la "References and Arrays".

3. Dinani pa chinthu INDIRECT. Pambuyo pochita zosintha zonse, dinani "Chabwino".

4. Chiwonetserocho chikuwonetsa zenera lolowetsa mikangano ya wogwiritsa ntchito. Mu mzere "Link_to_cell" lowetsani mgwirizano wa selo lomwe tikufuna kulozerako. Mzere "A1" watsala wopanda kanthu. Pambuyo pochita zosintha zonse, dinani batani "Chabwino".

5. Okonzeka! Selo likuwonetsa zotsatira zomwe tikufuna.

Kodi hyperlink ndi chiyani

Hyperlink ndi chidutswa cha chikalata chomwe chimatanthawuza chinthu chomwe chili mu chikalata chomwecho kapena chinthu china chomwe chili pa hard drive kapena pa intaneti. Tiyeni tiwone mwatsatanetsatane njira yopangira ma hyperlink.

Pangani ma hyperlink

Ma hyperlink amalola osati "kutulutsa" zambiri kuchokera ku maselo, komanso kupita kuzinthu zomwe zatchulidwa. Ndondomeko ya sitepe ndi sitepe kuti mupange hyperlink:

1. Poyamba, muyenera kulowa pawindo lapadera lomwe limakupatsani mwayi wopanga ma hyperlink. Pali njira zambiri zochitira izi. Choyamba - dinani kumanja pa foni yofunikira ndikusankha chinthu cha "Link ..." mumenyu yankhani. Chachiwiri - sankhani selo lomwe mukufuna, pitani ku gawo la "Insert" ndikusankha chinthu cha "Link". Chachitatu - gwiritsani ntchito kiyi "CTRL + K".

2. Zenera likuwonekera pazenera lomwe limakupatsani mwayi wopanga ma hyperlink. Pali kusankha kwa zinthu zingapo pano. Tiyeni tione mwatsatanetsatane njira iliyonse.

Momwe mungapangire hyperlink mu Excel kupita ku chikalata china

Kuyenda:

1. Timatsegula zenera kuti tipange hyperlink.
2. Mu mzere wa "Link", sankhani "Fayilo, tsamba lawebusayiti".
3. Mu mzere "Sakani mkati" timasankha chikwatu chomwe fayilo ili, yomwe tikukonzekera kupanga ulalo.
4. Pamzere wa "Text" timalowetsa zolemba zomwe zidzawonetsedwa m'malo mwa ulalo.
5. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Momwe mungapangire hyperlink mu Excel patsamba lawebusayiti

Kuyenda:

1. Timatsegula zenera kuti tipange hyperlink.
2. Mu mzere wa "Link", sankhani "Fayilo, tsamba lawebusayiti".
3. Dinani pa "Internet" batani.
4. Mu mzere "Adilesi" timayendetsa pa adiresi ya tsamba la intaneti.
5. Pamzere wa "Text" timalowetsa zolemba zomwe zidzawonetsedwa m'malo mwa ulalo.
6. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Momwe mungapangire hyperlink mu Excel kudera linalake muzolemba zomwe zilipo

Kuyenda:

1. Timatsegula zenera kuti tipange hyperlink.
2. Mu mzere wa "Link", sankhani "Fayilo, tsamba lawebusayiti".
3. Dinani pa "Bookmark ..." ndikusankha pepala kuti mupange ulalo.
4. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Momwe mungapangire hyperlink mu Excel kupita ku bukhu latsopano lantchito

Kuyenda:

1. Timatsegula zenera kuti tipange hyperlink.
2. Mu mzere wa "Link", sankhani chinthu cha "New Document".
3. Pamzere wa "Text" timalowetsa zolemba zomwe zidzawonetsedwa m'malo mwa ulalo.
4. Mu mzere "Dzina la chikalata chatsopano" lowetsani dzina la chikalata chatsopano cha spreadsheet.
5. Mu mzere wa "Njira", tchulani malo osungira chikalata chatsopano.
6. Pamzere "Pamene mungasinthire chikalata chatsopano", sankhani njira yabwino kwambiri kwa inu nokha.
7. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Momwe Mungapangire Hyperlink mu Excel Kuti mupange Imelo

Kuyenda:

1. Timatsegula zenera kuti tipange hyperlink.
2. Mu mzere wa "Lumikizani", sankhani chinthu "Imelo".
3. Pamzere wa "Text" timalowetsa zolemba zomwe zidzawonetsedwa m'malo mwa ulalo.
4. Mu mzere "Imelo adilesi. mail” tchulani adilesi ya imelo ya wolandila.
5. Lowetsani dzina la imelo pamutuwu
6. Pambuyo pochita zosintha zonse, dinani "Chabwino".

Momwe mungasinthire hyperlink mu Excel

Nthawi zambiri zimachitika kuti hyperlink yomwe idapangidwa iyenera kusinthidwa. Ndikosavuta kuchita izi. Kuyenda:

1. Timapeza cell yokhala ndi hyperlink yokonzeka.
2. Timadina pa izo RMB. Menyu yankhani imatsegulidwa, momwe timasankha "Sinthani hyperlink ...".
3. Pawindo lomwe likuwoneka, timapanga zosintha zonse zofunika.

Momwe mungapangire hyperlink mu Excel

Mwachisawawa, maulalo onse mu spreadsheet amawonetsedwa ngati mawu a buluu. Mtundu ukhoza kusinthidwa. Kuyenda:

1. Timasunthira ku "Home" ndikusankha chinthu "Mawonekedwe a Ma cell".

2. Dinani pazolembedwa "Hyperlink" RMB ndikudina "Sinthani".
3. Pazenera lomwe likuwoneka, dinani batani la "Format".

4. Mutha kusintha masanjidwe mu magawo a Font ndi Shading.

Momwe mungachotsere hyperlink mu Excel

Ndondomeko ya sitepe ndi sitepe kuchotsa hyperlink:

1. Dinani kumanja pa selo pomwe ili.
2. Mu menyu yankhani yomwe imatsegulidwa, sankhani chinthu "Chotsani hyperlink". Okonzeka!

Kugwiritsa ntchito zilembo zosavomerezeka

Pali nthawi zina pomwe wogwiritsa HYPERLINK angaphatikizidwe ndi SYMBOL yotulutsa zilembo zosavomerezeka. Ndondomekoyi imagwiritsa ntchito kusintha mawu osavuta a ulalo ndi zilembo zina zosagwirizana ndi muyezo.

Kutsiliza

Tidapeza kuti mu Excel spreadsheet pali njira zambiri zomwe zimakulolani kuti mupange ulalo. Kuphatikiza apo, taphunzira kupanga ma hyperlink omwe amatsogolera kuzinthu zosiyanasiyana. Tiyenera kuzindikira kuti kutengera mtundu wosankhidwa wa ulalo, njira yoyendetsera ulalo wofunikira ikusintha.