Momwe mungachulukitsire khungu pachipindacho

Njira 1: Kuchulukitsa khungu

Kuchulukitsa maselo apamwamba, palibe chinthu chapadera, monga opanga opangidwa ndi DAMS. Kukhazikitsa kumeneku sikufunikira kwambiri, chifukwa pakuchulukitsa kuchuluka kwa manambala, wogwiritsa ntchitoyo angalandire zotsatira zomwe zidzayenera kuti ziukitsidwe mpaka maziko ndi maziko a E. Komabe, kuchulukitsa maselo angapo panja palibe vuto.

Mu khungu loyenerera, lembani chizindikiro "=", chomwe chimatanthawuza chiyambi cha plamula.

Kuyamba kwa kupanga njira yochulukitsa kwa khungu pachipinda mu pulogalamu ya Excel

Unikani selo yoyamba kuti dzina lake liwonetsedwa pambuyo pa chizindikiro.

Kusankha foni yoyamba kuti muchulukitse kwina mukapanga pulogalamu yopambana

Ikani chizindikirocho "*" akuwonetsa kuchulukitsa.

Kulemba chikwangwani chochulukitsa mukamapanga pulogalamu yopambana

Momwemonso, sonyezani khungu lachiwiri ndikutsimikizira kupangidwa kwa formula pokanikiza kiyi.

Sankhani selo yachiwiri kuti muchuluke koyamba pa pulogalamu yapamwamba

Tsopano m'khosi uwu zotsatirazi ziwonetsedwa, ndipo njira yokhayo imasonyezedwa mu chingwe pamwambapa.

Zotsatira zakupanga mawonekedwe ochulukitsa maselo anu

Mutha kuwonjezera maselo ochulukirapo kuti azichulukitsa kapena kuphatikiza ma pa masamu osiyanasiyana, koma lingalirani kuti pulogalamuyi ili ndi malire posonyeza manambala akulu.

Zotsatira zakupanga njira yochulukitsa khungu m'maselo angapo mu pulogalamu yopambana

Pamapeto a nkhaniyo, ikufotokozedwa za zovuta zomwe zimakhudzana ndi kuchulukitsa kwa maselo, chifukwa chake ngati china chake chalephera, pezani gawo ili ndikuyang'ana njira yoyenera yankho.

Njira 2: Kuchulukitsa kwa cell ndi nambala

Ngati mutha kuchulukitsa khungu limodzi, zikutanthauza kuti palibe chomwe chimapweteka ngati khungu lachiwiri kuti mulowe m'malo ofunikira. Kenako njirayo ikhale ina, koma kwenikweni.

Lowetsani zomwe zili mu chingwe komanso zomwe zikuwonetsedwa mwanjira yapita, koma osadzaza deta yachiwiri.

Yambani kupanga njira yochulukitsa kwa selo ndi nambala ya pulogalamu ya Excel

M'malo mwake, onjezani chikwangwani chofufumitsa ndikulemba nambala yantchito yamatamu.

Kulowa kwa nambala kuti muwonjezerene ndi selo mu pulogalamu ya Excel

Kusintha kwathunthu podina kulowa, ndikuwona zomwe zinachitika kumapeto.

Zotsatira zakuchulukitsa maselo ndi pulogalamu yopambana

Phatikizaninso kuchulukitsa maselo kumilankhu ndi manambala kapena kuwonjezera zochitika zina za masamu, osati kuyiwala kutsatira momwe akuphedwera. Ngati mukufuna kuyika china chofunikira kwambiri, gwiritsani ntchito mabatani kuti mupange zochita. Kujambula njira zofanizira chimodzimodzi ndendende ndi malamulo oyenera a masamu.

Njira 3: Kuchulukitsidwa ndi Nthawi Zonse

Nthawi zonse amatchedwa nambala yokhazikika, ndipo malinga ndi maselo mu tebulo lamagetsi, limagwira ntchito ngati mtengo wokhazikika. Kuti muchite izi, gwiritsani ntchito chikwangwani cha "$" chomwe chimawonetsa chilengedwe chokhazikika. Tsopano, mukasuntha tebulo kapena kutupa, khungu silidzasuntha. Ngati zonse zikuwonekeratu kuti chilengedwe cha ma forzilations, kenako werengani za kufikiridwa kwa foni m'nkhani yotsatirayi.

Werengani zambiri: kuwonjezera $ siginecha mu Microsoft Excel

Kuchulukitsa kwa maselo nthawi zonse mu pulogalamu ya Excel

Kuthetsa mavuto omwe ali ndi kuchuluka kwa cell

Pafupifupi mavuto onse omwe akubwera pomwe akuyesera kuchulukitsa zomwe zachitika kapena kupanga mtundu wina uliwonse womwe umalumikizidwa ndi mtundu wolakwika wolakwika. Kuti mutsimikizireni ndi kukonza izi, mutha kuwerenga nkhani yoganiza yawebusayiti yathu, yomwe imadzipereka kuti ithetse kuchuluka kwa kuchuluka kwake, komanso ndizoyeneranso m'masiku ano.

Werengani zambiri: kuthetsa vuto ndi kuwerengera kuchuluka kwa maselo osankhidwa mu Microsoft Excel

Kukonza mavuto ndi kuchulukitsa kwa maselo mu pulogalamu ya Excel