Ukuhambisa amaseli kuhlobene kwiMicrosoft Excel

Isidingo sokushintshana kwamaseli lapho sisebenza ku-Microsoft Excel ispredishithi siyivelakancane. Kodwa-ke, lezo zimo zikhona futhi zidinga ukuboniswa Ake sibheke ukuthi yiziphi izindlela ongashintshana ngazo ngamaseli ku-Excel.

Ukuhamba kwamaseli

Ngeshwa, kubhokisi lamathuluzi elijwayelekile akukho msebenzi onjalo ongakwazi ukushintshanisa amaseli amabili ngaphandle kwezenzo ezingeziwe noma ngaphandle kokushintsha ibanga. Kepha ngasikhathi sinye, yize le nqubo yokunyakaza ingasilula ngendlela ebesingathanda ngayo, isengahlelwa, futhi ngezindlela eziningi.

Indlela 1: Hambisa usebenzisa Ikhophi

Isixazululo sokuqala senkinga sibandakanya ukukopishwa kwe-banal kwedatha endaweni ehlukile ngokufakwa okulandelayo. Ake sibheke ukuthi kwenziwa kanjani lokhu.

1. Khetha iseli elizohanjiswa. Chofoza inkinobho Kopisha. Ibekwe kubhavu kuthebhu "Ikhaya" eqenjini lezilungiselelo Ibhodi yokunamathisela.



2. Khetha noma iyiphi enye into engenalutho eshidini. Chofoza inkinobho Namathisela. Itholakala ebhokisini lamathuluzi elifanayo kubambo njenge inkinobho. Kopisha, kepha ngokungafani nayo inokubonakala okuphawuleka kakhulu ngenxa yobukhulu bayo.



3. Okulandelayo, iya kwiseli yesibili, idatha yayo okufanele idluliselwe endaweni yokuqala. Khetha bese uchofoza inkinobho futhi. Kopisha.



4. Khetha iseli lokuqala elinedatha elinesikhombisi bese uchofoza inkinobho Namathisela ekhasethini.



5. Sihambise inani elilodwa lapho silidinga khona. Manje buyela kunani esilifakile esitokisini esingenalutho. Khetha bese uchofoza inkinobho. Kopisha.



6. Khetha iseli lesibili ofuna ukuhambisa kulo imininingwane. Chofoza inkinobho Namathisela ekhasethini.



7. Ngakho-ke, sishintshanisa imininingwane edingekayo. Manje kufanele ususe okuqukethwe kweseli yokuhamba. Khetha bese uchofoza kwesokudla. Kumenyu yokuqukethwe esetshenziswe ngemuva kwalezi zenzo, iya ku Sula okuqukethwe.

Manje imininingwane yokuhamba isusiwe, futhi umsebenzi wokuhambisa amaseli uqediwe ngokuphelele.

Vele, le ndlela ayilunge ngokuphelele futhi idinga izinyathelo eziningi ezingeziwe. Kodwa-ke, kuyasebenza kubo bonke abasebenzisi.

Indlela yesi-2: Hudula bese Udedele

Enye indlela okungenzeka ngayo ukushintshanisa amaseli kungabizwa ngokuthi ukuhudula okulula nokudonsa. Kuliqiniso, uma usebenzisa le ndlela, kuzokwenzeka iseli.

Khetha iseli ofuna ukuyisa kwenye indawo. Setha isikhombisi emngceleni wayo. Ngasikhathi sinye, kufanele iguqulwe ibe ngumcibisholo, ekugcineni kwayo kukhona izinkomba eziqondiswe ezinhlangothini ezine. Bamba ukhiye I-Shift kukhibhodi bese uhudulela endaweni lapho sifuna khona.

Njengomthetho, lokhu kufanele kube yiseli eseduze, ngoba lapho kudluliswa ngale ndlela, lonke uhla luyaguqulwa.

Ngakho-ke, ukuhamba ngamaseli ambalwa kuvame ukwenzeka ngokungalungile kumongo wethebula elithile futhi akuvamile ukusetshenziswa. Kepha isidingo sokushintsha okuqukethwe yizindawo ezikude nomunye asinyamalali, kepha sidinga ezinye izixazululo.

Indlela 3: Faka ama-macros

Njengoba kushiwo ngenhla, ayikho indlela esheshayo nelungile ku-Excel yokukopisha amaseli amabili phakathi kwawo ngaphandle kokukopisha ebangeni lokuhamba uma zingekho ezindaweni eziseduze. Kepha lokhu kungatholakala ngokusebenzisa ama-macros noma ama-add-on-third-party. Sizokhuluma ngokusebenzisa eyodwa enkulu enjalo ekhethekile ngezansi.

1. Okokuqala, udinga ukunika amandla imodi yama-macro nephaneli yonjiniyela kuhlelo lwakho uma ungakawenzi kusebenze njengamanje, ngoba akhubeki ngokuzenzakalelayo.
2. Okulandelayo, iya kuthebhu "Yonjiniyela". Qhafaza inkinobho ethi "Visual Basic", ebekwe iribhoni ku-"Code" block Ithuluzi.



3. Umhleli uyaqala. Faka ikhodi elandelayo kuyo:

   Ukuhamba Okungaphansi Kweselula ()
Dim ra As Range: Setha ra = Ukukhetha
msg1 = "Khetha amabanga AMABILI asayizi ofanayo"
msg2 = "Khetha amabanga amabili kasayizi we-IDENTICAL"
Uma ra.Areas.Count 2 Bese MsgBox msg1, vbCritical, Inkinga: Phuma Sub
Uma ra.Areas (1) .Count ra.Areas (2) .Count Bese MsgBox msg2, vbCritical, "Inkinga": Phuma Sub
Isicelo.ScreenUpdating = Amanga
arr2 = ra.Areas (2) .Value
ra.Areas (2) .Value = ra.Areas (1) .Value
ra.Areas (1) .Value = arr2
Qeda sub

   Ngemuva kokuthi ikhodi ifakiwe, vala iwindi lomhleli ngokuchofoza inkinobho eseduze evamile ekhoneni layo elingakwesokudla. Ngakho-ke, ikhodi izorekhodwa kwimemori yencwadi futhi i-algorithm yayo ingabhalwa kabusha ukwenza imisebenzi esiyidingayo.



4. Sikhetha amaseli amabili noma amabanga amabili osayizi alinganayo, esifuna ukuguquka. Ukuze wenze lokhu, chofoza ku-element yokuqala (ibanga) ngenkinobho yegundane kwesobunxele. Bese ubamba inkinobho Ctrl kukhibhodi futhi chofoza kwesobunxele kwiseli lesibili (ibanga).



5. Ukuze uqalise i-macro, chofoza inkinobho IMacrosibekwe phezu kobambo kuthebhu "Unjiniyela" eqenjini lamathuluzi "Ikhodi".



6. Kuvulwa iwindi lokukhetha ama-macro amakhulu. Maka into oyifunayo bese uchofoza inkinobho Gijima.



7. Ngemuva kwalesi senzo, i-macro isishintsha ngokuzenzakalela okuqukethwe kwamaseli akhethiwe.

Kubalulekile ukuqaphela ukuthi uma uvala ifayili, iMacro isuswa ngokuzenzakalelayo, ngakho ngokuzayo kuzodingeka ukuthi iqoshwe futhi. Ukuze ungenzi lo msebenzi isikhathi ngasinye ngencwadi ethile, uma uhlela ukwenza njalo ukunyakaza kuyo, kufanele ugcine ifayili njenge-Excel Workbook ngokuxhaswa kwe-macro (xlsm).

Isifundo: Ungayakha kanjani iMacro ku-Excel

Njengoba ukwazi ukubona, e-Excel kunezindlela eziningana zokuhambisa amaseli ahlobene. Lokhu kungenziwa ngamathuluzi ajwayelekile ohlelo, kepha lezi zinketho azilunganga futhi zidla isikhathi. Ngenhlanhla, kukhona ama-macros avela eceleni nokukufaka okukuvumela ukuthi uxazulule umsebenzi ngokushesha okukhulu kalula. Ngakho-ke kubasebenzisi okufanele basebenzise njalo ukunyakaza okunjalo, inketho yokugcina ezoba yiyona efanele kunazo zonke.