Ake sixoxe ngendlela kubala imigqa Excel

In izicelo-Microsoft Office, kukhona itafula umhleli okhethekileyo, obizwa ngokuthi i-Excel. Ithuluzi eliwusizo kakhulu. Phakathi kwezinye izinto, kukhona umsebenzi okhethekile - izinombolo umugqa Excel. Sibambe leli thuba ikumodi othomathikhi, ungabona izinombolo ukuthi izofakwa nje kwesokunxele etafuleni uqobo. Nokho, lezi zinombolo enzelwe kuphela kubonise umsuka sezitokisi, bese kuthi-ke, uma uqala ukuphrinta itafula, uzokwazi uqaphele ukuthi lezi zinto uyomane angaveli.

Ngaphezu kwalokho, kukhona into eyodwa ngaphezulu: uma umsebenzisi kudala ithebula elisha, bese kunikezwa ukuqala angeke ibekwe kukholamu yekucala kakhulu, okuyisona izinombolo othomathikhi. Ukuze kuqedwe nenkinga enjalo, abantu abaningi vele ungeze ikholomu omusha oyedwa noma kumugqa ezinombolweni. Ngakolunye uhlangothi, irowu inombolo Excel ngendlela efanayo kungenzeka, kodwa nje ukuthi singakanani isikhathi kuyadingeka ukuze ukhokhe isinyathelo wokulungiselela. Eqinisweni ukusetshenziswa ngesandla ayidingekile. Ngaphandle, yebo, uzokwazi kanjani kubala imigqa Excel usebenzisa nemisebenzi kulolu hlelo. Lokho namuhla sakhuluma ngakho sabe sesinquma ukuthi sisho.

Ngokuzimela noma ngokuzenzakalelayo

izinombolo Line Excel kungathatha indawo ngezindlela eziningana, noma kunalokho, lezi zenzo yezimanga ngesandla - kuwumsebenzi isimiso, noma ngokuzenzakalelayo, lapho lolu hlelo kuyoba ukushayela inombolo okwalandela ethebuleni. Uma usuvele usethe khona ukubala, futhi ufuna ukufaka inombolo, bese kakhulu isakhiwo ezidingekayo ukudala ikholomu entsha. Lokhu kunjalo uma izinkambu ezidingekayo awekho. Ukwengeza ikhalamu entsha, kufanele uqale ukhethe ikholomu ngaphambili lapho uhlela ukufaka nezinombolo ukwenza lokhu, chofoza title yayo.

Konke kwenziwa kuwe

Uma ungazi indlela enumerate imigqa Excel kwimodi okuzenzakalelayo, bese uqhubeke ngokuvumelana bhukwana imfundo, esiphila kuso manje ukuchaza. Uma uchofoze isihloko, udinga chofoza indawo ekhethiwe, chofoza kwesokudla bese ukhetha okuya phansi imenyu umyalo "Namathisela" ukuze izinguqulo ezindala, lokhu kungase kube "Engeza". Uma udinga ukubeka inombolo esimweni enezingqimba, kuyilapho umugqa Ukukhetha kufanele kwenziwe nge imenyu yengqikithi, kusukela lapho ungakwazi ukwengeza umugqa entsha engenalutho.

izenzo

Esikhathini sokuqala ezitokisini ezimbili, kufanele ufake kuqala kanti inombolo yesibili, yenziwa ikholomu phambilini enikezwa izinombolo. Futhi ukuze leli cala string ofanele futhi ukulungele. Ngemuva kokufaka udinga qiniseka ukugqamisa amaseli ezimbili. Ukuze kuxazululwe le nkinga kanjani kubala imigqa ku-Excel, uzodinga ukwenza lezi manipulations. Manje kumele uze pointer igundane ukuze ekhoneni elingezansi ngakwesokudla bese ukhetha yonke indawo (zilapho kuyoba ezimbili kuphela), ngemva kwalesi senzo bazodinga ukushintsha kusuka impumuzo evamile plus efulethini elimnyama. Lapho ushintsho olunjalo kwenzeka, udinga uchofoze inkinobho yesinxele bese uhudulela umngcele Ukukhetha yeseli lokugcina izinombolo zakho - noma kunalokho, phansi etafuleni.

ekupheleni

Uma ukukhulula inkinobho yegundane, uhlelo kufanele ugcwalise ngokuzenzakalelayo iseli izinombolo. Isixazululo ngaphezulu umbuzo kanjani kubala imigqa Excel, Kuyinto elula kakhulu, isibonelo, uma kufanele luphathwe itafula elincane. Nokho, indlela efanayo ingasetshenziswa ukwenza imiklamo emikhulu. Siyabonga ngokunaka kwakho.