Ngokuvamile, uma usebenzisa amatafula ku-Microsoft Excel, kubalulekile ukubala inani lekholomu ehlukile nedatha. Isibonelo, ngale ndlela ungabala inani eliphelele lezinkomba izinsuku ezimbalwa, uma imigqa yetafula yimihla, noma izindleko eziphelele zezinhlobo eziningana zezimpahla. Ake sithole izindlela ezehlukene ongafaka ngayo idatha kukholomu ye-Microsoft Excel.
Buka inani eliphelele
Indlela elula yokubuka yonke inani lemininingwane, kufaka phakathi idatha kumaseli ekholomu, nje ukuyikhetha nge-cursor ngokuchofoza inkinobho yegundane lesokunxele. Ngesikhathi esifanayo, inani eliphelele lamaseli akhethiwe azoboniswa kubha yomumo.
Kodwa, le nombolo ngeke ifakwe etafuleni, noma igcinwe kwenye indawo, futhi inikezwe kumsebenzisi nje ngenothi.
Isamba ngokuzenzakalela
Uma ufuna ukuthola kuphela inani lemininingwane kukholomu, kodwa futhi ukulifaka etafuleni esitokisini esithile, khona-ke kulula kakhulu ukusebenzisa umsebenzi we-auto-sum.
Ukuze usebenzise i-avtosumma, ukhethe iseli elingaphansi kwekholomu oyifunayo, bese uchofoza inkinobho ethi "Autosum", efakwe kwibhebhoni kuthebhu ethi "Ikhaya".
Esikhundleni sokucindezela inkinobho ku-ribbon, ungaphinda ucindezele inhlanganisela eyinhloko ekhibhodi ALT + =.
I-Microsoft Excel iyaqaphela ngokuzenzakalelayo amaseli kukholomu egcwele idatha yokubala, futhi ibonisa inani eliqediwe kuseli elicacisiwe.
Ukuze ubuke umphumela ophelile, cindezela inkinobho yokungena kwikhibhodi.
Uma nganoma yisiphi isizathu ucabanga ukuthi isamba semoto asizange sicabange wonke amangqamuzana owudinga, noma wena, ngokuphambene nalokho, kudingeka ubale inani elingekho kuwo wonke amaseli ekholomu, ungakwazi ukukhomba ukuthi ububanzi buni. Ukuze wenze lokhu, khetha uhla olufunayo lwamaseli kukholomu, bese ubamba iseli lokuqala elingenalutho elingaphansi kwalo. Bese, chofoza ku-inkinobho efanayo "Autosum".
Njengoba ungabona, isamba siboniswa kuseli elingenalutho, elitholakala ngaphansi kwekholomu.
I-Autosum yamakholomu amaningi
Isibalo samakholomu amaningana ngesikhathi esifanayo singabalwa, kanye nekholomu eyodwa. Okusho ukuthi, khetha amaseli ngaphansi kwalezi columns, bese uchofoza inkinobho ethi "Autosum".
Kodwa yini okufanele uyenze uma amakholomu afana namaseli adinga ukufingqwa azikho eduze komunye nomunye? Kulesi simo, sicindezela inkinobho yokungena, bese ukhetha amaseli angenalutho atholakala ngaphansi kwamakholomu ayifunayo. Bese uchofoza inkinobho ethi "Autosum", noma uthayiphe inhlanganisela yokhiye ALT + =.
Ngokunye, ungakhetha lonke uhla kulawo maseli okudingeka ukwazi ukuthola inani, kanye namaseli angenalutho ngaphansi kwawo, bese uchofoza inkinobho yemali.
Njengoba ubona, isibalo sazo zonke amakholomu akhethiwe sibalwa.
Ukufingqa kombhalo
Futhi, kukhona amathuba okubhala ngesandla amaseli etafuleni lekholomu. Le ndlela ngokuqinisekile ayiyona elula njengokubala ngesamba semali, kodwa ngakolunye uhlangothi, ikuvumela ukuba ubonise lezi zimali hhayi kuphela kumaseli akhona ngaphansi kwekholomu, kodwa nakwezinye izilili ezitholakala kushidi. Uma ufisa, inani elibalwe ngale ndlela lingaboniswa ngisho nakwesinye ishidi se-Excel ibhuku. Ngaphezu kwalokho, usebenzisa le ndlela ungabala isamba samaseli angekho kuwo wonke ikholomu, kodwa kuphela kulabo ozikhethelayo. Ngesikhathi esifanayo, akudingekile ukuthi lawa maseli aphelelane.
Chofoza kunoma yisiphi iseli ofuna ukubonisa ngayo inani, bese ufaka uphawu "=" kuyo. Khona-ke, chofoza ngokuhlukile kumaseli ekholomu ofuna ukufingqa. Ngemuva kokufaka iseli ngalinye elilandelayo, udinga ukucindezela ukhiye "+". Ifomula yokufakwayo iboniswa esitokisini ozikhethelayo, naku-bar yefomula.
Uma ufaka amakheli azo zonke amaseli, ukuze ubonise imiphumela yesamba, cindezela inkinobho yokungenisa.
Ngakho-ke, sibheke izindlela ezehlukene zokubala inani lemininingwane kumakholomu ku-Microsoft Excel. Njengoba ubona, kunezindlela ezingcono kakhulu, kepha ezingaphansi kokuguquguquka, nezinketho ezidinga isikhathi esiningi, kodwa ngesikhathi esifanayo zikuvumela ukuba ukhethe amaseli athile ekubalweni. Yiphi indlela ongayisebenzisa kuxhomeke kwimisebenzi ethile.
