Kubisa mafomula mu Excel

Mukamagwira ntchito ndi maspredishiti a Excel, zowonadi, ogwiritsa ntchito ambiri mwina adazindikira kuti ngati selo lili ndi chilinganizo, ndiye mu bar yapadera ya formula (kumanja kwa batani. "Fx") tiwona.

Nthawi zambiri pamafunika kubisa mafomu papepala. Izi zikhoza kukhala chifukwa chakuti wogwiritsa ntchito, mwachitsanzo, sakufuna kuziwonetsa kwa anthu osaloledwa. Tiyeni tiwone momwe izi zingachitire mu Excel.

Njira 1. Yatsani chitetezo cha pepala

Zotsatira za kukhazikitsidwa kwa njirayi ndikubisa zomwe zili m'maselo mu bar ya formula ndikuletsa kusintha kwawo, komwe kumagwirizana kwathunthu ndi ntchitoyi.

1. Choyamba tiyenera kusankha maselo amene nkhani zake tikufuna kubisa. Kenako dinani kumanja pamndandanda womwe wasankhidwa ndi menyu yankhani yomwe imatsegulidwa, imayima pamzere "Cell Format". Komanso, m'malo mogwiritsa ntchito menyu, mutha kukanikiza kuphatikiza makiyi Ctrl + 1 (malo omwe amafunikira ma cell atasankhidwa).
2. Sinthani ku tabu "Chitetezo" pawindo la mtundu lomwe limatsegulidwa. Apa, chongani bokosi pafupi ndi njira "Bisani Mafomula". Ngati cholinga chathu sikuteteza maselo kuti asasinthe, bokosi loyang'ana lomwe lingathe kuchotsedwa. Komabe, nthawi zambiri, ntchitoyi ndi yofunika kwambiri kuposa kubisa mafomu, kotero ifenso tidzasiya. Dinani mukakonzeka OK.
3. Tsopano chachikulu pulogalamu zenera, kusintha kwa tabu Ndemanga, komwe kuli gulu la zida "Chitetezo" sankhani ntchito "Tetezani Mapepala".
4. Pazenera lomwe likuwoneka, siyani zoikamo, lowetsani mawu achinsinsi (zidzafunika pambuyo pake kuchotsa chitetezo cha pepala) ndikudina OK.
5. Pazenera lotsimikizira lomwe likuwoneka lotsatira, lowetsani mawu achinsinsi omwe adakhazikitsidwa kale ndikudina OK.
6. Zotsatira zake, tinakwanitsa kubisa mafomuwo. Tsopano, mukasankha ma cell otetezedwa, formula bar idzakhala yopanda kanthu.

Zindikirani: Pambuyo poyambitsa chitetezo cha pepala, mukamayesa kusintha ma cell otetezedwa, pulogalamuyi idzapereka uthenga woyenerera.

Nthawi yomweyo, ngati tikufuna kusiya kuthekera kosintha ma cell ena (ndi kusankha - kwa njira 2, yomwe tikambirana pansipa), kuwayika ndikupita kuwindo losamalitsa, osayang'ana. "Ma cell otetezedwa".

Mwachitsanzo, kwa ife, tikhoza kubisa chilinganizo, koma nthawi yomweyo kusiya mphamvu kusintha kuchuluka kwa chinthu chilichonse ndi mtengo wake. Tikayika chitetezo pamapepala, zomwe zili m'maselowa zitha kusinthidwa.

Njira 2. Letsani kusankha kwa ma cell

Njira imeneyi siigwiritsiridwa ntchito kwambiri poyerekezera ndi imene tafotokozayi. Pamodzi ndi kubisa zambiri mu bar ya formula ndikuletsa kusintha kwa maselo otetezedwa, zimatanthauzanso kuletsa kusankha kwawo.

1. Timasankha mitundu yofunikira yama cell mogwirizana ndi zomwe tikufuna kuchita zomwe takonzekera.
2. Timapita ku zenera la masanjidwe ndi tabu "Chitetezo" fufuzani ngati njirayo yafufuzidwa "Ma cell otetezedwa" (iyenera kuthandizidwa ndi kusakhazikika). Ngati sichoncho, ikani ndikudina OK.
3. Tabu Ndemanga dinani batani "Tetezani Mapepala".
4. Zenera lodziwika bwino lidzatsegulidwa posankha njira zachitetezo ndikulowetsa mawu achinsinsi. Chotsani cholembera m'bokosi pafupi ndi njirayo "unikani maselo otsekedwa", khazikitsani mawu achinsinsi ndikudina OK.
5. Tsimikizirani mawu achinsinsi polembanso, kenako dinani OK.
6. Chifukwa cha zomwe zachitika, sitingathenso kuwona zomwe zili m'maselo mu bar ya formula, komanso kusankha.

Kutsiliza

Chifukwa chake, pali njira ziwiri zobisa mafomu mu Excel spreadsheet. Yoyamba imakhudza kuteteza ma cell ndi ma formula kuti asasinthidwe ndikubisa zomwe zili mu formula bar. Yachiwiri ndi yokhwima kwambiri, kuwonjezera pa zotsatira zomwe zapezedwa pogwiritsa ntchito njira yoyamba, zimaletsa, makamaka, pa kusankha kwa maselo otetezedwa.