Lapho usebenza namatafula, kwesinye isikhathi kunesidingo sokushintsha amakholomu akulo, ezindaweni. Ake sibheke ukuthi ungakwenza kanjani lokhu kuMicrosoft Excel ngaphandle kokulahleka kwedatha, kepha ngasikhathi sinye futhi kube lula futhi kusheshe ngangokunokwenzeka.
Ukuhamba kwamakholomu
Ku-Excel, amakholomu angaguqulwa ngezindlela eziningana, okudla isikhathi futhi okuthuthukayo kakhulu.
Indlela yoku-1: Kopisha
Le ndlela isendaweni yonke, ngoba ilungele ngisho nezinhlobo ezindala kakhulu ze-Excel.
- Sichofoza kunoma isiphi iseli kukholamu kwesobunxele esihlela ukuhambisa enye ikholamu. Uhlu lomongo, khetha "Namathisela ...".
- Kuvele iwindi elincane. Khetha inani kuyo Ikholomu. Chofoza entweni "Kulungile", emva kwalokho kuzongezwa ikholomu entsha etafuleni.
- Sichofoza ngakwesokudla kuphaneli yokuhlanganisa endaweni lapho kukhonjiswa khona igama lekholomu esifuna ukuyihambisa. Kumenyu yokuqukethwe, yeka ukukhetha entweni Kopisha.
- Qhafaza kwesobunxele kwikholamu eyadalwa ngaphambili Kumenyu yokuqukethwe ebhlokini Faka Izinketho inani lokukhetha Namathisela.
- Ngemuva kokuthi ububanzi bufakwe endaweni efanele, sidinga ukususa ikholomu yangempela. Qhafaza kwesokudla kusihloko sayo. Kumenyu yokuqukethwe, khetha Susa.
Lokhu kuqeda ukuhamba kwezinto.
Indlela 2: Faka
Noma kunjalo, kukhona inketho elula yokuhamba ku-Excel.
- Sichofoza kuphaneli yokuqondisa evundlile ngencwadi ekhomba ikheli ukuze ukhethe yonke ikholamu.
- Sichofoza endaweni ekhethiwe ngenkinobho yegundane efanele nakwimenyu evulayo, yeka ukukhetha entweni Sika. Esikhundleni salokho, ungachofoza kusithonjana ngegama elifanayo, elitholakala ku-ribbon kuthebhu "Ikhaya" ebhokisini lamathuluzi Ibhodi yokunamathisela.
- Ngendlela efanayo njengoba kukhonjisiwe ngenhla, khetha ikholamu kwesokunxele lapho uzodinga ukuhambisa ikholamu esiyinqume ngaphambili. Qhafaza kwesokudla. Kumenyu yokuqukethwe, yeka ukukhetha entweni Namathisela Amaseli.
Ngemuva kwalesi senzo, izinto zizohamba ngendlela othanda ngayo. Uma kunesidingo, ngendlela efanayo ungahambisa amaqembu amakholomu, uqokomisa ububanzi obufanele balesi.
Indlela 3: Ukuhamba Okuthuthukile
Kukhona futhi indlela elula futhi ethuthukile yokuhambisa.
- Khetha ikholomu esifuna ukuyihambisa.
- Hambisa ikhesa iye emngceleni wendawo ekhethiwe. Ikhampasi ngasikhathi sinye I-Shift kwikhibhodi nenkinobho yegundane yesobunxele. Hambisa igundwane ubheke endaweni lapho ufuna ukuhambisa khona ikholomu.
- Ngesikhathi sokuhamba, umugqa wokulinganisa phakathi kwamakholomu ukhombisa lapho into ekhethiwe izofakwa khona. Ngemuva kokuthi umugqa usendaweni efanele, udinga ukukhipha inkinobho yegundane.
Ngemuva kwalokho, amakholomu adingekayo azoshintshwa.
Ukunaka! Uma usebenzisa inguqulo yakudala ye-Excel (2007 nangaphambilini) ke ukhiye I-Shift akudingeki ukuthi kube nezingcingo lapho unyakaza.
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokushintshana ngezinsika. Kunezinhlobo zombili ezilukhuni, kepha ngasikhathi sinye izinketho zomhlaba wonke zezenzo, kanye nezithuthukile kakhulu, kodwa, ezingasebenzi njalo ezinhlotsheni ezindala ze-Excel.
