Kubisa zomwe zili mu cell

Tiyerekeze kuti tili ndi maselo angapo, zomwe zili mkati mwake zomwe tikufuna kubisala kwa mlendo, popanda kubisa mizere kapena mizati ndi deta yokha komanso osayika mawu achinsinsi omwe angaiwale. Mutha, mwachidziwikire, kuwapanga ngati "mawonekedwe oyera pazithunzi zoyera", koma izi sizowoneka bwino, ndipo mtundu wodzaza ma cell sukhala woyera nthawi zonse. Choncho, tidzapita njira ina.

Choyamba, tiyeni tipange masitayilo amtundu wa cell omwe amabisa zomwe zili mkati mwake pogwiritsa ntchito kalembedwe kake. Mu tabu Kunyumba mu mndandanda wa masitayelo pezani masitayilo Normal, dinani pomwepa ndikusankha lamulo Zobwereza:

Pazenera lomwe likuwonekera pambuyo pa izi, lowetsani dzina lililonse la kalembedwe (mwachitsanzo chinsinsi), sankhani mabokosi onse kusiyapo loyamba (kuti kalembedwe zisasinthe magawo ena onse a cell) ndikudina mtundu:

Pa Advanced tabu Number sankhani njira Mitundu yonse (Mwamakonda) ndi kulowa m’munda Type ma semikoloni atatu motsatana opanda mipata:

Tsekani mazenera onse podina OK…Tangopanga makonda omwe azibisa zomwe zili m'maselo omwe asankhidwa ndipo azingowoneka mu bar ya fomula selo lililonse likasankhidwa:

Momwe zimagwirira ntchito

Ndipotu, zonse ndi zosavuta. Mtundu uliwonse wachikhalidwe ukhoza kukhala ndi zidutswa 4 za chigoba zolekanitsidwa ndi ma semicolons, pomwe chidutswa chilichonse chimayikidwa pamutu wakuti:

1. Choyamba ndi ngati chiwerengero mu selo ndi chachikulu kuposa ziro
2. Chachiwiri - ngati zochepa
3. Chachitatu - ngati pali ziro mu selo
4. Chachinayi - ngati pali malemba mu selo

Excel imagwira ma semicolons atatu motsatana ngati masks anayi opanda kanthu pamilandu yonse inayi, mwachitsanzo, kutulutsa zopanda pake pamtengo uliwonse wa cell. 

• Momwe mungapangire mawonekedwe anu (anthu, kg, ma ruble chikwi, etc.)
• Momwe mungayikitsire chitetezo chachinsinsi pama cell a Excel, mapepala ndi mabuku ogwirira ntchito