Matsar da ƙwayoyin suna da alaƙa da juna a Microsoft Excel

Bukatar musanya sel tare da aiki yayin aiki a cikin Microsoft Wutar daƙunsar Bayani ke da wuya. Koyaya, irin waɗannan yanayi suna wanzu kuma suna buƙatar magance su. Bari mu gano cikin waɗanne hanyoyi zaka iya musanya sel a cikin Excel.

Motsa sel

Abin takaici, a cikin daidaitaccen akwatin kayan aiki babu irin wannan aikin da zai iya musanya sel biyu ba tare da ƙarin ayyuka ko ba tare da sauya kewayon ba. Amma a lokaci guda, kodayake wannan tsarin motsi ba shi da sauƙi kamar yadda muke so, amma har yanzu ana iya shirya shi, kuma ta hanyoyi da yawa.

Hanyar 1: Matsar da Amfani da Kwafi

Magani na farko game da matsalar ya hada da yin amfani da banal na data zuwa wani yanki daban tare da wanda zai maye gurbin m. Bari mu ga yadda ake yin hakan.

1. Zaɓi wayar don motsawa. Latsa maballin Kwafa. An sanya shi a kan kintinkiri a cikin shafin "Gida" a cikin rukunin saiti Clipboard.



2. Zaɓi wani ɓoyayyen abu a kan takardar. Latsa maballin Manna. An same shi a cikin akwatin kayan aiki guda ɗaya a kan kintinkiri kamar maɓallin. Kwafa, amma sabanin yana da bayyananniyar bayyananniyar sigar saboda girmanta.



3. Na gaba, je zuwa sel na biyu, bayanan abin da dole ne a tura su zuwa wurin farko. Zaɓi shi kuma danna maɓallin sake. Kwafa.



4. Zaɓi tantanin farko tare da bayanai tare da siginan kwamfuta kuma danna maɓallin Manna a kan tef.



5. Mun koma darajar guda zuwa inda muke bukata. Yanzu mun koma ga kimar da muka sa a cikin fayel din. Zaɓi shi kuma danna maballin. Kwafa.



6. Zaɓi sel na biyu wanda kake so ka motsa bayanan. Latsa maballin Manna a kan tef.



7. Don haka, mun yi musayar bayanan da suka dace. Yanzu yakamata a share abubuwan da ke cikin gidan jigilar kayayyaki. Zaɓi shi kuma danna-dama. A cikin menu na mahallin da aka kunna bayan waɗannan ayyukan, je zuwa Share Abun ciki.

Yanzu an share bayanan jigilar kayayyaki, kuma an gama aikin motsi sel gaba daya.

Tabbas, wannan hanyar ba ta dace ba gaba ɗaya kuma yana buƙatar ƙarin ƙarin matakai. Koyaya, yana da amfani ga yawancin masu amfani.

Hanyar 2: Jawo da Rage

Wata hanyar da zai yuwu ta musanya sel za'a iya kiranta ja da sauƙaƙe. Gaskiya ne, lokacin amfani da wannan zaɓi, motsi na sel zai faru.

Zaɓi wayar da kake son motsawa zuwa wani wuri. Maƙallin ƙyarawa zuwa kan iyakarta. A lokaci guda, ya kamata a canza shi zuwa kibiya, a ƙarshen abin da akwai alamomi da aka jagoranta ta fuskoki huɗu. Riƙe mabuɗin Canji a kan maballin kuma ja zuwa wurin da muke so.

A matsayinka na mai mulkin, wannan ya kamata ya zama sel kusa, tunda lokacin da aka canza shi ta wannan hanyar, kewayon an karkatar da kewayon.

Saboda haka, motsi ta cikin ƙwayoyin da yawa galibi yakan faru ba daidai ba a cikin yanayin tebur na musamman kuma ba a taɓa yin amfani dashi ba. Amma buƙatar canza yanayin abubuwan da ke nesa da juna ba ya shuɗe, amma yana buƙatar sauran mafita.

Hanyar 3: amfani da macros

Kamar yadda aka ambata a sama, babu wata hanya mai sauri da madaidaiciya a cikin Excel don kwafa sel biyu tsakanin kansu ba tare da kwafin zuwa cikin hanyar wucewa idan ba sa cikin wuraren da ke kusa da su. Amma ana iya samun wannan ta hanyar amfani da macros ko ƙara ɓangare na uku. Zamuyi magana game da amfani da irin wannan macro na musamman a ƙasa.

1. Da farko dai, kuna buƙatar kunna yanayin macro da kuma ƙungiyar masu haɓakawa a cikin shirin ku idan ba ku kunna su ba tukuna, tunda ba su dace ba ta hanyar asali.
2. Na gaba, je zuwa shafin "Mai haɓaka". Latsa maɓallin "Kayayyakin Kayayyakin", wanda ke kan haƙarƙarin a cikin toshe kayan aiki "Code".



3. Edita yana farawa. Saka lambar da ke ciki:

   Rukunin Kwayoyin Kwayoyin ()
Dim ra As Range: Saita ra = Yan zaɓi
msg1 = "Zaɓi jerin lambobi guda biyu"
msg2 = "Zabi jeri biyu na girman IDAN"
Idan ra.Areas.Count 2 Sannan MsgBox msg1, vbCritical, Matsala: Fita Sub
Idan ra.Areas (1) .Count ra.Areas (2) .Corder Sannan MsgBox msg2, vbCritical, "Matsala": Fita Sub
Aikace-aikacenKaɗaice = arya
arr2 = ra.Areas (2) .Value
ra.Areas (2) .Value = ra.Areas (1) .Value
ra.Areas (1) .Value = arr2
Are ƙarshen

   Bayan an sanya lambar, rufe taga edita ta danna maɓallin madaidaiciyar maɓallin a cikin kusurwar dama ta sama. Don haka, za a rubuta lambar a cikin ƙwaƙwalwar littafin kuma ana iya ƙirƙirar algorithm ɗinmu don yin ayyukan da muke buƙata.



4. Mun zabi sel guda biyu ko biyu daidai gwargwado, wanda muke so musanya. Don yin wannan, danna maɓallin farko (kewayon) tare da maɓallin linzamin kwamfuta na hagu. To, riƙe maɓallin Ctrl a kan maballin keyboard kuma hagu-danna kan sel na biyu (kewayon).



5. Don sarrafa macro, danna maballin Macrossanya a kan kintinkiri a cikin shafin "Mai Haɓakawa" a cikin rukunin kayan aiki "Lambar".



6. Taga taga Macro. Yi alama abin da ake so kuma danna maballin Gudu.



7. Bayan wannan matakin, sai macro ya canza kayan da aka zaɓi ta atomatik.

Yana da mahimmanci a lura cewa lokacin da kuka rufe fayil ɗin, an share macro ta atomatik, don haka wani lokaci na gaba zai sake yin rikodin. Domin kada kuyi wannan aikin kowane lokaci don takamaiman littafi, idan kuna shirin ci gaba da aiwatar da irin waɗannan motsi a ciki, ya kamata ku adana fayil ɗin azaman Excel Workbook tare da tallafin macro (xlsm).

Darasi: Yadda ake ƙirƙirar macro a cikin Excel

Kamar yadda kake gani, a cikin Excel akwai hanyoyi da yawa don motsa kwayoyin cikin dangin juna. Ana iya yin wannan tare da daidaitattun kayan aikin shirin, amma waɗannan zaɓuɓɓuka suna da ɗan daidaitawa da cin lokaci. Abin farin ciki, akwai macros na uku da ƙara-da suke ba ku damar warware aikin cikin sauri da sauƙi. Don haka ga masu amfani waɗanda dole ne su yi amfani da irin wannan motsi koyaushe, zaɓi na ƙarshe ne zai zama mafi kyau duka.