Isihlungi esithuthukisiwe ku-Excel. Indlela yokufaka isicelo, indlela yokukhansela ukuhlunga okuthuthukisiwe

Uhlelo lwe-Excel lunezinhlobonhlobo zemisebenzi. Ukuhlunga ulwazi kuwumsebenzi ovamile wesipredishithi. Abasebenzisi abaningi basebenzisa ukuhlunga lapho besebenza ngenani elikhulu ledatha, kodwa akuwona wonke umuntu owaziyo ukuthi kukhona isihlungi esithuthukisiwe esengeza izici ezintsha. Kusuka esihlokweni, uzothola zonke izici zokuhlunga okuthuthukile futhi ufunde ukusebenzisa lesi sici esikahle.

Kuyini ukuhlunga idatha ku-Excel

Ukuhlunga idatha kuyisici esiwusizo esikuvumela ukuthi uhlele imininingwane ngokwemibandela ethile, futhi ufihle imigqa engadingekile.

Ukusebenzisa Isihlungi Esithuthukile ku-Excel

Ake sithi sinetafula elinolwazi oludinga ukuhlungwa.

Imiyalelo enemininingwane ibukeka kanje:

1. Ekuqaleni, sakha ithebula le-2 elengeziwe, elizoqukatha izimo zokuhlunga. Senza ikhophi yenhlokweni yetafula lokuqala futhi siyinamathisele kwesibili. Ukuze uqonde kangcono isibonelo, ake sibeke ipuleti elisizayo phezulu kancane kunelokuqala. Ukwengeza, gcwalisa entsha ngomthunzi ohlukile. Kuyaphawuleka ukuthi ithebula lesibili lingabekwa noma kuphi hhayi kuphela ekhasini lokusebenza, kodwa kuyo yonke incwadi.

2. Esigabeni esilandelayo, sizogcwalisa ipuleti eyengeziwe ngolwazi oludingekayo ukuze siqhubeke nomsebenzi. Sidinga izinkomba ezivela kuthebula lomthombo, esizohlunga ngazo ulwazi. Kulesi sibonelo, sidinga ukuhlunga ngobulili besifazane kanye nemidlalo efana nethenisi.

3. Ngemva kokugcwalisa ipuleti eyengeziwe, siqhubekela esinyathelweni esilandelayo. Sikhomba isikhombi segundane kunoma iyiphi iseli yomthombo noma amathebula engeziwe. Engxenyeni engenhla yesixhumi esibonakalayo somhleli wespredishithi, sithola ingxenye ethi “Idatha” bese siyichofoza nge-LMB. Sithola ibhulokhi yemiyalo ebizwa ngokuthi "Hlunga" bese ukhetha into ethi "Okuthuthukisiwe".

4. Iwindi elincane elikhethekile livele esikrinini, elibizwa ngokuthi "Isihlungi Esithuthukisiwe". Lapha ungenza izilungiselelo ezihlukahlukene zokuhlunga okuthuthukile.

5. Leli thuluzi linokusetshenziswa okubili. Inketho yokuqala ithi “Kopishela imiphumela kwenye indawo” kanti eyesibili ithi “Hlunga uhlu endaweni”. Le misebenzi isebenzisa okukhiphayo okuhlukahlukene kwedatha ehlungiwe. Ukwehluka koku-1 kubonisa ulwazi oluhlungiwe kwenye indawo ebhukwini, olucaciswe kusengaphambili ngumsebenzisi. Ukwehluka kwesibili kubonisa ulwazi oluhlungiwe kupuleti elikhulu. Sikhetha into edingekayo. Esibonelweni sethu esithile, sibeka umaki eduze kombhalo othi "Hlunga uhlu endaweni." Asiqhubekele esinyathelweni esilandelayo.

6. Emgqeni othi "Uhlu lwebanga" udinga ukufaka ikheli lepuleti kanye nezihloko. Kunezindlela ezimbili zokwenza le nqubo elula. Indlela yokuqala ukubhala izixhumanisi zepuleti usebenzisa ikhibhodi. Okwesibili - ngemva kokuchofoza isithonjana eduze komugqa wokungena ebangeni, udinga ukukhetha ipuleti ngokubamba inkinobho yegundane kwesokunxele. Emgqeni othi "Ububanzi bemibandela" ngendlela efanayo, sishayela ekhelini lepuleti eyengeziwe kanye nezihloko nemigqa enemibandela. Chofoza ku-"KULUNGILE" ukuze uqinisekise izinguquko ezenziwe.

Kubalulekile! Lapho ukhetha, qaphela ukuthi ungafaki noma yimaphi amaseli angenalutho endaweni ekhethiwe. Uma iseli elingenalutho liwela endaweni yokukhetha, khona-ke inqubo yokuhlunga ngeke yenziwe. Kuzokwenzeka iphutha.

7. Lapho inqubo isiqediwe, ulwazi esiludingayo kuphela oluyosala epuletini elikhulu.

8. Ake sibuyele emuva ezinyathelweni ezimbalwa. Uma umsebenzisi ekhetha inketho ethi "Kopisha imiphumela kwenye indawo", khona-ke inkomba yokugcina izoboniswa endaweni eshiwo nguye, futhi ipuleti eliyinhloko ngeke lishintshe nganoma iyiphi indlela. Emgqeni othi "Umphumela wendawo endaweni" uzodinga ukushayela ekhelini lendawo lapho umphumela uzoboniswa khona. Lapha ungafaka inkambu eyodwa, ekugcineni ezoba umsuka wepuleti elisha elengeziwe. Esibonelweni sethu esithile, leli yiseli elinekheli elithi A42.

9. Ngokuchofoza okuthi “KULUNGILE”, ipuleti elisha elengeziwe elinezilungiselelo zokuhlunga ezishiwo lizofakwa kuseli A42 futhi linwetshwe endaweni eseduze.

Khansela ukuhlunga okuthuthukisiwe ku-Excel

Kunezindlela ezimbili zokukhansela ukuhlunga okuthuthukile. Ake sicabangele indlela ngayinye ngokuningiliziwe. Indlela yokuqala yokweqa ukuhlunga okuthuthukisiwe:

1. Sithuthela engxenyeni ethi "Ikhaya".
2. Sithola ibhulokhi yemiyalo ethi "Hlunga".
3. Chofoza inkinobho ethi "Sula".

Indlela yesibili, ekhansela ukuhlunga okuthuthukisiwe:

1. Sithuthela engxenyeni ethi "Ikhaya".
2. Chofoza inkinobho yegundane kwesokunxele ku-elementi "Ukuhlela"
3. Esigabeni esilandelayo, sivula uhlu oluncane "Hlunga futhi Hlunga".
4. Kumenyu yokuqukethwe evelayo, chofoza i-LMB engxenyeni ebizwa ngokuthi "Sula".

Kubalulekile! Uma ilebula eyengeziwe enokuhlunga okuthuthukisiwe itholakala endaweni entsha, khona-ke inqubo eyenziwe nge-elementi ethi "Hlanza" ngeke isize. Konke ukukhohlisa kuyodingeka kwenziwe mathupha.

Isiphetho neziphetho mayelana nenqubo yokuhlunga ethuthukisiwe

Esihlokweni, sihlole ngezigaba izindlela ezimbalwa zokusebenzisa isihlungi solwazi oluthuthukisiwe kusihleli sespredishithi se-Excel. Ukuze usebenzise le nqubo elula, kuphela ipuleti entsha eyengeziwe edingekayo, lapho izimo zokuhlunga zizotholakala khona. Kunjalo, le ndlela inzima kakhulu ukuyisebenzisa kunokuhlunga okujwayelekile, kodwa isebenzisa ukuhlunga kanyekanye kumibandela embalwa. Le ndlela ikuvumela ukuthi usebenze ngokushesha nangempumelelo ngenani elikhulu lolwazi lwethebula.