Izindlela ezi-3 zokushintsha amaseli ku-Excel

Ukushintsha ukuhleleka kwamaseli ngokuvamile kuyadingeka ukuze kwenziwe lapho kuguqulwa amathebula, umbhalo wokufometha nakho konke okuqukethwe kweshidi le-elekthronikhi ku-Microsoft Excel iyonke. Abaqalayo ngezinye izikhathi banenkinga ngalolu daba, ngakho kulesi sihloko sizosiza ukuqeda ubunzima obunjalo ngezindlela eziningana.

Indlela yokuqala: ikhophi

Njengoba ungekho umsebenzi ohlukene oklanyelwe ukudlulisa amaseli ukusuka kwenye ingxenye yeshidi ukuya kwenye, kuzodingeka usebenzise ezinye izindlela. Ngakho eyokuqala iyakopisha. Kwenziwe isinyathelo ngesinyathelo kanje:

1. Sinetafula elinedatha elondoloziwe. Kusuka kuyo, udinga ukudlulisa amaseli amaningana engxenyeni engafanele yeshidi. Ukuze wenze lokhu, chofoza enye yazo, bese kubha yamathuluzi kuthebhu ethi "Ekhaya" sithola inani elithi "Kopisha". Ungaphinda ukhethe iseli, uchofoze kwesokudla bese ukhetha okuthi “Kopisha” kumenyu yokuqukethwe. Indlela esheshayo yokukopisha idatha ukucindezela kanyekanye inhlanganisela yokhiye "I-CTRL +C”.

2. Hlola ukuthi inani likopishiwe. Ukuze wenze lokhu, iya ku- "Clipboard". Itholakala kuthebhu ethi “Ekhaya” ebhulokhini lokuqala. Sichofoza umcibisholo oya phansi futhi efasiteleni elivuleka kwesokunxele sibona umbhalo noma inombolo esanda kukopishwa. Lokhu kusho ukuthi ukukopishwa kwedatha kube yimpumelelo.

Nakani! Uma uchofoza okuthi “Sula Konke”, ukukopisha kuzodingeka kwenziwe futhi, ngoba idatha izosuswa.

3. Manje eshidini sikhetha indawo lapho sifuna ukuhambisa khona okuqukethwe kweseli, cindezela inhlanganisela yokhiye "Ctrl + V" noma shayela imenyu yokuqukethwe usebenzisa i-RMB, lapho sichofoza entweni ethi "Faka". Ungasebenzisa ithuluzi Lethebhu Ekhethekile, elikuvumela ukuthi wenze ngendlela oyifisayo ukunamathiselwa kwevelu ekopishiwe.

4. Ngokufanayo, wonke amaseli asele adluliswa, uma kunesidingo. Ukudlulisa ithebula lonke lilonke, kufanele ukhethe ngokuphelele lonke uhla. Ngemva kokuba zonke izakhi sezidlulisiwe, ungakwazi ukufometha ingxenye endala yeshidi, esenayo idatha yoqobo.

Indlela yesibili: ukushintshwa kwamaseli

Uma kungenjalo kubizwa ngokuthi donsa bese uphonsa. Akunzima ukukwenza, into eyinhloko ukuqinisekisa ukuthi yonke idatha ikopishiwe, ngaphandle kwalokho ukudluliselwa kuzokwenziwa ngokuhlanekezela. Cabangela imininingwane ku-algorithm engezansi:

1. Sihambisa ikhesa yegundane phezu komngcele weseli edinga ukuhanjiswa kwenye ingxenye yeshidi. Qaphela ukuthi ikhesa kufanele iphenduke isithonjana esimise okwesiphambano. Ngemva kwalokho, cindezela inkinobho yegundane bese uhudulela iseli endaweni oyifunayo.
2. Ungakwazi futhi ukuhambisa iseli eyodwa izinyathelo ezimbalwa phezulu noma phansi. Ukwenza lokhu, siphinde sikhethe iseli, siyihambise endaweni efanele, bese siqondanisa ukuhleleka kwamafasitela asele ashintshile ngenxa yokudlulisa.

Ngale ndlela, amaseli akhethiwe athuthela kwenye indawo, kuyilapho konke okuqukethwe ngaphakathi kwawo kugcinwa, futhi izindawo zangaphambilini ziba zingenalutho.

Indlela yesithathu: ukusebenzisa ama-macros

Le nketho ingasetshenziswa uma ama-macro efakwe ngokuzenzakalelayo ku-Excel, ngaphandle kwalokho kuzodingeka engezwe ngohlelo lwezilungiselelo zangaphakathi. Ake sihlaziye imininingwane yendlela ekhethiwe:

1. Iya kumenyu ethi "Ifayela", bese ngezansi ohlwini, uye entweni ethi "Izinketho".

2. Iwindi elithi "Izinketho ze-Excel" liyavuleka, lapha udinga ukuchofoza into ethi "Yenza ngokwezifiso Iribhoni" bese uqoka ibhokisi eduze kwento ethi "Unjiniyela". Siqinisekisa izenzo zethu ngenkinobho ethi "KULUNGILE".

Ngokushesha naka ibha yethebhu, ithebhu ebizwa ngokuthi “Unjiniyela kufanele avele ekugcineni.

3. Ngemuva kokuthi sishintshele kuthebhu ethi "Unjiniyela", kuyo sithola ithuluzi elithi "Visual Basic". I-Visual Basic iwumhleli wedatha wangokwezifiso. Udinga ukulinda iwindi elengeziwe ukuze lilayishe.

4. Ngemva kokuvula uhlelo lwezilungiselelo ezisizayo, sifuna ibhulokhi yamathuluzi "Ikhodi", sizoyidinga ukuze sihlele kahle. Sithola isigaba "Buka Ikhodi", ensimini evulayo, faka ikhodi ekhethekile, ekhonjiswe ngezansi:

I-Sub MoveCells()

Dim ra As Range: Setha ra = Ukukhetha

msg1 = “Khetha ububanzi EMIBILI obunosayizi ofanayo”

msg2 = "Khetha izigaba ezimbili zosayizi we-IDENTICAL"

Uma ra.Areas.Count <> 2 Bese kuthi MsgBox msg1, vbCritical, “Problem”: Phuma kokungaphansi

Uma i-ra.Izindawo(1).Bala <> ra.Izindawo(2).Bala Bese MsgBox msg2, vbCritical, «Проблема»: Phuma kokungaphansi

Isicelo.ScreenUpdating = Amanga

arr2 = ra.Izindawo(2).Value

ra.Izindawo(2).Value = ra.Izindawo(1).Value

ra.Izindawo(1).Value = arr2

Qeda i-Sub

5. Okulandelayo, cindezela inkinobho ethi "Enter" ukuze ulondoloze idatha. Ngemva kokulondoloza, ungavala iwindi lomhleli futhi uqhubeke nokuhlela.

6. Cindezela ukhiye othi “Ctrl”, bese ukhetha inombolo efanayo yemigqa namakholomu ukuze uthole ububanzi obufanayo kuzo zonke izinhlangothi. Manje yiya engxenyeni ethi "Macros" kubha yamathuluzi, chofoza kuyo, iwindi elinomsebenzi liyavuleka. Chofoza inkinobho ethi "Khipha".

7. Umphumela wale nqubo uwushintsho endaweni yamaseli ngaphakathi kweshidi elilodwa.

Encwadini! Kungenzeka ukudlulisa amaseli ngamanye kanye nobubanzi bawo ukusuka kwelinye ishidi le-Excel kuye kwelinye, futhi ifayela elilodwa kuphela elinamakhasi amaningi elisetshenziselwa lokhu.

Ukufingqa

Kwabaqalayo, izinketho ezimbili zokuqala zokudlulisa amaseli zifaneleka kakhulu. Azidingi ulwazi olujulile lwe-Microsoft Excel futhi zisebenza ezinguqulweni ezahlukene zesipredishithi. Ngokuqondene nama-macros, ukusetshenziswa kwale nqubo kuyinkimbinkimbi, kubaluleke kakhulu ukuthi ungadideli lutho, ngaphandle kwalokho kunengozi enkulu yokwenza iphutha nokufometha ngokuphelele ikhasi lonke ngaphandle kokubuyisela idatha, ngakho-ke kunconywa ukuba uqaphele kakhulu. lapho udlulisela amaseli.