Susa imigqa efihliwe ku-Excel. Ngamunye kanye kanye kanye

Ku-Microsoft Office Excel, ungakwazi ukususa ngokushesha imigqa efihliwe, engenalutho eyonakalisa ukubukeka kohlu lwetafula. Indlela yokwenza lokhu kuzoxoxwa ngayo kulesi sihloko.

Uyikhipha kanjani imigqa efihliwe ku-Excel

Kunezindlela eziningana zokufeza umsebenzi, ezisetshenziswa kusetshenziswa amathuluzi ohlelo ajwayelekile. Okuvame kakhulu kuzo kuzoxoxwa ngakho ngezansi.

Indlela 1. Uyisusa kanjani imigqa etafuleni ngayinye ngayinye ngokusebenzisa imenyu yokuqukethwe

Ukuze ubhekane nalokhu kusebenza, kunconywa ukusebenzisa i-algorithm elandelayo:

1. Khetha umugqa owufunayo wohlu lwethebula le-LMB.
2. Chofoza noma yikuphi endaweni ekhethiwe ngenkinobho yegundane elingakwesokudla.
3. Kumenyu yokuqukethwe, chofoza igama elithi "Susa ...".

4. Ewindini elivulayo, faka inkinobho yokuguqula eduze kwepharamitha ethi "String" bese uchofoza okuthi "Kulungile".

5. Hlola umphumela. Ulayini okhethiwe kufanele ukhishwe.
6. Yenza okufanayo kuzo zonke izingxenye zepuleti.

Nakani! Indlela ecatshangelwayo ingaphinda isuse amakholomu afihliwe.

Indlela 2. Ukukhipha okukodwa kwemigqa ngokusebenzisa inketho iribhoni yohlelo

I-Excel inamathuluzi ajwayelekile okususa amaseli ohlu lwethebula. Ukuze uwasebenzise ukususa imigqa, kufanele uqhubeke kanje:

1. Khetha noma yiliphi iseli kumugqa ofuna ukulisusa.
2. Iya kuthebhu ethi “Ekhaya” kuphaneli ephezulu ye-Excel.
3. Thola inkinobho ethi "Susa" futhi wandise le nketho ngokuchofoza umcibisholo ongakwesokudla.
4. Khetha inketho ethi "Susa imigqa eshidini".

5. Qiniseka ukuthi ulayini okhethwe ngaphambilini ukhishiwe.

Indlela 3. Indlela yokususa yonke imigqa efihliwe ngesikhathi esisodwa

I-Excel futhi isebenzisa ithuba lokukhishwa kweqembu kwezinto ezikhethiwe zohlu lwetafula. Lesi sici sikuvumela ukuthi ususe imigqa engenalutho ehlakazeke ezingxenyeni ezihlukene zepuleti. Ngokuvamile, inqubo yokukhipha ihlukaniswe ngezigaba ezilandelayo:

1. Ngendlela efanayo, shintshela kuthebhu "Ekhaya".
2. Endaweni evulayo, engxenyeni ethi "Hlela", chofoza inkinobho ethi "Thola bese ukhetha".
3. Ngemva kokwenza isenzo sangaphambilini, imenyu yokuqukethwe izovela lapho umsebenzisi ezodinga ukuchofoza umugqa "Khetha iqembu lamaseli ...".

4. Ewindini elivelayo, kufanele ukhethe izinto ozozigqamisa. Kulesi simo, faka inkinobho yokuguqula eduze kwepharamitha ethi "Amaseli angenalutho" bese uchofoza okuthi "KULUNGILE". Manje yonke imigqa engenalutho kufanele ikhethwe kanyekanye kuthebula lomthombo, kungakhathaliseki ukuthi ikuphi.

5. Chofoza kwesokudla kunoma yimuphi ulayini okhethiwe.
6. Ewindini lohlobo lomongo, chofoza igama elithi "Susa ..." bese ukhetha inketho ethi "String". Ngemva kokuchofoza "KULUNGILE" zonke izinto ezifihliwe ziyakhishwa.

Kubalulekile! Indlela yokukhishwa kweqembu okukhulunywe ngayo ngenhla ingasetshenziswa kuphela emigqeni engenalutho ngokuphelele. Akufanele ziqukathe noma yiluphi ulwazi, ngaphandle kwalokho ukusebenzisa indlela kuzoholela ekwephuleni kwesakhiwo setafula.

Indlela yesi-4: Faka isicelo sokuhlunga

Indlela yangempela, eyenziwa ngokuya nge-algorithm elandelayo:

1. Khetha unhlokweni wethebula. Lena indawo lapho idatha izohlungwa khona.
2. Kuthebhu "Ekhaya", nweba isigatshana esithi "Hlunga futhi Hlunga".
3. Ewindini elivelayo, khetha inketho ethi “Ukuhlunga ngokwezifiso” ngokuchofoza kuyo nge-LMB.

4. Kumenyu yokuhlunga ngokwezifiso, qoka ibhokisi eduze kwenketho ethi "Idatha yami iqukethe izihloko".
5. Kukholomu Ye-oda, cacisa noma yiziphi izinketho zokuhlunga: kungaba “A kuya ku-Z” noma “Z kuya ku-A”.
6. Ngemva kokuqeda izilungiselelo zokuhlunga, chofoza okuthi "KULUNGILE" ezansi kwewindi. Ngemva kwalokho, idatha ohlwini lwethebula izohlungwa ngokuvumelana nombandela oshiwo.

7. Ngokohlelo okuxoxwe ngalo esigabeni esandulele sendatshana, khetha yonke imigqa efihliwe bese uyisusa.

Ukuhlunga amanani kubeka ngokuzenzakalelayo yonke imigqa engenalutho ekugcineni kwetafula.

Ulwazi Olwengeziwe! Ngemva kokuhlunga imininingwane ohlwini, izakhi ezifihliwe zingakhishwa ngokuzikhetha zonke futhi ngokuchofoza into ethi “Susa” kumenyu yokuqukethwe.

Indlela 5. Ukusebenzisa ukuhlunga

Kumaspredishithi e-Excel, kungenzeka ukuhlunga uhlu olunikeziwe, kushiye kuphela ulwazi oludingekayo kulo. Ngale ndlela ungakwazi ukususa noma yimuphi umugqa etafuleni. Kubalulekile ukwenza ngokuvumelana ne-algorithm:

1. Sebenzisa inkinobho yegundane engakwesokunxele ukuze ukhethe isihloko sethebula.
2. Iya engxenyeni ethi “Idatha” etholakala phezulu kumenyu enkulu yohlelo.
3. Chofoza inkinobho ethi "Hlunga". Ngemva kwalokho, imicibisholo izovela kunhlokweni yekholomu ngayinye yamalungu afanayo.

4. Chofoza i-LMB kunoma yimuphi umcibisholo ukuze unwebe uhlu lwezihlungi ezitholakalayo.
5. Susa omaka kumanani emigqeni edingekayo. Ukuze ukhiphe umugqa ongenalutho, uzodinga ukucacisa inombolo yawo ye-serial ohlwini lwethebula.

6. Hlola umphumela. Ngemuva kokuchofoza "KULUNGILE", izinguquko kufanele zisebenze, futhi izakhi ezikhethiwe kufanele zisuswe.

Nakani! Idatha ohlwini lwethebula elihlanganisiwe ingahlungwa ngokushesha ngemibandela ehlukahlukene. Isibonelo, ngombala weseli, ngedethi, ngamagama amakholomu, njll. Lolu lwazi luningiliziwe ebhokisini lokukhetha lokuhlunga.

Isiphetho

Ngakho-ke, ku-Microsoft Office Excel, ukukhipha imigqa efihliwe etafuleni kulula kakhulu. Awudingi ukuba ngumsebenzisi we-Excel othuthukile ukuze wenze lokhu. Kwanele ukusebenzisa enye yezindlela ezingenhla, ezisebenza kungakhathaliseki ukuthi inguqulo yesofthiwe.