Ungawashintsha kanjani amaseli ku-Excel

Ngenkathi usebenza ku-Excel, kuvame ukudingeka ukuthi ushintshe ukuhleleka kwamaseli, ngokwesibonelo, udinga ukushintshanisa amanye awo. Indlela yokwenza lokhu ngezindlela ezahlukene, sizohlaziya kulesi sihloko.

Inqubo yokuhambisa amaseli

Awukho umsebenzi ohlukile okuvumela ukuthi wenze le nqubo ku-Excel. Futhi uma usebenzisa amathuluzi ajwayelekile, amanye amaseli azoshintsha nakanjani, okumele abuyiselwe endaweni yawo, okuzophumela ezenzweni ezengeziwe. Nokho, zikhona izindlela zokufeza umsebenzi, futhi zizoxoxwa ngezansi.

Indlela 1: Kopisha

Lena mhlawumbe indlela elula, ehlanganisa ukukopisha izakhi kwenye indawo ngokushintshanisa idatha yokuqala. Inqubo imi kanje:

1. Sivuka esitokisini sokuqala (sikhethe), esihlela ukusihambisa. Kuthebhu eyinhloko yohlelo, chofoza inkinobho "Kopisha" (iqembu lamathuluzi "Ibhodi lokunamathisela"). Ungakwazi futhi ukucindezela inhlanganisela yokhiye Ctrl + C.
2. Iya kunoma iyiphi iseli yamahhala eshidini bese ucindezela inkinobho "Faka" kuthebhu efanayo naseqenjini lamathuluzi. Noma ungasebenzisa ama-hotkeys futhi - Ctrl + V.
3. Manje khetha iseli lesibili esifuna ukushintshanisa ngalo elokuqala, bese silikopisha.
4. Sisukuma esitokisini sokuqala bese sicindezela inkinobho "Faka" (noma Ctrl + V).
5. Manje khetha iseli lapho inani elivela kuseli lokuqala likopishwe khona bese ulikopisha.
6. Iya kuseli yesibili lapho ufuna ukufaka khona idatha, bese ucindezela inkinobho ehambisanayo kuribhoni.
7. Izinto ezikhethiwe zishintshwe ngempumelelo. Iseli ebelibambe idatha ekopishiwe alisadingeki. Chofoza kwesokudla kuso bese ukhetha umyalo kwimenyu evulayo "Susa".
8. Kuye ngokuthi zikhona yini izici ezigcwalisiwe eduze kwaleli seli kwesokudla/ngezansi noma cha, khetha inketho efanele yokususa bese uchofoza inkinobho. OK.
9. Yilokho kuphela obekudingeka kwenziwe ukuze kushintshwe amaseli.

Naphezu kweqiniso lokuthi ukusebenzisa le ndlela, udinga ukwenza izinyathelo ezengeziwe ezengeziwe, noma kunjalo, isetshenziswa inombolo enkulu yabasebenzisi.

Indlela yesi-2: hudula bese uphonsa

Le ndlela iphinde isetshenziselwe ukushintshanisa amaseli, nokho, kulokhu, amaseli azogudluzwa. Ngakho, senza izenzo ezilandelayo:

1. Khetha iseli esihlele ukuliyisa endaweni entsha. Sihambisa ikhesa yegundane phezu komngcele wayo, futhi ngokushesha nje lapho ishintsha ukubuka ku-pointer evamile (enemicibisholo emi-4 ezindaweni ezahlukene ekugcineni), ucindezela futhi ubambe ukhiye. Shift, hambisa iseli endaweni entsha ngokucindezela inkinobho yegundane kwesokunxele.
2. Ngokuvamile, le ndlela isetshenziselwa ukushintshanisa amaseli aseduze, ngoba izinto eziguqukayo kuleli cala ngeke zephule ukwakheka kwetafula.
3. Uma sinquma ukuhambisa iseli kwamanye ambalwa, lokhu kuzoshintsha indawo yazo zonke ezinye izakhi.
4. Ngemva kwalokho, kuzodingeka ubuyisele ukuhleleka.

Indlela 3: Ukusebenzisa ama-Macros

Sishilo ekuqaleni kwesihloko ukuthi ku-Excel, maye, alikho ithuluzi elikhethekile elikuvumela ukuthi "ushintshe" amaseli ngokushesha ezindaweni (ngaphandle kwendlela engenhla, esebenza kuphela ezintweni eziseduze). Noma kunjalo, lokhu kungenziwa ngokusebenzisa ama-macros:

1. Okokuqala udinga ukwenza isiqiniseko sokuthi lokho okubizwa ngokuthi "imodi yonjiniyela" kucushiwe kuhlelo lokusebenza (kuvaliwe ngokuzenzakalelayo). Kwalokhu:
   • hamba kumenyu "Fayela" bese ukhetha ohlwini olungakwesokunxele "Amapharamitha".
   • kuzinketho zohlelo, chofoza esigatshaneni “Yenza ngendlela oyifisayo i-Ribbon”, ngakwesokudla, beka uphawu ngaphambi kwento “Unjiniyela” bese uchofoza OK.
2. Shintshela kuthebhu “Unjiniyela”, lapho chofoza isithonjana "Visual Basic" (iqembu lamathuluzi "ikhodi").
3. Kumhleli, ngokuchofoza inkinobho "Buka Ikhodi", namathisela ikhodi engezansi efasiteleni elivelayo:

   Sub ПеремещениеЯчеек()

   Dim ra As Range: Setha ra = Ukukhetha

   msg1 = "Thuthukisa i-oda le-oda"

   msg2 = "I-Произведите выделение двух диапазонов ИДЕНТИЧНОГО размера"

   Uma ra.Areas.Count <> 2 Bese kuthi MsgBox msg1, vbCritical, "Проблема": Phuma kokungaphansi

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

   Isicelo.ScreenUpdating = Amanga

   arr2 = ra.Izindawo(2).Value

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

   ra.Izindawo(1).Value = arr2

   Qeda i-Sub

4. Vala iwindi lomhleli ngokuchofoza inkinobho evamile ngendlela yesiphambano ekhoneni eliphezulu kwesokudla.
5. Ebambe ukhiye Ctrl kukhibhodi, khetha amaseli amabili noma izindawo ezimbili ezinenani elifanayo lezinto esihlela ukuzishintshanisa. Bese sicindezela inkinobho "Imakhro" (ithebhu “Unjiniyela”, Iqembu "ikhodi").
6. Kuzovela iwindi lapho sibona khona i-macro edalwe ngaphambilini. Ikhethe bese uchofoza "Gijima".
7. Njengomphumela womsebenzi, i-macro izoshintsha okuqukethwe kwamaseli akhethiwe.

Qaphela: lapho idokhumenti ivaliwe, i-macro izosuswa, ngakho ngokuzayo izodinga ukuphinda idalwe (uma kunesidingo). Kodwa, uma ulindele ukuthi esikhathini esizayo uzovame ukwenza imisebenzi enjalo, ifayela lingagcinwa ngokusekelwa okukhulu.

Isiphetho

Ukusebenza ngamaseli kuthebula le-Excel akubandakanyi nje kuphela ukufaka, ukuhlela noma ukususa idatha. Kwesinye isikhathi udinga ukuhambisa noma ukushintshanisa amaseli aqukethe amanani athile. Ngaphandle kweqiniso lokuthi alikho ithuluzi elihlukile ekusebenzeni kwe-Excel lokuxazulula lo msebenzi, lingenziwa ngokukopisha bese unamathisela amanani, ukuhambisa iseli, noma ukusebenzisa ama-macros.