Yengeza ikholomu entsha ku-Excel

Wonke umuntu oqala ukusebenza ku-Excel, okokuqala, kufanele afunde indlela yokwengeza amakholomu engeziwe kuthebula elihleliwe. Ngaphandle kwalolu lwazi, kuzoba nzima kakhulu noma kungenzeki nhlobo ukuqhubeka nokusebenza ngedatha yethebula nokwengeza ulwazi olusha encwadini.

Yengeza ikholomu entsha

I-Excel inikeza izindlela ezimbalwa zokufaka ikholomu eyengeziwe endaweni yokusebenza. Iningi lalezi zindlela ngeke lidale ubunzima, kodwa oqalayo ovula uhlelo okokuqala kuzodingeka achithe isikhathi esincane ukuze athole yonke into. Ngakho-ke, ake sibheke ukulandelana kwezenzo zendlela ngayinye.

Indlela 1. Ukufaka ikholomu ngebha yokuxhumanisa

Le ndlela ibhekwa njengelula kakhulu yokwengeza kokubili ikholomu entsha nomugqa etafuleni. Nakhu okudingeka ukwenze kulokhu:

1. Kuphaneli yokuxhumanisa evundlile, chofoza igama lekholomu kwesokunxele ohlela ukwengeza entsha. Uma kwenziwe kahle, ikholomu yonke izokhethwa kanye nesihloko sayo.
2. Manje chofoza kwesokudla kunoma iyiphi indawo endaweni ekhethiwe, imenyu yokuqukethwe izovuleka, lapho sikhetha khona umyalo "Faka".
3. Lokhu kuzokwengeza ikholomu entsha engenalutho kwesokunxele kwaleyo esiyikhethile esinyathelweni sokuqala.

Indlela yesi-2: Ukwengeza Ikholomu Ukusebenzisa Imenyu Yokuqukethwe Kweseli

Lapha uzodinga futhi ukusebenzisa imenyu yokuqukethwe, kodwa kulokhu, hhayi ikholomu yonke ekhethiwe, kodwa iseli elilodwa nje.

1. Iya esitokisini (chofoza kuso noma usebenzise imicibisholo kukhibhodi), ngakwesobunxele lapho sihlela ukufaka ikholomu entsha.
2. Chofoza kwesokudla kuleli seli, futhi kumenyu yokuqukethwe evulayo, chofoza umyalo “Faka…”.
3. Iwindi elincane elisizayo lizovuleka, lapho uzodinga ukukhetha ukuthi yini ngempela okudingeka ifakwe etafuleni: amaseli, umugqa noma ikholomu. Ngokomsebenzi wethu, sibeka uphawu phambi kwento "Ikholomu" bese uqinisekisa isenzo ngokucindezela inkinobho OK.
4. Ikholomu engenalutho izovela kwesokunxele seseli ekhethiwe ekuqaleni, futhi singaqala ukuyigcwalisa ngedatha edingekayo.

Indlela yesi-3: Namathisela usebenzisa amathuluzi akuribhoni

Kunenkinobho ekhethekile kuribhoni eyinhloko ye-Excel ekuvumela ukuthi ufake ikholomu eyengeziwe etafuleni.

1. Njengendlela yangaphambilini, khetha iseli oyifunayo. Ikholomu entsha ngemva kokulandela izinyathelo ezingezansi izovela kwesokunxele sayo.
2. Chofoza isithonjana esinesithombe sikanxantathu ohlanekezelwe eduze kwenkinobho "Faka", ngokuba kuthebhu "Ikhaya". Ohlwini lokudonsela phansi, chofoza inketho “Faka amakholomu eshidini”.
3. Konke sekulungile. Ikholomu entsha yengezwa kwesokunxele seseli ekhethiwe, njengoba kudingeka.

Indlela 4. Okhiye abashisayo bokufaka ikholomu entsha

Enye indlela ethandwa kakhulu, ikakhulukazi phakathi kwabasebenzisi abanolwazi, ukucindezela ama-hotkeys. Le ndlela inezinhlelo zokusebenza ezimbili:

1. Chofoza egameni lekholomu kuphaneli yokuxhumanisa. Njengenjwayelo, khumbula ukuthi ikholomu entsha izofakwa kwesokunxele kwaleyo ekhethiwe. Okulandelayo, cindezela isinqamuleli sekhibhodi Ctrl + "+". Ngemva kwalokho, ikholomu entsha yengezwa ngokushesha etafuleni.
2. Sichofoza kunoma iyiphi iseli, singakhohlwa iqiniso lokuthi ikholomu entsha izovela kwesokunxele sayo. Bese ucindezela isinqamuleli sekhibhodi Ctrl + "+".Iwindi elijwayelekile lizovela lapho udinga ukukhetha uhlobo lokufaka (iseli, umugqa noma ikholomu). Njengendlela yesibili, udinga ukukhetha into "ikholomu" bese uqinisekisa isenzo ngokuchofoza inkinobho OK.

Ifaka amakholomu amabili noma ngaphezulu

Umsebenzi wokufaka amakholomu amaningana engeziwe etafuleni udinga ukunakwa okukhethekile. Ngenxa yokusebenza kwe-Excel, asikho isidingo sokwengeza amakholomu ngamunye ngamunye, ngoba kulokhu kunenketho esebenzayo:

1. Okokuqala, sikhetha amaseli amaningi ngokuvundlile (akunandaba, etafuleni ngokwalo noma kuphaneli yokuxhumanisa), njengoba kuhlelwe ukuthi amakholomu amaningi amasha afakwe.
2. Kuye ngokuthi senze kanjani ukukhetha, senza izinyathelo ezisele zokwengeza amakholomu, siqondiswa izindlela 1-4 ezichazwe ngenhla. Isibonelo, esimweni sethu, senze ukukhetha kuphaneli yokuxhumanisa, futhi manje sengeza amakholomu amasha ngemenyu yokuqukethwe ngokukhetha into efanelekile kuyo.
3. Ngenxa yezenzo zethu, sikwazile ukufaka amakholomu amasha amaningana kuthebula kwesokunxele sebanga lokuqala esilikhethile.

Faka ikholomu ekugcineni kwetafula

Konke okuchazwe ngenhla kulungele ukwengeza ikholomu entsha noma amakholomu amaningana ekuqaleni noma phakathi kwetafula elikhulu. Yiqiniso, uma ufuna ukwengeza ikholomu kusukela ekugcineni, ungasebenzisa izindlela ezifanayo uma ufisa. Kodwa-ke kufanele uchithe isikhathi esengeziwe ufometha izakhi ezingeziwe.

Ukufaka ikholomu entsha futhi ugweme ukufometha kwayo okwengeziwe, kuyadingeka ukwenza ithebula "elihlakaniphile" kusuka kuthebula elivamile. Nakhu esikwenzela lokhu:

1. Khetha wonke amaseli ethebula. Indlela yokwenza lokhu - funda isihloko sethu "".
2. Shintshela kuthebhu "Ikhaya" bese ucindezela inkinobho "Fometha njengethebula", etholakala esigabeni "Izitayela".
3. Ohlwini oluvelayo, khetha isitayela sokuklama esifanele "sethebula le-smart" lesikhathi esizayo bese uchofoza kuso.
4. Iwindi elincane lizovela lapho udinga ukulungisa imingcele yendawo ekhethiwe. Uma sikhethe kahle ithebula esinyathelweni sokuqala, akukho okudinga ukuthintwa lapha (uma kunesidingo, singalungisa idatha). Ukuqinisekisa ukuthi kunophawu lokuhlola eduze kwento “Ithebula elinezihloko” cindezela inkinobho OK.
5. Ngenxa yalokho, ithebula lethu langempela liye laguqulwa laba “elihlakaniphile”.
6. Manje, ukuze wengeze ikholomu entsha ekugcineni kwethebula, mane ugcwalise noma iyiphi iseli kwesokudla sendawo yetafula ngedatha edingekayo. Ikholomu egcwalisiwe izoba yingxenye "yethebula elihlakaniphile" ngokuzenzakalelayo futhi ukufometha kulondoloziwe.

Isiphetho

I-Microsoft Excel ikunikeza izindlela eziningi ongengeza ngazo ikholomu entsha noma yikuphi etafuleni (ekuqaleni, maphakathi, noma ekugcineni). Phakathi kwazo, indawo ekhethekile ithathwa ngokudalwa "kwetafula elihlakaniphile", elikuvumela ukuthi ufake amakholomu amasha etafuleni ngaphandle kwesidingo sokufometha okwengeziwe ukuze uwalethe efomini elivamile, elizogcina isikhathi kwezinye. imisebenzi ebaluleke kakhulu.