Kuteteza ma cell ku kusintha kwa Excel

Nthawi zambiri, pazifukwa zosiyanasiyana, ogwiritsa ntchito amakumana ndi ntchito yoteteza zinthu zina za spreadsheet ya Excel kuti zisasinthe. Mwachitsanzo, awa akhoza kukhala maselo okhala ndi ma formula, kapena maselo omwe amawerengera, ndipo zomwe zili mkati mwake sizingasinthidwe. Izi ndi zoona makamaka pamene anthu ena ali ndi mwayi wopeza tebulo. Pansipa tiwona momwe mungathanirane ndi ntchitoyi.

Yatsani chitetezo cha ma cell

Tsoka ilo, Excel sipereka ntchito yosiyana yomwe imatseka ma cell kuti awateteze, komabe, pazifukwa izi, mutha kugwiritsa ntchito chitetezo cha pepala lonse. Izi zikhoza kuchitika m'njira zosiyanasiyana.

Njira 1: Gwiritsani Ntchito Fayilo Menyu

Kuti muteteze chitetezo, chitani zotsatirazi:

1. Choyamba muyenera kusankha zonse zomwe zili papepala. Kuti muchite izi, dinani pa rectangle pa mphambano ya mapanelo ogwirizanitsa. Mukhozanso kukanikiza kuphatikiza makiyi Ctrl + A (kamodzi ngati selo kunja kwa tebulo lodzazidwa lasankhidwa, kawiri ngati selo mkati mwake yasankhidwa).
2. Dinani kumanja kulikonse m'gawo losankhidwa ndikusankha kuchokera pamndandanda wotsitsa "Cell Format".
3. Pazenera la masanjidwe a cell lomwe limatsegulidwa, pa tabu "Chitetezo" chotsani kusankha "Ma cell otetezedwa", kenako panikizani OK.
4. Tsopano, mwanjira iliyonse yabwino (mwachitsanzo, ndikusindikiza batani lakumanzere), sankhani gawo la ma cell omwe tikufuna kuwateteza ku kusintha. Kwa ife, iyi ndi mzati wokhala ndi ma formula. Pambuyo pake, dinani kumanja pamtundu womwe wasankhidwa kuti muyitane menyu yankhani ndikusankhanso chinthucho "Cell Format".
5. Popita ku tabu "Chitetezo" chongani bokosi pafupi njira "Ma cell otetezedwa" ndipo dinani OK.
6. Tsopano muyenera kuyambitsa chitetezo cha pepala. Pambuyo pake, tidzakhala ndi mwayi wosintha maselo onse a pepala, kupatula omwe akuphatikizidwa muzosankhidwa. Kuti muchite izi, tsegulani menyu "Fayilo".
7. Kumanja kwa gawo lokhutira "Intelligence" kanikizani batani “Tetezani Buku”. Mndandanda wa malamulo udzatsegulidwa, pakati pawo muyenera kusankha - "Tetezani pepala lapano".
8. Zosankha zachitetezo cha sheet zikuwonetsedwa pazenera. Njira yotsutsa "Tetezani pepala ndi zomwe zili m'maselo otetezedwa" cholembera chiyenera kufufuzidwa. Zotsalira zomwe zili pansipa zimasankhidwa malinga ndi zofuna za wogwiritsa ntchito (nthawi zambiri, magawo amakhalabe osakhudzidwa). Kuti muteteze pepalalo, muyenera kuyika mawu achinsinsi m'munda womwe wapangidwira izi (zidzafunika mtsogolo kuti mutsegule), kenako mutha kudina. CHABWINO.
9. Pazenera lotsatira laling'ono, muyenera kubwereza mawu achinsinsi omwe adalowa kale ndikudina batani kachiwiri OK. Izi zithandiza kuteteza wogwiritsa ntchito ku typos awo akayika mawu achinsinsi.
10. Zonse zakonzeka. Tsopano simungathe kusintha zomwe zili m'maselo omwe tawathandizira kuti atetezedwe muzosankha zamasanjidwe. Zinthu zotsalira za pepala zitha kusinthidwa mwakufuna kwathu.

Njira 2: Gwiritsani ntchito zida za tabu ya Ndemanga

Njira yachiwiri yothandizira chitetezo cha ma cell imaphatikizapo kugwiritsa ntchito zida za tabu Ndemanga. Umu ndi momwe zimachitikira:

1. Timatsatira masitepe 1-5 ofotokozedwa mu njira 1, mwachitsanzo, chotsani chitetezo pa pepala lonse ndikuchibwezeretsanso pamaselo osankhidwa okha.
2. Mu gulu la zida "Chitetezo" totsegulira Ndemanga kanikizani batani "Tetezani Mapepala".
3. Zenera lodziwika bwino lomwe lili ndi zosankha zoteteza masamba lidzawonekera. Kenaka timatsatira njira zomwezo monga momwe tafotokozera pamwambapa.

Zindikirani: Pamene pulogalamu zenera wothinikizidwa (horizontally), bokosi la zida "Chitetezo" ndi batani, kukanikiza komwe kudzatsegula mndandanda wa malamulo omwe alipo.

Chotsani chitetezo

Ngati tiyesa kusintha ma cell aliwonse otetezedwa, pulogalamuyi idzapereka uthenga woyenerera.

Kuti mutsegule loko, muyenera kulowa mawu achinsinsi:

1. Tabu Ndemanga mu gulu la zida "Chitetezo" kanikizani batani "Pepala lopanda chitetezo".
2. Zenera laling'ono lidzatsegulidwa ndi gawo limodzi lomwe muyenera kulowamo mawu achinsinsi omwe atchulidwa poletsa ma cell. Kukanikiza batani OK tidzachotsa chitetezo.

Kutsiliza

Ngakhale kuti Excel ilibe ntchito yapadera yoteteza maselo ena kuti asasinthidwe, mungathe kuchita izi mwa kuyatsa chitetezo cha pepala lonse, mutakhazikitsa magawo ofunikira a maselo osankhidwa.