Ungasishintsha kanjani isikhala somugqa ku-Excel

Ngokuvamile, ukuhlukaniswa kwemigqa kuyathakazelisa kuphela kulabo bantu abasebenza nephrosesa yamagama ye-Microsoft Word. Kodwa-ke, kwezinye izimo, ukukwazi ukwenza lokhu kuyasiza futhi ku-Excel. Isibonelo, uma ifomethi yethebula idinga ukuhlelwa okuhlangene kakhulu kwazo zonke izakhi, noma okuphambene nalokho, okubanzi. Namuhla sizochaza ngokuningiliziwe ukuthi singashintsha kanjani isikhala somugqa ku-Excel. Akukho lutho oluyinkimbinkimbi ngalokhu, vele ucindezele izinkinobho ezimbalwa bese uchofoza amagundane ambalwa ukuze ufeze umgomo wakho. Ningakwazi kokubili ukunciphisa futhi ukwandise isikhala somugqa, futhi ufunde ukuthi ungasishintsha kanjani ngokuzenzakalelayo usebenzisa ithuluzi "lombhalo".

Ungasishintsha kanjani isikhala somugqa

Ukushintsha isikhala somugqa kusho ukusikhulisa noma ukusinciphisa. Lo msebenzi wenziwa ngemenyu yokuqukethwe. Okulandelayo, iwindi lezilungiselelo lizovuleka, lapho ungenza khona nezinye izinketho zokufometha.

Le nkinga ingase yenzeke uma ukusetha kwenziwe ngokuzenzakalelayo. Njengomthetho, ngemva kokufaka umbhalo ngokungalungile, imigqa ingabekwa kude kakhulu komunye nomunye. Isizathu silula kakhulu - inani elikhulu kakhulu lamathegi okufometha akudokhumenti yomthombo. Ukuze uvimbele le nkinga, kufanele usebenzise amasevisi akhethekile asula umbhalo wamathegi angadingekile noma asuse ukufometha okungadingekile.

Ungakwazi futhi ukusula amaseli usebenzisa amathuluzi e-Excel akhelwe ngaphakathi. Kumele ngisho ukuthi akuzona zonke izenzo ezingenziwa ngokuzenzakalelayo. Ezinye zazo, okuhlanganisa nokwehliswa kwezikhala zemigqa, kuyodingeka zenziwe ngokuzimela. Ake sihlolisise indlela yokwenza lokhu.

Ungasinciphisa kanjani isikhala somugqa

Lesi yisimo esivame kakhulu umsebenzisi we-Excel okufanele abhekane naso. Ngakho ake sikubheke kuqala. Ukuze uyilungise, udinga ukunika amandla inketho eyodwa kuphela. Futhi ukulandelana kwezinyathelo kanje:

1. Chofoza igundane kwesokudla kuseli okudingeka siyilungise. 
2. Ngemuva kwalokho, kuvela imenyu lapho sidinga ukuya engxenyeni ethi "Fometha Amaseli". 
3. Lokhu kuzovula ibhokisi lengxoxo elinamathebhu amaningi. Sinentshisekelo kumenyu ethi "Ukuqondanisa", ngakho-ke sandisa inketho ehambisanayo. Ngemuva kwalokho, khetha izinketho ezisesithombeni-skrini. Okusho ukuthi, khetha inketho "emaphethelweni angaphezulu" kumenyu egqanyiswe ngonxande obomvu. 

Ngemuva kwalokho, siqinisekisa izenzo zethu futhi sivale iwindi. Sizobona umphumela ngokushesha. Ngemva kokuthola umphumela ogculisayo, sidinga ukwehlisa umugqa ofanele ube usayizi ozohambisana nobude bangempela bombhalo otholakala kuseli yethu. 

Ungasinyusa kanjani isikhala somugqa

Isimo esijwayelekile lapho sidinga ukwandisa isikhala somugqa weseli yilapho sidinga ukwelula umbhalo kubo bonke ubude beseli. Ukuze wenze lokhu, udinga ukulandela ngokuyisisekelo ukulandelana okufanayo kwezenzo, ngaphandle kwamanye amapharamitha.

Okokuqala, sidinga ukuchofoza kwesokudla kuseli lapho sifuna ukwenza khona izinguquko. Okulandelayo, khetha inketho Yefomethi Yeseli kumenyu yokuqukethwe. Ngemva kwalokho, khetha indlela yokuqondanisa mpo "ngokulinganayo".

Ngemuva kwalokho, siqinisekisa izenzo zethu futhi sibheke umphumela. Siyabona ukuthi umbhalo utholakala phezu kwawo wonke usayizi weseli. Ngemuva kwalokho, ngokulungisa usayizi wayo, ungashintsha isikhala somugqa njengoba udinga. 

Le ndlela ayikuvumeli ukuguquguquka okunjalo ukwandisa isikhala somugqa, kodwa ivumela ukusetshenziswa kwamafomula.

Indlela yokumbondela amalebula eseli

Kodwa kuthiwani uma udinga ukulungisa isikhala somugqa kahle kakhudlwana? Kulokhu, kufanele kuthathwe izinyathelo ezikhethekile. Kulesi simo, ngeke kube khona umbhalo obophezela etafuleni, futhi ungasetha ngokuphelele noma yimaphi amapharamitha. Ukuze wenze lokhu, udinga ukubopha ilebula kuseli. Ukulandelana kwezenzo kanje:

1. Khetha iseli bese uyisika. Ukuze wenze lokhu, ungasebenzisa imenyu yokuqukethwe, inkinobho ekhethekile kubha yamathuluzi, noma inhlanganisela yokhiye Ctrl + X. 
2. Ngemva kwalokho, vula ithebhu "Faka", etholakala kumenyu enkulu phezulu efasiteleni lohlelo. Ngemva kwalokho, sidinga ukunweba ibhokisi lamathuluzi elithi "Umbhalo" noma silibheke uma usayizi wesikrini wanele futhi awudingi ukunwetshwa ngokuqhubekayo. 
3. Ngemuva kwalokho, chofoza inkinobho ethi "Umbhalo" ngokuchofoza into efanelekile. 
4. Bese ucindezela inkinobho yegundane kwesokunxele bese uyibamba. Lokhu kufanele kwenziwe endaweni ezoba ngenhla kwesokunxele sombhalo wesikhathi esizayo. Ngemuva kwalokho, sakha ibhulokhi lombhalo losayizi esiwudingayo, sisebenzisa ikhesa, siyihambisa nge-diagonally kwesokudla naphansi. Ngemva kwalokho, i-block izokwakhiwa esikhundleni seseli, lapho sizodinga khona ukufaka umbhalo. 
5. Faka umbhalo usebenzisa noma yiziphi izindlela ezingenzeka: usebenzisa inhlanganisela yokhiye u-Ctrl + V, ibha yamathuluzi noma imenyu yokuqukethwe. 
6. Bese sichofoza kwesokudla embhalweni wethu bese ukhetha into ethi "Isigaba". 
7. Okulandelayo, ebhokisini lengxoxo elivelayo, udinga ukuthola inketho ethi "Isikhawu" bese usetha usayizi wayo ukuze uvumelane necala lakho. Ngemva kwalokho, chofoza inkinobho "OK". 
8. Okulandelayo, ungabona umphumela. Uma ingagculisi, ingashintshwa kusetshenziswa okhiye be-Ctrl + Z. 

Le ndlela inobubi obukodwa. Amanani azoba kuseli elinjalo awakwazi ukusetshenziswa kumafomula, futhi amafomula awakwazi ukufakwa kuleli seli.

Siyabona ukuthi akukho lutho olunzima ekuguquleni isikhala somugqa ku-Excel. Kwanele ukucindezela izinkinobho ezimbalwa nje, njengoba sithola umphumela esiwudingayo. Sincoma kakhulu ukuthi wenze idokhumenti yokuhlola futhi usebenzise imiyalo engenhla ngokusebenza. Lokhu kuzokusiza ukuthi ungalahleki uma udinga ukusebenzisa lesi sici emsebenzini wangempela. Ngayinye yezindlela ezichazwe ngenhla inezinzuzo zayo kanye nezinkinga zayo, okumele zicatshangelwe ngesikhathi sokusetshenziswa kwazo.