Lapho usebenza namatafula, ngezinye izikhathi kunesidingo sokushintsha amakholomu akhona kuwo ezindaweni. Ake sibone ukuthi singakwenza kanjani lokhu ku-Microsoft Excel ngaphandle kokulahlekelwa kwedatha, kodwa ngesikhathi esifanayo, njengokulula nangokusheshisa ngangokunokwenzeka.
Ukuhambisa amakholomu
Ku-Excel, amakholomu angashintshwa ngezindlela eziningana, kokubili kunalokho kunzima futhi kuqhubekela phambili.
Indlela 1: Kopisha
Le ndlela isendaweni yonke, njengoba ifanele ngisho nasenguqu ezindala kakhulu ze-Excel.
- Sichofoza noma yiliphi iseli lekholomu ngakwesokunxele esilungiselela ukuhambisa elinye ikholomu. Kuhlu lomongo, ukhethe into "Namathisela ...".
- Iwindi elincane livela. Khetha inani kulo "Ikholomu". Chofoza entweni "Kulungile"emva kwalokho ikholomu entsha etafuleni izongezwa.
- Sichofoza ngokuqondile ku-panel yokuxhumanisa endaweni lapho igama lekholomu esifuna ukuhambisa likhonjisiwe. Emenyu yomongo, yeka ukukhethwa kwento "Kopisha".
- Sebenzisa inkinobho yegundane lesokunxele ukuze ukhethe ikholomu owayidala ngaphambili. Emenyu yomongo ku-block "Izinketho zokufaka" khetha inani Namathisela.
- Ngemuva kokuba ibanga lifakwe endaweni efanele, sidinga ukususa ikholomu yokuqala. Chofoza ngakwesokudla esihlokweni sayo. Kumenyu yesimo, khetha into "Susa".
Ngalokhu lokhu izinto zizoqedwa.
Indlela 2: faka
Noma kunjalo, kunendlela elula yokuhambisa ku-Excel.
- Chofoza iphaneli yokuxhumanisa enezingqimba nencwadi echaza ikheli ukuze ukhethe lonke ikholomu.
- Sichofoza endaweni ekhethiwe nge inkinobho yesinxele yegundane futhi kwimenyu evuliwe simisa ukhetho entweni "Sika". Esikhundleni salokho, ungachofoza isithonjana ngegama elifanayo elifanayo elibhebheni kuthebhu "Ikhaya" ebhodini lamathuluzi "Ibhodi lokunamathisela".
- Ngendlela efanayo njengoba kuchaziwe ngenhla, khetha ikholomu ngakwesokunxele okuzodinga ukuhambisa ikholomu esiyiqede ngaphambili. Chofoza inkinobho yesokudla yegundane. Emenyu yomongo, yeka ukukhethwa kwento "Faka ama-Cells Cut".
Ngemuva kwalesi senzo, izakhi zizohamba njengoba uthanda. Uma kunesidingo, ngendlela efanayo ungahambisa amaqembu ekholomu, ugcizelela kulolu hlu olufanele.
Indlela 3: inketho yokuhamba phambili
Kukhona nendlela elula futhi ehamba phambili yokuhambisa.
- Khetha ikholomu esifuna ukuhambisa.
- Hambisa isikhombisi kumngcele wendawo ekhethiwe. Ngesikhathi esifanayo sibopha Shift ekhibhodi naskrinini legundane lesokunxele. Hambisa igundane ngokuya endaweni ofuna ukuhambisa ngayo ikholomu.
- Ngesikhathi sokuhamba, umugqa wesici phakathi kwamakholomu ubonisa ukuthi into ekhethiwe izofakwa kuphi. Emva komugqa endaweni efanelekile, mane ukhulule inkinobho yegundane.
Emva kwalokho, amakholomu adingekayo azoshintshwa.
Qaphela! Uma usebenzisa inguqulo endala ye-Excel (2007 nangaphambili), ke Shift Asikho isidingo sokuphoqa uma uhamba.
Njengoba ungabona, kunezindlela eziningana zokushintshanisa amakholomu. Kukhona okunzima kakhulu, kodwa ngesikhathi esifanayo izinketho zomhlaba jikelele zesenzo, nezithuthukisiwe ezengeziwe, okwamanje, akusebenzi ngaso sonke isikhathi izinguqulo ezindala ze-Excel.
