Cell Lock mu Microsoft Excel

Excel ndi tebulo lamphamvu, mukamagwira ntchito ndi zomwe zinthu zimasinthidwa, ma adilesi amasinthidwa, etc. Koma nthawi zina, muyenera kukonza chinthu china kapena, monga anena mwanjira ina, chimasuleni kuti chisasinthe malo ake. Tiyeni tiwone zomwe angasankhe izi.

Mitundu ya Kusintha

Ziyenera kunenedwa nthawi yomweyo kuti mitundu yosintha mu Excel ikhoza kukhala yosiyana kotheratu. Zambiri, zimatha kugawidwa m'magulu akulu akulu:

1. Adilesi yozizira;
2. Kukonza kwa maselo;
3. Tetezani zinthu kuti zisasinthidwe.

Adilesi ikakhala yozizira, cholumikizana ndi foni sichisintha chikakopera, ndiye kuti, chimasiya kukhala chachibale. Kukhazikitsa maselo kumawathandiza kuti azitha kuwoneka pafupipafupi pazenera, osagwiritsa ntchito akasegulira pepala pansi kapena kumanja. Kuteteza zinthu kuti zisasinthidwe kumalepheretsa kusintha kulikonse kwa data pazomwe zanenedwazo. Tiyeni tiwone mwanjira iliyonse izi.

Njira 1: adilesi yozizira

Choyamba, tiyeni tikambirane kukonza adilesi ya foni. Kuti mumasuleni, kuchokera pakulumikizana, komwe kuli adilesi iliyonse ku Excel mwachisawawa, muyenera kupanga cholumikizira chonse chomwe sichimasintha magwirizanidwe mukamakopera. Kuti muchite izi, muyenera kukhazikitsa chikwangwani cha dola ku adilesi iliyonse yoyang'anira ($).

Kukhazikitsa chizindikiro cha dollar kumachitika ndikudina chizindikiro chofananira pa kiyibodi. Ili pa kiyi imodzi ndi nambala "4", koma kuti muwonetse, muyenera kukanikiza fungulo ili mu mawonekedwe achingelezi achingerezi pamtunda wapamwamba (ndi kiyi ikanikizidwa Shift) Pali njira yosavuta komanso yachangu. Sankhani adilesi ya chinthucho mu selo linalake kapena mu mzere wa ntchito ndikanikizani batani la chinthucho F4. Nthawi yoyamba mukakanikiza chikwangwani cha dollar, chiziwoneka pa adilesi ya mzere ndi mzere, kachiwiri mukakanikiza batani ili, lidzangokhala pa adilesi ya mzerewo, ndipo kachitatu mukakanikiza, adilesi ya mzere. Njira yachinayi F4 amachotsa chikwangwani cha dollar kwathunthu, ndipo chotsatira chimayamba njirayi pagulu latsopano.

Tiyeni tiwone momwe maofesi ozizira amagwirira ntchito pa konkriti.

1. Choyamba, koperani formula yokhazikika muzinthu zina zagawo. Kuti muchite izi, gwiritsani ntchito chikhomo. Ikani cholozera mu ngodya ya kumunsi kwa foniyo, zomwe ndi zomwe mukufuna kutengera. Nthawi yomweyo imasandutsidwa mtanda, womwe umatchedwa kuti cholembera. Gwirani batani lakumanzere ndikukokera mtanda uwu kumapeto kwa tebulo.



2. Pambuyo pake, sankhani gawo la bottommost patebulopo ndikuyang'ana pamndandanda wazomwe machitidwewo adasinthira kukopera. Monga mukuwonera, maulalo onse omwe anali pachiwonetsero choyambirira adasuntha mukamakopera. Zotsatira zake, mawonekedwe ake amapanga zotsatira zolakwika. Izi ndichifukwa choti adilesi ya chinthu chachiwiri, mosiyana ndi choyambirira, sichiyenera kusinthidwa kuti chiwerengedwe cholondola, ndiye kuti, iyenera kukhala yopangidwa yonse.



3. Timabwereranso ku gawo loyambirira la chipilalacho ndikukhazikitsa chikwangwani cha dollar pafupi ndi ogwirizanitsa ndi chinthu chachiwiri mwanjira imodzi yomwe tidakambirana pamwambapa. Tsopano ulalowu wazizira.



4. Pambuyo pake, pogwiritsa ntchito chodzaza, zilembeni pamitundu yosiyanasiyana.



5. Kenako sankhani gawo lomaliza la chipilalacho. Monga momwe tikuwonera kudzera pamzera wamanzere, zolumikizira za chinthu choyambirira zimasinthidwa mukamakopera, koma adilesi yachiwiriyo, yomwe tidapanga mwamtheradi, sasintha.



6. Ngati mukuyika chikwangwani cha dola pokhapokha pogwirizanitsa mzere, ndiye kuti adilesiyo ikakhala yolumikizidwa, ndi ogwirizanitsa a mzereyo adzasunthidwa mukamakopera.



7. Ndipo mosinthanitsa, ngati mungayike chikwangwani cha dola pafupi ndi adilesi ya mzere, ndiye kuti mukakopera sichisintha, mosiyana ndi adilesi ya mzere.

Njirayi imawongolera zogwirizana ndi maselo.

Phunziro: Adilesi Yathunthu ku Excel

Njira 2: mapini apini

Tsopano timaphunzira kukonza maselo kuti azikhala pachithunzichi, kulikonse komwe wogwiritsa ntchito ali m'malire a pepalalo. Nthawi yomweyo, ziyenera kudziwika kuti chinthu chimodzi sichingakonzeke, koma dera lomwe likupezeka litha kukhazikitsidwa.

Ngati maselo ofunikira ali kumtunda wapamwamba kwambiri wa pepalalo kapena mzere wake wamanzere, ndiye kuti kukhomola ndi kosavuta.

1. Kuti musinthe mzere, chitani zotsatirazi. Pitani ku tabu "Onani" ndipo dinani batani "Malo okhala"ili mu chipangizo "Window". Mndandanda wazosankha zingapo za pini umatsegulidwa. Sankhani dzina "Tsekani mzere wapamwamba".



2. Tsopano ngakhale mutatsikira pansi pa pepalalo, mzere woyamba, ndipo chifukwa chake chinthu chomwe mukufuna, chomwe chili momwemo, chikhala pamwamba kwambiri pazenera.

Mofananamo, mutha kumasula mzere wamanzere.

1. Pitani ku tabu "Onani" ndipo dinani batani "Malo okhala". Tsopano sankhani Kwezerani Khola Loyamba.



2. Monga mukuwonera, mzati wamanzere tsopano walemba.

Pafupifupi momwemonso, mutha kukonza osati mzere woyamba ndi mzere, koma mwachidule dera lonse lomwe lili kumanzere ndi pamwamba pazinthu zomwe zasankhidwa.

1. Ma algorithm ogwirira ntchito iyi ndi osiyana pang'ono ndi awiri apitawa. Choyamba, muyenera kusankha pepala, kumtunda ndi kumanzere kwake komwe kudzakonzedwa. Pambuyo pake, pitani ku tabu "Onani" ndikudina chizindikiro chodziwika bwino "Malo okhala". Pazosankha zomwe zimatsegulira, sankhani chinthucho ndi dzina lomwelo.



2. Pambuyo pa izi, dera lonse lomwe lili kumanzere ndi pamwamba pazosankhidwa lidzakhazikitsidwa papepala.

Ngati mukufuna kuchotsa ziwunda zopangidwa motere, ndizosavuta. Ma algorithm ophedwa ndiwofanana muzochitika zonse zomwe wogwiritsa ntchito sangathe kutsina: mzere, mzere kapena dera. Pitani ku tabu "Onani"dinani pachizindikiro "Malo okhala" ndipo mndandanda womwe umatsegula, sankhani kusankha "Malo osafunikira". Pambuyo pake, magulu onse okhazikika a pepalalo sangakwaniritsidwe.

Phunziro: Momwe mungasungire malo m'Excel

Njira 3: Sinthani chitetezo

Pomaliza, mutha kuteteza khungu kuti lisasinthidwe ndikuletsa kuthekera kosintha kwa ogwiritsa ntchito momwemo. Chifukwa chake, deta yonse yomwe ili mmenemu idzakhala oundana.

Ngati tebulo lanu silili lamphamvu komanso silimaphatikizapo kusintha kulikonse kwa nthawi, mutha kuteteza osati maselo ena okha, koma pepala lonse lonse. Komanso ndizosavuta.

1. Pitani ku tabu Fayilo.



2. Pazenera lomwe limatsegulira, kumanzere ofikira kumanzere, pitani ku gawo "Zambiri". Pakati pazenera, dinani mawu olembedwa Tetezani Buku. Pa mndandanda wazinthu kuti muwonetsetse chitetezo cha buku lomwe limatsegulira, sankhani njira Tetezani Mapepala Apa.



3. Windo laling'ono lotchedwa Kuteteza Mapepala. Choyamba, mmalo mwake mumadera apadera muyenera kuyika mawu achinsinsi omwe wosuta adzafunika ngati akufuna kulepheretsa chitetezo mtsogolo kuti athe kusintha chikalatacho. Kuphatikiza apo, ngati mungafune, mutha kukhazikitsa kapena kuchotsa zolemba zina zowonjezera mwakuwona kapena kutsitsa mabokosi pafupi ndi zinthu zomwe zikugwirizana ndi mndandanda womwe waperekedwa pazenera ili. Koma nthawi zambiri, makonda osasintha sagwirizana ndi ntchitoyi, kotero mutha kungodina batani mutatha kulowa mawu achinsinsi "Zabwino".



4. Pambuyo pake, kukhazikika kwawindo lina, komwe mumayenera kubwereza mawu achinsinsi omwe adalowetsedwa kale. Izi zimachitika kuti wogwiritsa ntchito awonetsetse kuti adalemba mawu achinsinsi omwe amakumbukira ndikulemba mu kiyibodi yoyenera ndikujambulitsa, apo ayi iye akhoza kulephera kusintha chikalatacho. Mukayambiranso password, dinani batani "Zabwino".



5. Tsopano, mukayesa kusintha gawo lililonse la pepalalo, izi zidzatsekedwa. Tsamba lazidziwitso lidzatseguka ndikukudziwitsani kuti simungathe kusintha deta patsamba lotetezedwa.

Palinso njira ina yolepheretsa kusintha kwasintha pazinthu papepala.

1. Pitani pazenera "Ndemanga" ndikudina chizindikiro Tetezani Mapepala, yomwe imayikidwa pa tepi mu chipangizo chothandizira "Sinthani".



2. Zenera lodziwika bwino loteteza pepalali likutseguka. Timachitanso zina zonse chimodzimodzi monga tafotokozera kale.

Koma muyenera kuchita chiyani ngati mukufuna kumasula khungu limodzi lokha kapena angapo, pomwe ena akuyenera, ngati kale, kuti alowetse deta yanu momasuka? Pali njira yochotsera izi, koma yankho lake ndizovuta kwambiri kuposa ntchito yapita.

M'maselo onse akunyumba, mwachisawawa, malowa amayikidwa kuti azitha kuteteza mukamayambitsa chitseko chonse ndi zonse zomwe tasankha pamwambapa. Tifunikira kuchotsa gawo lachitetezo pazinthu zonse za pepalali, ndikukhazikitsanso pokhapokha pazinthu zomwe tikufuna kuzimitsa pakusintha.

1. Dinani pa rectangle yomwe ili pampata wolumikizana komanso wopindika wolumikizana. Mukhozanso, ngati cholozera chili m'dera lililonse la pepala kunja kwa tebulo, akanikizire njira yachidule Ctrl + A. Zotsatira zake zidzakhala zofanana - zinthu zonse zomwe zalembedwa.



2. Kenako timadina pamtundu wakusankha ndi batani loyenera la mbewa. Pazosankha zomwe zakhazikitsidwa, sankhani "Mtundu wamtundu ...". Muthanso kugwiritsa ntchito njira yachidule yotsalira. Ctrl + 1.



3. Zenera limayatsidwa Mtundu Wa Cell. Nthawi yomweyo pitani ku tabu "Chitetezo". Apa muyenera kumasulira bokosi pafupi ndi gawo "Selo yotetezedwa". Dinani batani "Zabwino".



4. Chotsatira, bweretsani ku pepalalo ndikusankha chinthu kapena gulu lomwe tiziwumitsa. Dinani kumanja pa chidutswa chomwe mwasankha ndipo menyu yankhaniyo pitani ku dzinalo "Mtundu wamtundu ...".



5. Pambuyo potsegula mawonekedwe akusintha, pitani ku tabu "Chitetezo" ndipo onani bokosi pafupi "Selo yotetezedwa". Tsopano mutha dinani batani "Zabwino".



6. Pambuyo pake, tinakhazikitsa chithunzicho ndi chilichonse mwanjira ziwiri zomwe zafotokozedwapo kale.

Pambuyo pochita njira zonse zomwe zafotokozedwa mwatsatanetsatane, maselo okhawo omwe timakhazikitsanso chitetezo pogwiritsa ntchito mawonekedwe omwe adzatsekeredwe kusintha. Pazinthu zina zonse za pepalali, monga kale, zidzakhala zotheka kulowa chilichonse.

Phunziro: Momwe mungatetezere khungu kuti lisasinthe ku Excel

Monga mukuwonera, pali njira zitatu zoimitsira maselo nthawi imodzi. Koma ndikofunikira kudziwa kuti mu chilichonse mwazomwezo osati ukadaulo wokha wopangira njirayi ndi wosiyana, komanso lingaliro la kuziziritsa lokha. Chifukwa chake, munthawi imodzi, adilesi yokha ya cholembedwacho idalembedwa, lachiwiri - dera lomwe lili pazenera limakonzedwa, ndipo chachitatu - chitetezo chimayikidwa kuti zisinthe mu maselo. Chifukwa chake, ndikofunikira kuti mumvetsetse musanachite njirayi kuti mudziwe chiyani komanso chifukwa chiyani mukuchita.