Kusuntha maselo okhudzana wina ndi mnzake mu Microsoft Excel

Kufunika kosinthana maselo wina ndi mnzake mukamagwira ntchito mu Microsoft Excel spreadsheet ndikosowa. Komabe, zoterezi zilipo ndipo zikufunika kuthana nazo. Tiyeni tiwone umo mungasinthira maselo mu Excel.

Kusuntha maselo

Tsoka ilo, mu bokosi la zida wamba mulibe ntchito yotere yomwe ikhoza kusinthana ndi maselo awiri popanda kuchitapo kanthu kapena osatembenuza mtunduwo. Koma nthawi yomweyo, ngakhale kayendetsedwe kameneka si kophweka monga momwe tikanakondera, zitha kukonzedwa, komanso m'njira zingapo.

Njira 1: Yendetsani Kugwiritsa Ntchito Copy

Njira yoyamba yothetsera vutoli imaphatikizapo kukopera kwa banal kudera lina kopatula ndikubwezeretsera pambuyo pake. Tiyeni tiwone momwe izi zimachitikira.

1. Sankhani khungu kuti lisunthidwe. Dinani batani Copy. Iwayikidwa pachifuwa "Pofikira" m'magulu azokonda Clipboard.



2. Sankhani chilichonse chopanda papepala. Dinani batani Ikani. Ili mu kabokosi kameneka pa riboni monga batani. Copy, koma mosiyana ndi iyo imawoneka kwambiri chifukwa cha kukula kwake.



3. Kenako, pitani ku foni yachiwiri, yomwe imayenera kusunthidwa kumalo oyamba. Sankhani ndikudina batani kachiwiri. Copy.



4. Sankhani khungu loyamba lomwe lili ndi chidziwitso ndikudina batani Ikani pa tepi.



5. Tasunthira mtengo umodzi mmalo momwe timafunikira. Tsopano bweretsani ku mtengo womwe tinayikamo selo yopanda kanthu. Sankhani ndikudina batani. Copy.



6. Sankhani foni yachiwiri yomwe mukufuna kusunthira detayo. Dinani batani Ikani pa tepi.



7. Chifukwa chake, tinasinthana ndi zofunika. Tsopano muyenera kuchotsa zomwe zili mu foni yamayendedwe. Sankhani ndikudina kumanja. Pazosankha zomwe zidakhazikitsidwa pambuyo pa izi, pitani ku Chotsani Zolemba.

Tsopano deta yapaulendo yachotsedwa, ndipo ntchito yosuntha maselo yatha.

Zachidziwikire, njirayi siyabwino kwenikweni ndipo imafunikira njira zowonjezera zambiri. Komabe, ndizomwe zimagwira ntchito kwa ogwiritsa ntchito ambiri.

Njira 2: Kokani ndi Kutaya

Njira inanso yomwe imasinthira maselo imatha kutchedwa kuti kukoka kosavuta ndi kugwetsa. Zowona, mukamagwiritsa ntchito njirayi, kusintha kosintha kwa khungu kumachitika.

Sankhani khungu lomwe mukufuna kusamukira kwina. Khazikitsani chotengera kumalire ake. Nthawi yomweyo, iyenera kusinthidwa kukhala muvi, kumapeto kwake kuli zolozera mbali zinayi. Gwirani fungulo Shift pa kiyibodi ndikukokera komwe tikufuna.

Monga lamulo, ichi chizikhala khungu loyandikana nalo, popeza ikasamutsidwa motere, lonse lonse limasunthidwa.

Chifukwa chake, kusuntha maselo angapo nthawi zambiri kumachitika molakwika munthawi ya tebulo linalake ndipo sikugwiritsidwa ntchito kwenikweni. Koma kufunika kosintha zomwe zili m'madera akutali sikusowa, koma kumafuna mayankho ena.

Njira 3: kutsatira macros

Monga tafotokozera pamwambapa, palibe njira yachangu komanso yolondola mu Excel yokomera maselo awiri pakati pawo popanda kukopera mumayendedwe ngati alibe malo oyandikana nawo. Koma izi zitha kuchitika pogwiritsa ntchito macros kapena owonjezera ena. Tikambirana za kugwiritsa ntchito imodzi yapaderayi pansipa.

1. Choyamba, muyenera kuwongolera mawonekedwe akulu ndi otsogolera pulogalamu yanu ngati simunawagwiritsepo ntchito, popeza ndi olumala osagwirizana nawo.
2. Kenako, pitani ku "Mapulogalamu" a batani. Dinani pa batani la "Visual Basic", lomwe lili pa riboni mu "Code" block block.



3. Mkonzi akuyamba. Lowetsani zotsatirazi:

   Sub Cell Movement ()
Dim ra As Range: Set ra = Kusankhidwa
msg1 = "Sankhani magulu AWIRI a kukula ofanana"
msg2 = "Sankhani magawo awiri a kukula kwa IDENTICAL"
Ngati ra.Areas.Count 2 Kenako MsgBox msg1, vbCritical, Vuto: Tulukani Sub
Ngati ra.Areas (1) .Count ra.Areas (2) .Count Kenako MsgBox msg2, vbCritical, "Vuto": Tulukani Sub
Kugwiritsa.ScreenUpdating = Zabodza
arr2 = ra.Areas (2) .Value
ra.Areas (2) .Value = ra.Areas (1) .Value
ra.Areas (1) .Value = arr2
Mapeto sub

   Codeyo ikaikidwamo, mutseke windo la mkonzi podina batani loyimilira pafupi pomwe ngodya yake yakumanja ili pomwepo. Chifukwa chake, malamulowa adzajambulidwa pokumbukira bukulo ndipo ma algorithm ake amatha kupangidwanso kuti agwire ntchito zomwe tikufuna.



4. Timasankha maselo awiri kapena magulu awiri ofanana, omwe timafuna kusintha. Kuti muchite izi, dinani pazinthu zoyambirira (mtundu) ndi batani lakumanzere. Kenako gwani batani Ctrl pa kiyibodi komanso dinani kumanzere kwachiwiri (mitundu).



5. Kuyendetsa macro, dinani batani Macrosyakhazikitsidwa pachifuwa "Wopanga" pagulu lazida "Code".



6. Windo losankha macro likutseguka. Maka chinthu chomwe mukufuna ndikudina batani Thamanga.



7. Pambuyo pa izi, macro mosintha amasintha zomwe zili m'maselo omwe asankhidwa.

Ndikofunika kudziwa kuti mukatseka fayilo, ma macro amangochotsa, ndiye kuti nthawi yotsatira iyenera kujambulanso. Pofuna kuti musagwire ntchito iyi nthawi iliyonse kwa buku linalake, ngati mukufuna kupitilirabe, musunge fayilo ngati Excel Workbook yothandizidwa ndi macro (xlsm).

Phunziro: Momwe mungapangire zazikulu mu Excel

Monga mukuwonera, ku Excel pali njira zingapo zoyendetsera maselo kuti azigwirizana. Izi zitha kuchitika ndi zida za pulogalamuyo, koma zosankha izi ndizosokoneza ndipo zimawononga nthawi. Mwamwayi, pali ma macro a chipani chachitatu ndi zowonjezera zomwe zimakupatsani mwayi wothana ndi ntchitoyi mwachangu komanso mosavuta momwe mungathere. Chifukwa chake kwa ogwiritsa ntchito omwe amayenera kutsatira kayendedwe kamtunduwu, ndi njira yomaliza yomwe ingakhale yoyenera kwambiri.