Momwe mungatetezere ma cell kuti asasinthe mu Excel

Nthawi zina, zimakhala zofunikira kuteteza zidziwitso m'maselo a chikalata cha Excel kuti zisasinthe. Ma cell omwe ali ndi mawonekedwe osankhidwa kapena ma cell omwe ali ndi data pamaziko omwe mawerengedwe amachitikira amatetezedwa. Ngati zomwe zili m'maselo oterowo zasinthidwa, ndiye kuti kuwerengera m'magome kumatha kuphwanyidwa. Komanso, chitetezo cha data m'maselo ndichofunika posamutsa fayilo kwa anthu ena. Tiyeni tiwone njira zodziwika bwino zotetezera maselo kuti asasinthe mu Excel.

Yatsani chitetezo cha ma cell

Ntchito yosiyana yoteteza zomwe zili m'maselo mu ExcelTsoka ilo, opanga ma Excel sanadziwiretu. Komabe, mutha kugwiritsa ntchito njira zomwe zimakupatsani mwayi woteteza tsamba lonse kuti lisasinthe. Pali njira zingapo zogwiritsira ntchito chitetezo choterocho, zomwe tidzazidziwa tsopano.

Njira 1: Kugwiritsa Ntchito Fayilo Menyu

Monga njira yoyamba, lingalirani zothandizira kuteteza pepala la Excel kudzera pa menyu Fayilo.

1. Choyamba, sankhani zomwe zili patsambalo. Kufewetsa ndondomekoyi, kungodinanso makona atatu pa mphambano ya coordinate mipiringidzo mu chapamwamba kumanzere ngodya. Kwa iwo omwe amakonda kugwiritsa ntchito makiyi otentha, pali njira yosavuta yophatikizira "Ctrl + A". Mukasindikiza kuphatikiza kamodzi ndi selo yogwira mkati mwa tebulo, tebulo lokha ndilosankhidwa, ndipo mukasindikizanso, tsamba lonse la ntchito limasankhidwa.
2. Kenako, timayitanira zotulukapo podina batani lakumanja la mbewa, ndikuyambitsa "Format Cells" parameter.

3. Pazenera la "Format cell", sankhani tabu "Chitetezo" ndikuchotsa bokosi lomwe lili pafupi ndi gawo la "Protected cell", dinani batani "Chabwino".

4. Tsopano timasankha gawo lofunikira la ma cell omwe amayenera kutetezedwa ku zosintha zosafunikira, mwachitsanzo, ndime yokhala ndi mafomu. Apanso, sankhani "Maselo a Format" ndi "Chitetezo" tabu, bweretsani cholembera pamzere wa "Maselo Otetezedwa". Tulukani zenera podina Chabwino.
5. Tsopano tiyeni tipitirire kuchitetezo cha pepala. Kuti muchite izi, pitani ku tabu "Fayilo".
6. Mu gawo la "Zambiri", dinani "Tetezani buku lantchito". Menyu ya pop-up idzawonekera pomwe timapita ku gulu la "Tetezani tsamba lapano".

7. Iwindo laling'ono lidzawonekera, pomwe kutsogolo kwa "Tetezani pepala ndi zomwe zili m'maselo otetezedwa", fufuzani bokosi ngati silikupezeka. Pansipa pali mndandanda wazinthu zosiyanasiyana zomwe wogwiritsa ntchito amadzaza pakufuna kwawo.
8. Kuti mutsegule chitetezo, muyenera kuyika mawu achinsinsi omwe adzagwiritsidwe ntchito kuti mutsegule tsamba la Excel.

9. Pambuyo kulowa mawu achinsinsi, zenera adzaoneka mmene muyenera kubwereza achinsinsi ndi kumadula "Chabwino".

Pambuyo pa izi, mutha kutsegula fayilo, koma simungathe kusintha ma cell otetezedwa, pomwe ma data omwe ali m'maselo osatetezedwa angasinthidwe.

Njira 2: Kubwereza Tabu Chida

Njira ina yotetezera deta m'maselo a chikalata cha Excel ndikugwiritsa ntchito zida zomwe zili mu gulu la Review. Kutsatira kwa zochita ndi motere:

1. Choyamba muyenera kubwereza mfundo 5 zoyambirira kuchokera ku njira yapitayi yokhazikitsira chitetezo, ndiye kuti, choyamba timachotsa chitetezo ku deta yonse, ndiyeno timayika chitetezo pamaselo omwe sangathe kusinthidwa.
2. Pambuyo pake, pitani ku tabu ya "Review" ndikupeza njira ya "Tetet Sheet" m'gulu la "Tetezani".

3. Mukadina batani la "Tetezani Mapepala", zenera lolowera mawu achinsinsi lidzawonekera, monga momwe zidalili kale.

Zotsatira zake, timapeza pepala la Excel, lomwe lili ndi maselo angapo omwe amatetezedwa ku kusintha.

Tcherani khutu!  Ngati mumagwira ntchito ku Excel mu mawonekedwe opindika, ndiye mukadina pazida zomwe zimatchedwa "Chitetezo", mndandanda wamalamulo umatsegulidwa, womwe uli ndi malamulo omwe alipo.

Kuchotsa chitetezo

Tsopano tiyeni tiwone momwe tingagwirire ntchito ndi maselo omwe atetezedwa ku kusintha.

1. Ngati muyesa kulowetsa deta yatsopano mu selo lotetezedwa, mudzachenjezedwa kuti selo ndilotetezedwa ndipo muyenera kuchotsa chitetezo.

2. Kuti muchotse chitetezo, pitani ku tabu "Review" ndipo mu "Chitetezo" chotchinga timapeza batani la "Unprotect sheet".
3. Mukadina pa izi, zenera laling'ono limawonekera ndi gawo lolowera mawu achinsinsi.

4. Pazenera ili, lowetsani mawu achinsinsi omwe amagwiritsidwa ntchito kuteteza maselo ndikudina "Chabwino".

Tsopano mutha kuyamba kupanga zosintha zofunika pamaselo aliwonse muzolemba.

Zofunika! Sankhani mawu achinsinsi osavuta kukumbukira koma ovuta kuti ogwiritsa ntchito ena aganizire.

Kutsiliza

Monga tanenera kale, palibe ntchito yapadera mu Excel kuteteza maselo osankhidwa ku kusintha kosafunikira. Komabe, pali njira zingapo zodalirika zomwe zimakulolani kuti muchepetse mwayi wopeza zomwe zili mufayiloyo, kapena kuteteza chikalatacho kuti chisawongoleredwe, chomwe chingawononge ntchito yomwe nthawi ndi khama lakhala likuchita.