Imvamisa, lapho usebenza namatafula eMicrosoft Excel, udinga ukubala inani lekholomu ehlukile nedatha. Isibonelo, ngale ndlela ungakwazi ukubala inani eliphelele lesikhombisi izinsuku eziningana, uma imigqa yetafula ingezinsuku, noma inani eliphelele lezinhlobo zezimpahla ezithile. Ake sibheke izindlela ezahlukahlukene ongangeza ngazo idatha yekholamu kuhlelo lweMicrosoft Excel.
Buka inani eliphelele
Indlela elula yokubuka inani eliphelele ledatha, kufaka phakathi idatha emangqamuzaneni ekholamu, iwukumane ukhethe kubo ngesikhombisi ngokuchofoza inkinobho yegundane kwesobunxele. Ngaso leso sikhathi, inani eliphelele lamaseli akhethiwe liboniswa kubha yesimo.
Kepha, le nombolo ngeke ifakwe etafuleni, noma igcinwe kwenye indawo, futhi inikezwa umsebenzisi ukuthola imininingwane.
I-AutoSum
Uma ufuna ukungagcini ukuthola inani ledatha yekholamu, kodwa futhi ukuyifaka etafuleni iseli elihlukile, khona-ke kusebenza kakhulu ukusebenzisa umsebenzi we-auto-sum.
Ukuze usebenzise inani lemoto, khetha iseli elingaphansi kwekholomu oyifunayo, bese uchofoza inkinobho ethi "AutoSum" etholakala ku-ribbon kuthebhu "Ikhaya".
Esikhundleni sokuchofoza inkinobho kubambo, ungacindezela futhi isinqamuleli sekhibhodi ALT + =.
I-Microsoft Excel ibona ngokuzenzakalelayo amaseli ekholomu agcwele idatha yokubala futhi ikhombisa umphumela ophelile kuseli elicacisiwe.
Ukuze ubone umphumela ophelile, vele ucindezele inkinobho ethi Enter on the keyboard.
Uma nganoma yisiphi isizathu ukholelwa ukuthi i-auto-sum ayizange ibhekele wonke amaseli owadingayo, noma uma udinga ukubala inani elingewona wonke amangqamuzana ekholamu, unganquma manani ububanzi bamanani. Ukuze wenze lokhu, khetha uhla olufunayo lwamaseli kukholamu, bese ubamba iseli lokuqala elingenalutho elingaphansi kwalo. Bese uchofoza yonke inkinobho "AutoSum".
Njengoba ukwazi ukubona, inani liboniswa kuseli elingenalutho, elibekwe ngaphansi kwekholomu.
I-AutoSum yamakholomu amaningi
Isamba samakholomu ambalwa singabalwa ngasikhathi sinye, kanye nekholomu eyodwa. Okusho ukuthi, khetha amaseli ngaphansi kwalezi zikholomu, bese uchofoza inkinobho "AutoSum".
Kepha kufanele wenzeni uma amakholomu amaseli lawo ofuna ukuwabala engatholakali eduze komunye nomunye? Kulokhu, bamba inkinobho ethi Enter, bese ukhetha amaseli angenalutho atholakala ngaphansi kwekholomu oyifunayo. Ngemuva kwalokho, chofoza inkinobho "AutoSum", noma uthayiphe kwinhlanganisela yokhiye ALT + =.
Enye indlela, ungakhetha lonke uhla kulawo maseli lapho udinga ukuthola khona inani, kanye namaseli angenalutho ngaphansi kwawo, bese uchofoza inkinobho ye-auto-sum.
Njengoba ubona, isamba sawo wonke la makholamu abaliwe.
Manual DRM
Futhi, kungenzeka ukwenza amaseli ngesandla kukholomu yetafula. Le ndlela ngokuqinisekile ayifaneleki njengokubala inani lemoto, kepha ngakolunye uhlangothi, ikuvumela ukuthi ubonise idatha eyisamba hhayi kuphela kumaseli akhiwe ngaphansi kwekholomu, kodwa futhi kunoma isiphi esinye iseli esise sheet. Uma ifiswa, inani elibalwe ngale ndlela lingakhonjiswa kwelinye iphepha lencwadi yokusebenza ye-Excel. Ngaphezu kwalokho, ngale ndlela, ungakwazi ukubala isamba samaseli hhayi wonke amakholamu, kepha lawo kuphela ozikhethele wona. Ngaphezu kwalokho, akudingekile ukuthi la maseli ahlangane.
Sichofoza kunoma yiliphi iseli ofuna ukubonisa kulo inani, bese ufaka uphawu "=" kulo. Ngemuva kwalokho, ngokuchofoza ngakunye kulawo maseli wekholomu ofuna ukuyifingqa. Ngemuva kokufaka iseli ngayinye elandelayo, udinga ukucindezela inkinobho "+". Ifomula yokufaka ikhonjiswa esitokisini osithandayo, nakwibha yefomula.
Uma usungenile amakheli awo wonke amaseli, ukubonisa umphumela wesamba, cindezela inkinobho ethi Faka.
Ngakho-ke, sihlole izindlela ezahlukahlukene zokubala inani lemininingwane emakholamu ku-Microsoft Excel. Njengoba ukwazi ukubona, kunezindlela ezimbili ezisebenza kalula, kodwa ezingashintshi, kanye nezinketho ezidinga isikhathi esithe xaxa, kepha ngasikhathi sinye vumela ukukhethwa kwamaseli athile ukuze kubalwe. Iyiphi indlela yokusebenzisa incike kwimisebenzi ethile.
