Uyihlunga kanjani idatha ku-Excel ngombala

Ku-Microsoft Office Excel, kusukela kunguqulo 2007, kube nokwenzeka ukuhlunga nokuhlunga amaseli ohlu lwetafula ngombala. Lesi sici sikuvumela ukuthi uzulazule ngokushesha etafuleni, sandise ukubonakala kwalo kanye nobuhle. Lesi sihloko sizohlanganisa izindlela eziyinhloko zokuhlunga ulwazi ku-Excel ngombala.

Izici zokuhlunga ngombala

Ngaphambi kokuqhubeka nokucabangela izindlela zokuhlunga idatha ngombala, kuyadingeka ukuhlaziya izinzuzo ezihlinzekwa yile nqubo:

• Ulwazi lokuhlela nokuhleleka, olukuvumela ukuthi ukhethe ucezu olufunayo lwepuleti futhi uluthole ngokushesha kuhlu olukhulu lwamaseli.
• Amaseli agqanyisiwe anolwazi olubalulekile angabuye ahlaziywe.
• Ukuhlunga ngombala kugqamisa ulwazi oluhlangabezana nemibandela eshiwo.

Uyihlunga kanjani idatha ngombala usebenzisa inketho eyakhelwe ngaphakathi ye-Excel

I-algorithm yokuhlunga imininingwane ngombala ohlwini lwethebula le-Excel ihlukaniswe ngezinyathelo ezilandelayo:

1. Khetha ububanzi obudingekayo bamaseli ngenkinobho yegundane engakwesokunxele bese uya kuthebhu ethi “Ekhaya” etholakala kubha yamathuluzi ephezulu yohlelo.
2. Endaweni evela esigatshaneni sokuhlela, udinga ukuthola inkinobho "Hlunga futhi Hlunga" futhi uyinwebe ngokuchofoza umcibisholo ongezansi.

3. Kumenyu evelayo, chofoza umugqa othi "Hlunga".

4. Lapho isihlungi sengezwa, imicibisholo emincane izovela kumagama ekholomu yethebula. Kulesi sigaba, umsebenzisi udinga ukuchofoza i-LMB kunoma imiphi imicibisholo.

5. Ngemva kokuchofoza umcibisholo osegama lekholomu, kuzovezwa imenyu efanayo, lapho udinga ukuchofoza okuthi Hlunga ngomugqa wombala. Ithebhu eyengeziwe izovuleka ngemisebenzi emibili etholakalayo: "Hlunga ngombala weseli" kanye "Hlunga ngombala wefonti".

6. Esigabeni esithi “Hlunga ngombala weseli”, khetha umthunzi ofuna ukuhlunga ngawo ithebula lomthombo ngokuchofoza kuwo nge-LMB.
7. Hlola umphumela. Ngemva kokwenza lokhu kukhohlisa okungenhla, amaseli kuphela anombala oshiwo ngaphambilini azohlala etafuleni. Izakhi ezisele zizonyamalala, futhi ipuleti izoncishiswa.

Ungakwazi ukuhlunga ngokwakho idatha ohlwini lwe-Excel ngokukhipha imigqa namakholomu anemibala engadingeki. Nokho, umsebenzisi kuzodingeka achithe isikhathi esengeziwe ukuze aqedele le nqubo.

Uma ukhetha umthunzi oyifunayo esigabeni esithi "Hlunga ngombala wefonti", khona-ke imigqa kuphela lapho umbhalo wefonti ubhalwe khona ngombala okhethiwe ezohlala etafuleni.

Nakani! Ku-Microsoft Office Excel, ukuhlunga ngomsebenzi wombala kune-drawback ephawulekayo. Umsebenzisi angakhetha umthunzi owodwa kuphela, okuzohlungwa ngawo uhlu lwetafula. Akwenzeki ukucacisa imibala eminingi ngesikhathi esisodwa.

Ungahlunga kanjani idatha ngemibala eminingi ku-Excel

Ngokuvamile azikho izinkinga ngokuhlunga ngombala ku-Excel. Kwenziwa ngendlela efanayo:

1. Ngokufanisa nesigaba sangaphambilini, engeza isihlungi ohlwini lwethebula.
2. Chofoza umcibisholo ovela egameni lekholomu, bese ukhetha okuthi “Hlunga ngombala” kumenyu yokudonsela phansi.

3. Cacisa uhlobo lokuhlunga oludingekayo, isibonelo, khetha umthunzi owufunayo kukholomu "Hlunga ngombala weseli".
4. Ngemva kokwenza ukukhohlisa kwangaphambilini, imigqa yetafula enomthunzi okhethwe ngaphambilini izotholakala endaweni yokuqala ohlwini ngokulandelana. Ungakwazi futhi ukuhlunga eminye imibala.

Ulwazi Olwengeziwe! Ungakwazi futhi ukuhlela idatha kuthebula usebenzisa umsebenzi "wokuhlunga ngokwezifiso", wengeze amaleveli amaningana ngombala.

Uhlunga kanjani ulwazi kuthebula ngombala usebenzisa umsebenzi ongokwezifiso

Ukuze i-Microsoft Office Excel ikhethe isihlungi ukuze sibonise imibala eminingi etafuleni ngesikhathi esisodwa, udinga ukwakha ukulungiselelwa okwengeziwe nge-tint yokugcwalisa. Ngokusho komthunzi owenziwe, idatha izohlungwa ngokuzayo. Umsebenzi wangokwezifiso ku-Excel wenziwa ngokulandela imiyalo elandelayo:

1. Iya engxenyeni ethi “Unjiniyela”, etholakala phezulu kumenyu enkulu yohlelo.
2. Endaweni yethebhu evulekayo, chofoza inkinobho ethi "Visual Basic".
3. Umhleli owakhelwe ohlelweni uzovuleka, lapho uzodinga ukudala imodyuli entsha bese ubhala ikhodi.

Ukuze usebenzise umsebenzi owenziwe, kufanele:

1. Buyela ekhasini lokusebenzela le-Excel bese udala amakholomu amasha amabili eduze kwetafula lokuqala. Angabizwa ngokuthi “Umbala Weseli” kanye “nombala Wombhalo” ngokulandelana.

2. Bhala ifomula kukholamu yokuqala “= Faka umbala()». Impikiswano ifakwe kubakaki. Udinga ukuchofoza iseli enanoma yimuphi umbala epuletini.

3. Kukholomu yesibili, bonisa impikiswano efanayo, kodwa kuphela ngomsebenzi “=UmbalaIfonti()».

4. Nweba amanani awumphumela kuze kube sekupheleni kwethebula, unwebe ifomula kubo bonke ububanzi. Idatha etholiwe inesibopho sombala weseli ngayinye kuthebula.

5. Engeza isihlungi ohlwini lwethebula ngokuya ngohlelo olungenhla. Idatha izohlungwa ngombala.

Kubalulekile! Ukuhlunga ku-Excel kusetshenziswa umsebenzi ochazwe ngumsebenzisi kwenziwa ngendlela efanayo.

Isiphetho

Ngakho, ku-MS Excel, ungakwazi ukuhlunga ngokushesha uhlu lwangempela lwethebula ngombala wamaseli usebenzisa izindlela ezahlukahlukene. Izindlela eziyinhloko zokuhlunga nokuhlunga, okunconywa ukuthi zisetshenziswe lapho kwenziwa umsebenzi, kuxoxwe ngazo ngenhla.