Maselo akusuntha wina ndi mnzake mu Microsoft Excel

Kufunika kusinthanitsa maselo wina ndi mzake pamene mukugwira ntchito ku Microsoft Excel spreadsheet sikosowa. Komabe, zochitika zoterozo ndizofunika kuzikonza. Tiyeni tione momwe mungasinthire maselo mu Excel.

Maselo osuntha

Mwamwayi, muyiyiyi ya zida palibe ntchito yoteroyo, popanda zochita zina kapena osasunthirapo, akhoza kusinthanitsa maselo awiri. Koma panthawi imodzimodzi, ngakhale kuti njira iyi yosamukira si yosavuta monga momwe tingafunire, ikhoza kukhazikitsidwa, ndi m'njira zingapo.

Njira 1: Sinthani kugwiritsa ntchito kopi

Njira yoyamba yothetsera vutoli ikuphatikizapo kukopera deta kudera lina, ndikutsatiridwa. Tiyeni tiwone momwe izi zakhalira.

1. Sankhani selo limene mukufuna kusuntha. Timakanikiza batani "Kopani". Imayikidwa pa kaboni mu tab. "Kunyumba" mu gulu la zosankha "Zokongoletsera".



2. Sankhani china chilichonse chopanda kanthu pa pepala. Timakanikiza batani Sakanizani. Icho chiri muzitsulo zomwezo pa riboni monga batani. "Kopani", koma mosiyana ndi maonekedwe ake ooneka bwino chifukwa cha kukula kwake.



3. Kenaka, pitani ku selo yachiwiri, deta yomwe mukufuna kupita patsogolo. Sankhani ndipo pezani batani kachiwiri. "Kopani".



4. Sankhani selo loyamba deta ndi chithunzithunzi ndikusindikiza batani Sakanizani pa tepi.



5. Mtengo umodzi womwe tinasamukira kumene tinkafunikira. Tsopano tibwereranso ku mtengo umene tinawuika mu selo yopanda kanthu. Sankhani ndipo dinani pa batani. "Kopani".



6. Sankhani selo yachiwiri yomwe mukufuna kusuntha deta. Timakanikiza batani Sakanizani pa tepi.



7. Kotero, ife tinasintha deta yofunikira. Tsopano muyenera kuchotsa zomwe zili mu selo yopitako. Sankhani ndikulumikiza batani lamanja la mouse. Mu menyu a mauthenga omwe adatsegulidwa pambuyo pazochitikazi, pendani muyeso "Chotsani Chokhutira".

Tsopano deta yachitsulo imachotsedwa, ndipo ntchito yosuntha maselo yatha.

Inde, njira iyi si yabwino ndipo imakhala ndi zoonjezera zambiri. Komabe, ndi iye amene amagwiritsidwa ntchito ndi ogwiritsa ntchito ambiri.

Njira 2: Kokani ndi Kutaya

Njira ina yomwe ingathe kusinthitsa maselo m'malo angathe kutchedwa kuti yosavuta. Komabe, mukagwiritsa ntchito njirayi, maselo adzasuntha.

Sankhani selo yomwe mukufuna kusamukira kwina. Ikani cholozera pamalire ake. Pa nthawi imodzimodziyo, iyenera kusandulika kukhala muvi, pamapeto pake pali zofotokozera zomwe zimayendetsedwa m'njira zinayi. Gwiritsani chinsinsi Shift pa kibokosiko ndi kukokera iyo kumalo kumene tikufuna.

Monga lamulo, iyenera kukhala selo yoyandikana, popeza panthawi yomwe amasamutsidwa motere, zonsezi zasintha.

Choncho, kudutsa mumaselo angapo nthawi zambiri kumachitika molakwika pa nkhani ya tebulo lapadera ndipo imagwiritsidwa ntchito kawirikawiri. Koma chofunika kwambiri kuti musinthe zomwe zili m'madera omwe sizingatheke, sizingatheke, koma zimafuna njira zina.

Njira 3: Gwiritsani ntchito Macros

Monga tafotokozera pamwambapa, palibe njira yofulumira komanso yolondola yopita ku Excel popanda kujambula mu gulu lolowerera kuti asinthe maselo awiri pakati pawo ngati sali pafupi. Koma izi zingatheke kupyolera mu kugwiritsa ntchito macros kapena zowonjezerapo. Tidzakambirana za ntchito imodzi yapadera pansipa.

1. Choyamba, muyenera kugwiritsa ntchito mawonekedwe akuluakulu ndi gulu lokonzekera pulogalamu yanu, ngati simunawagwiritsebe ntchito, popeza ali olumala ndi osasintha.
2. Chotsatira, pitani ku tab "Wotsambitsa". Dinani pa batani "Visual Basic", yomwe ili pa bolodi mubokosi la "Code".



3. Mkonzi akuyendetsa. Ikani zizindikiro zotsatirazi:

   Sub MovingTags ()
Dulani Monga Mtundu: Yambani = Kusankha
msg1 = "Pangani zisankho ziwiri za kukula kwakukulu"
msg2 = "Pangani zisankho zamitundu iwiri ya kukula kwa IDENTICAL"
Ngati ra.Areas.Count 2 Ndiye MsgBox msg1, vbCritical, "Vuto": Kutuluka
Ngati ra.Areas (1) .Ganizirani ra.Areas (2) .Gwirani Ndiye MsgBox msg2, vbCritical, "Vuto": Kutuluka
Ntchito.ScreenUpdating = Yonyenga
arr2 = ra.Areas (2) .Value
ra.Areas (2) .Value = ra.Areas (1) .Value
ra.Areas (1) .Value = arr2
Malizani pang'ono

   Pambuyo pake, mutseke zenera pazenera podalira batani loyandikana kwambiri kumbali ya kumanja. Momwemo, malamulowa adzalembedwa mu kukumbukira kwa bukhuli ndi kusintha kwake kungabweretsedwe kuti tichite ntchito zomwe tikufunikira.



4. Sankhani maselo awiri kapena mizere iwiri yofanana yomwe tikufuna kusintha. Kuti muchite izi, dinani mbali yoyamba (mzere) ndi batani lamanzere. Ndiye ife tiwombera batani Ctrl pa khididi komanso pang'anizani pa selo yachiwiri (mtundu).



5. Kuti muyambe kugwira ntchitoyi, dinani pa batani. Macrosinayikidwa pa kaboni mu tab "Wotsambitsa" mu gulu la zida "Code".



6. Zowonekera zosankhidwa zambiri zimatsegula. Lembani chinthu chomwe mukufuna ndipo dinani pa batani. Thamangani.



7. Pambuyo pachithunzichi, macro amangosintha zomwe zili m'maselo osankhidwa m'malo.

Ndikofunika kuzindikira kuti mutatseka fayilo, macro amachotsedwa, choncho nthawi yotsatira idzalembedwanso. Kuti musamagwire ntchitoyi nthawi iliyonse pa buku linalake, ngati mukukonzekera kuchita zonsezi, muyenera kusunga fayilo monga Excel buku lothandizira (xlsm).

Phunziro: Momwe mungapangire macro ku Excel

Monga mukuonera, mu Excel pali njira zingapo zosuntha maselo osiyana wina ndi mnzake. Izi zikhoza kuchitika ndi zida zowonongeka za purogalamuyi, koma zosankhazi ndizovuta komanso zimatenga nthawi yochuluka. Mwamwayi, pali macros ndi zina zowonjezerapo zomwe zimakulolani kuthetsa vuto mofulumira komanso mosavuta. Kotero kwa ogwiritsa ntchito omwe amayenera kugwiritsa ntchito kayendetsedwe ka nthawi zonse, ndi njira yotsiriza yomwe idzakhala yabwino koposa.