Ukuhamba kwamaseli ahambisana nomunye ku-Microsoft Excel

Isidingo sokushintshanisa amaseli komunye nomunye uma sisebenza kuspredishithi se-Microsoft Excel akuvamile. Noma kunjalo, izimo ezinjalo zikhona futhi zidinga ukubhekana nazo. Ake sithole ukuthi yiziphi izindlela ongashintsha ngazo amaseli ku-Excel.

Ukuhambisa amaseli

Ngeshwa, esimisweni esilinganiselwe samathuluzi akakho umsebenzi onjalo wokuthi, ngaphandle kwezenzo ezingeziwe noma ngaphandle kokuguqula ububanzi, kungashintsha amaseli amabili. Kodwa ngesikhathi esifanayo, nakuba le nqubo yokuhamba akuyona elula njengoba singathanda, ingahle ihlelwe, futhi ngezindlela eziningana.

Indlela 1: Hambisa usebenzisa ikhophi

Isixazululo sokuqala senkinga kuhilela ukukopisha kwemininingwane ye-banal endaweni ehlukile, kulandelwa ukushintshwa. Ake sibone ukuthi lokhu kwenziwa kanjani.

1. Khetha iseli ofuna ukuhambisa. Sicindezela inkinobho "Kopisha". Ifakwa ku-ribbon kuthebhu. "Ikhaya" kwiqembu lezilungiselelo "Ibhodi lokunamathisela".



2. Khetha noma iyiphi enye into engenalutho kushidi. Sicindezela inkinobho Namathisela. Ku-block efanayo yamathuluzi kulayini njengenkinobho. "Kopisha", kodwa ngokungafani nalobubukeka obubonakala kakhulu ngenxa yobukhulu bayo.



3. Okulandelayo, iya esitokisini sesibili, okudatha idatha ofuna ukuya kuyo kuqala. Khetha bese ucindezela inkinobho futhi. "Kopisha".



4. Khetha iseli yedatha yokuqala ne-cursor bese ucindezela inkinobho Namathisela kwi-tape.



5. Inani elilodwa esasithuthela lapho sidinga khona. Manje sibuyela enanini esiyifake esitokisini esingenalutho. Khetha bese uchofoza inkinobho. "Kopisha".



6. Khetha iseli yesibili ofuna ukuhambisa idatha. Sicindezela inkinobho Namathisela kwi-tape.



7. Ngakho, sashintshe idatha edingekayo. Manje kufanele ususe okuqukethwe kweseli lokuthutha. Khetha bese uchofoza inkinobho yesokudla yegundane. Emenyu yomongo evuliwe ngemuva kwalezi zenzo, hamba ngalutho "Sula okuqukethwe".

Manje idatha yezokuthutha isusiwe, futhi umsebenzi wokuhambisa amaseli uqediwe ngokuphelele.

Yiqiniso, le ndlela ayiyona elula futhi idinga izenzo eziningi ezengeziwe. Nokho, nguye osebenza ngabasebenzisi abaningi.

Indlela 2: Hudula futhi uhlele

Enye indlela okungenzeka ngayo ukushintshanisa amaseli ezindaweni kungabizwa ngokuthi ukuhudula okulula. Nokho, uma usebenzisa le ndlela, amaseli azoshintsha.

Khetha iseli ofuna ukuhambisa kwenye indawo. Setha isikhombisi emngceleni wayo. Ngesikhathi esifanayo, kufanele iguqulwe ibe umcibisholo, ekugcineni lapho kunezibonakaliso ezikhomba izinkomba ezine. Gwema ukhiye Shift kwikhibhodi bese uyihudula endaweni esiyifunayo.

Njengomthetho, kufanele kube iseli eliseduze, kusukela ngesikhathi sokudluliswa ngale ndlela, lonke uhla luyashintsha.

Ngakho-ke, ukuhamba ngamaseli amaningana ngokuvamile kwenzeka ngokungalungile kumongo wetafula elithile futhi lisetshenziswe ngokungajwayelekile. Kodwa kunesidingo sokushintsha okuqukethwe kwezindawo ezikude kakhulu komunye nomunye akupheli, kepha kudinga ezinye izixazululo.

Indlela 3: Sebenzisa ama-Macros

Njengoba kukhonjisiwe ngenhla, ayikho indlela esheshayo neyamukelekile ye-Excel ngaphandle kokukopisha ebhentshini lokuthutha ukushintshanisa amaseli amabili phakathi kwabo uma engekho ezindaweni eziseduze. Kodwa lokhu kungatholakala ngokusebenzisa ukusetshenziswa kwama-macros noma ukungena kweqembu lesithathu. Sizoxoxa ngokusetshenziswa kwesinye se-macro ekhethekile ngezansi.

1. Okokuqala, udinga ukunika amandla imodi ye-macro kanye nephaneli yonjiniyela ohlelweni lwakho, uma ungawasebenzisi okwamanje, njengoba ukhutshaziwe ngokuzenzakalelayo.
2. Okulandelayo, iya kuthebhu "Developer". Chofoza inkinobho ethi "Visual Basic", esitholakala ku-Ribbon ebhokisini lamathuluzi "Ikhodi".



3. Umhleli usebenza. Faka ikhodi elandelayo kuyo:

   I-Sub MovingTags ()
I-Dim Range Njengesilinganiso: Setha = Ukukhetha
msg1 = "Yenza ukhetho lwezigaba ezimbili ezilinganayo"
msg2 = "Yenza ukhetho lwezigaba ezimbili zobukhulu be-IDENTICAL"
Uma i-rareAreas.Inombolo 2 Khona-ke MsgBox msg1, vbCritical, "Inkinga": Phuma Ngaphansi
Uma i-rareAreas (1) .Qaphela ama-Areas (2) .Bamba bese MsgBox msg2, vbCritical, "Inkinga": Phuma Ngaphansi
Isicelo.ScreenUpdating = Amanga
hlela = u-Areas (2) .Vala
ra.Areas (2) .Value = ra.Areas (1) .Vala
ra.Areas (1) .Value = arr2
Qedela ngaphansi

   Ngemuva kokuba ikhodi efakwe, vala iwindi lomhleli ngokuchofoza inkinobho yokuvala ehlelekile ekhoneni layo elingakwesokudla. Ngakho, ikhodi izorekhodwa enkumbulweni yencwadi kanye ne-algorithm yayo ingenziwa kabusha ukuze senze imisebenzi esiyidingayo.



4. Khetha amaseli amabili noma amabanga amabili wezingayizi ezilinganayo esifuna ukuzishintsha. Ukwenza lokhu, chofoza ku-element yokuqala (ububanzi) inkinobho yegundane lesokunxele. Bese sibopha inkinobho Ctrl kwikhibhodi futhi uchofoze ngakwesobunxele kuseli lesibili (ububanzi).



5. Ukuze usebenzise i-macro, chofoza inkinobho. Macrosefakwe ku-ribbon kuthebhu "Unjiniyela" eqenjini lamathuluzi "Ikhodi".



6. Iwindi lokukhetha elikhulu livuleka. Maka into oyifunayo bese uchofoza inkinobho. Qalisa.



7. Ngemuva kwalesi senzo, i-macro ishintsha ngokuzenzakalelayo okuqukethwe kwamaseli akhethiwe ezindaweni.

Kubalulekile ukuqaphela ukuthi uma uvale ifayela, i-macro isuswa ngokuzenzakalelayo, ngakho-ke esikhathini esizayo kuyodingeka irekhodwe futhi. Ukuze ungenzi lo msebenzi njalo isikhathi sencwadi ethize, uma uhlela ukwenza njalo ukunyakaza okunjalo, kufanele usindise ifayela njengencwadi ye-Excel enokuxhaswa macro (xlsm).

Isifundo: Indlela yokudala i-macro ku-Excel

Njengoba ubona, ku-Excel kunezindlela eziningana zokuhambisa amaseli ahlobene. Lokhu kungenziwa ngamathuluzi ajwayelekile ohlelweni, kepha lezi zindlela zingenakwenzeka futhi zithatha isikhathi esiningi. Ngenhlanhla, kukhona ama-macros ne-third-party add-ins okuvumela ukuthi uxazulule inkinga ngokushesha futhi kalula ngangokunokwenzeka. Ngakho kubasebenzisi okufanele basebenzise njalo ukunyakaza okunjalo, kuyindlela yokugcina ezoba yindlela enhle kakhulu.