Momwe mungayikitsire chizindikiro chowonjezera mu cell ya tebulo la Excel popanda formula

Wogwiritsa ntchito aliyense wa Excel yemwe anayesa kulemba chizindikiro chowonjezera mu cell wakumana ndi vuto lomwe sanathe kutero. Excel idaganiza kuti iyi ndi njira yomwe ikulowetsedwa, chifukwa chake, kuphatikiza sikunawonekere, koma cholakwika chidapangidwa. Ndipotu kuthetsa vutoli n’kosavuta kuposa mmene anthu amaganizira. Ndikokwanira kupeza chip chimodzi chomwe chidzawululidwe kwa inu pompano.

Chifukwa chomwe mungafunikire chizindikiro "+" mu selo nambala isanakwane

Pali zochitika zingapo zomwe chizindikiritso chowonjezera mu selo chingafunikire. Mwachitsanzo, ngati muofesi akuluakulu amasunga kaundula wa ntchito mu Excel, ndiye kuti nthawi zambiri ndikofunikira kuyika chowonjezera mu gawo la "Done" ngati ntchitoyo yatha. Ndiyeno wogwira ntchitoyo ayenera kukumana ndi vutoli. 

Kapena muyenera kupanga tebulo lokhala ndi zonena zanyengo (kapena mbiri yakale ya mwezi watha, ngati mukufuna). Pankhaniyi, muyenera kulemba madigiri angati ndi chizindikiro (kuphatikiza kapena kuchotsera). Ndipo ngati kuli kofunikira kunena kuti kunja kukutentha, ndiye kuti kulemba +35 mu cell kumakhala kovuta. Momwemonso ndi chizindikiro chochotsera. Koma izi zimangokhala ngati popanda zidule.

Malangizo a pang'onopang'ono - momwe mungayikitsire chowonjezera mu Excel

M'malo mwake, pali njira zambiri zoyika kuphatikiza mu cell iliyonse ya spreadsheet:

1. Sinthani mawonekedwe kukhala mawu. Pamenepa, sipangakhale kuyankhula kwa fomula iliyonse mpaka mawonekedwewo asinthidwa kukhala manambala. 
2. Kapenanso, mutha kungolemba chizindikiro + ndikudina batani la Enter. Pambuyo pake, chizindikiro chowonjezera chidzawonekera mu selo, koma chizindikiro cholowetsa sichidzawonekera. Zowona, muyenera kusamala ndikukankhira chinsinsi cholowetsa. Chowonadi ndi chakuti ngati mugwiritsa ntchito njira ina yotchuka yotsimikizira kulowa kwa data mu chilinganizo, ndikudina pa cell ina, ndiye kuti idzalowetsedwa mu fomula. Ndiko kuti, mtengo umene uli mmenemo udzawonjezedwa, ndipo udzakhala wosasangalatsa.
3. Palinso njira ina yokongola yoyika chizindikiro chowonjezera mu selo. Ingoyikani mawu amodzi patsogolo pake. Chifukwa chake, Excel imamvetsetsa kuti iyenera kutengera fomula iyi ngati mawu. Mwachitsanzo, monga izi '+30 madigiri Celsius.
4. Mutha kunyenganso Excel powonetsetsa kuti kuphatikiza simunthu woyamba. Chilembo choyamba chikhoza kukhala chilembo chilichonse, malo, kapena chikhalidwe chomwe sichinasungidwe kuti chilembedwe. 

Kodi ndingasinthe bwanji mawonekedwe a selo? Pali njira zingapo. Kawirikawiri, ndondomeko ya zochita idzakhala motere:

1. Choyamba, ndikudina mbewa yakumanzere pa cell yomwe mukufuna, muyenera kusankha yomwe mukufuna kuwonjezera. Mukhozanso kusankha mitundu yosiyanasiyana, komanso kusintha maonekedwe a maselo onsewa kukhala malemba. Chosangalatsa ndichakuti simungalowe chowonjezera choyamba, kenako ndikusintha mawonekedwe, koma nthawi yomweyo konzekerani malo olowera chizindikiro chowonjezera. Ndiko kuti, sankhani maselo, sinthani mawonekedwe, ndiyeno ikani kuphatikiza.
2. Tsegulani tabu "Kunyumba", ndipo pamenepo timayang'ana gulu la "Nambala". Gululi lili ndi batani la "Number Format", lomwe lilinso ndi kavi kakang'ono. Zikutanthauza kuti mukadina batani ili, menyu yotsitsa idzawonekera. Zowonadi, tikadina, menyu idzatsegulidwa momwe tiyenera kusankha mtundu wa "Text".
   

   

Pali zingapo zomwe muyenera kusintha kaye mawonekedwe a cell kukhala mawu. Mwachitsanzo, ngati ziro ayikidwa pachiyambi kapena dash, zomwe zimawonedwa ngati chizindikiro chochotsera. Muzochitika zonsezi, kusintha mawonekedwe kuti alembedwe kungathandize kwambiri. 

Zero pamaso pa nambala mu Excel cell

Tikayesa kuyika nambala yomwe nambala yake yoyamba imayamba ndi zero (monga njira, nambala yamalonda), ndiye kuti zero imachotsedwa ndi pulogalamuyo. Ngati takumana ndi ntchito yosunga, ndiye kuti tingagwiritse ntchito mawonekedwe monga mwambo. Pamenepa, zero kumayambiriro kwa chingwe sichidzachotsedwa, ngakhale mtunduwo uli nambala. Mwachitsanzo, mutha kupereka nambala 098998989898. Mukayiyika mu cell yokhala ndi nambala yamtundu, imasinthidwa kukhala 98998989898.

Kuti mupewe izi, muyenera kupanga mtundu wokhazikika, ndikulowetsa chigoba 00000000000 ngati code. Chiwerengero cha ziro chiyenera kukhala chofanana ndi chiwerengero cha manambala. Pambuyo pake, pulogalamuyo idzawonetsa zilembo zonse za code.

Chabwino, kugwiritsa ntchito njira yachikale yosungira m'mawu ndi imodzi mwazinthu zomwe zingatheke.

Momwe mungayikitsire dash mu cell ya Excel

Kuyika mzere mu cell ya Excel ndikosavuta monga kuyika chizindikiro chowonjezera. Mwachitsanzo, mukhoza kupatsa mtundu wa malemba.

Kuipa kwapadziko lonse kwa njirayi ndikuti ntchito zamasamu sizingachitike pamtengo wotsatira, mwachitsanzo.

Mukhozanso kuyika khalidwe lanu. Kuti muchite izi, muyenera kutsegula tebulo ndi zizindikiro. Kuti muchite izi, tabu ya "Insert" imatsegulidwa, ndipo batani la "Symbols" lili mumenyu. Kenako, menyu yowonekera idzawonekera (timvetsetsa zomwe zikhala ndi muvi womwe uli pa batani), ndipo m'menemo tiyenera kusankha "Zizindikiro".

Gome lachizindikiro limatsegulidwa.

Kenako, tifunika kusankha tabu "Zizindikiro", ndikusankha "Zizindikiro za Frame". Chithunzichi chikuwonetsa komwe dash yathu ili.

Tikayika chizindikiro, chidzalowetsedwa m'munda ndi zizindikiro zomwe zimagwiritsidwa ntchito kale. Choncho, nthawi ina mukhoza kuika mukapeza aliyense selo mofulumira kwambiri.

Timapeza zotsatira izi.

Momwe mungayikitsire chizindikiro "chosafanana" mu Excel

Chizindikiro "chosafanana" ndi chizindikiro chofunikira kwambiri mu Excel. Pali zilembo ziwiri pamodzi, iliyonse ili ndi makhalidwe ake.

Woyamba ndi <>. Itha kugwiritsidwa ntchito m'mapangidwe, kotero ndi yogwira ntchito. Izo sizikuwoneka zokongola choncho. Kuti muyilembe, ingodinani potsegulira ndi kutseka mawu amodzi.

Ngati mukufuna kuyika chizindikiro "chosafanana", muyenera kugwiritsa ntchito tebulo lachizindikiro. Mutha kuzipeza mu gawo la "mathematics operators".

Ndizomwezo. Monga mukuonera, palibe chovuta. Kuti mugwire ntchito zonse, mumangofunika kuwongolera pang'ono. Ndipo nthawi zina simusowa nkomwe.