Maitiro ekuchinja masero muExcel

Paunenge uchishanda muExcel, zvinowanzoitika kuti uchinje kurongeka kwemaseru, semuenzaniso, unofanirwa kushandura mamwe acho. Nzira yekuita izvi nenzira dzakasiyana, tichazoongorora munyaya ino.

Maitiro ekufambisa maseru

Iko hakuna basa rakasiyana rinokutendera kuti uite maitiro aya muExcel. Uye kana uchishandisa maturusi akajairwa, mamwe maseru anozochinja, izvo zvinofanirwa kudzoserwa kunzvimbo yavo, izvo zvinozoguma nekuwedzera zviito. Zvisinei, pane nzira dzokuita basa racho, uye dzichakurukurwa pasi apa.

Nzira 1: Kopa

Zvichida iyi ndiyo nzira iri nyore, inosanganisira kukopa zvinhu kune imwe nzvimbo nekutsiviwa kwekutanga data. Nzira yacho ndeiyi:

1. Isu tinosimuka musero rekutanga (sarudza iyo), iyo yatinoronga kufamba. Pane iyo huru tab yechirongwa, tinya bhatani "Kopa" (Tool group "Clipboard"). Iwe unogona zvakare kungodzvanya kiyi musanganiswa Ctrl + C.
2. Enda kune chero sero yemahara pane pepa uye tinya bhatani “Isert” mune imwechete tab neboka rezvishandiso. Kana kuti unogona kushandisa hotkeys zvakare - Ctrl + V.
3. Zvino sarudza sero yechipiri yatinoda kuchinjanisa yekutanga, uye zvakare kuikopa.
4. Tinosimuka muchitokisi chekutanga todzvanya bhatani “Isert” (kana Ctrl + V).
5. Zvino sarudza sero umo kukosha kubva musero rekutanga kwakakopwa woikopa.
6. Enda kune yechipiri sero kwaunoda kuisa data, uye tinya bhatani rinoenderana paribhoni.
7. Zvinhu zvakasarudzwa zvashandurwa zvakabudirira. Sero yanga yakabata data yakakopwa haichadiwi. Tinya-kurudyi pairi uye sarudza rairo kubva pane inovhura menyu "Bvisa".
8. Zvichienderana nekuti pane zvinhu zvakazadzwa padivi pesero iri kurudyi / pasi kana kwete, sarudza yakakodzera kudzima sarudzo uye tinya bhatani. OK.
9. Ndizvo chete zvaifanira kuitwa kuitira kuchinjanisa maseru.

Pasinei nenyaya yekuti kushandisa nzira iyi, unofanirwa kuita mamwe matanho ekuwedzera, zvisinei, inoshandiswa nenhamba huru yevashandisi.

Nzira 2: dhonza uye udonhe

Iyi nzira inoshandiswawo kuchinja masero, zvisinei, munyaya iyi, masero achachinjwa. Saka, tinoita zviito zvinotevera:

1. Sarudza sero yatinoronga kutamira kunzvimbo itsva. Isu tinofambisa mutsara wembeva pamusoro pemuganhu wayo, uye painongochinja maonero kune yakajairwa pointer (ine 4 miseve munzira dzakasiyana kumagumo), kudzvanya uye kubata kiyi. kusuduruka, fambisa sero kunzvimbo itsva wadzvanywa bhatani rekuruboshwe.
2. Kazhinji kazhinji, nzira iyi inoshandiswa kuchinjanisa masero ari pedyo, sezvo kushandura zvinhu munyaya iyi hazvizokanganisa chimiro chetafura.
3. Kana tikafunga kufambisa sero kuburikidza nemamwe akati wandei, izvi zvinoshandura chinzvimbo chemamwe maelementi ese.
4. Mushure mezvo, iwe uchafanirwa kudzorera kurongeka.

Nzira 3: Kushandisa Macros

Takataura pakutanga kwechinyorwa kuti muExcel, nhamo, hapana chishandiso chakakosha chinokubvumira kukurumidza "kuchinjana" masero munzvimbo (kunze kweiyo nzira iri pamusoro, inoshanda chete kune zvinhu zviri pedyo). Nekudaro, izvi zvinogona kuitwa uchishandisa macros:

1. Kutanga iwe unofanirwa kuve neshuwa kuti iyo inonzi "yekuvandudza modhi" inobatidzwa mukushandisa (kudzima nekusarudzika). Nokuda kweizvi:
   • enda kumenyu "Faira" uye sarudza kubva pane zvakarongwa kuruboshwe "Parameters".
   • mune sarudzo dzechirongwa, tinya pane chikamu "Customize Ribhoni", kurutivi rworudyi, isa chiratidzo pamberi pechinhu "Developer" uye baya OK.
2. Chinja kune tab "Developer", apo tinya pane icon "Visual Basic" (Tool group "code").
3. Mupepeti, nekudzvanya pabhatani "Ona Code", isa kodhi iri pazasi pahwindo rinoonekwa:

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

   Dim ra As Range: Seta ra = Sarudzo

   msg1 = "Произведите выделение ДВУХ диапазонов идентичного размера"

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

   Kana ra.Areas.Count <> 2 Then MsgBox msg1, vbCritical, "Проблема": Exit Sub

   Kana ra.Areas(1).Count <> ra.Areas(2).Count Then MsgBox msg2, vbCritical, "Проблема": Exit Sub

   Application.ScreenUpdating = Nhema

   arr2 = ra.Nzvimbo(2).Kukosha

   ra.Nzvimbo(2).Kukosha = ra.Nzvimbo(1).Kukosha

   ra.Nzvimbo(1).Kukosha = arr2

   End Sub

4. Vhara hwindo rekupepeta nekudzvanya bhatani rakajairika muchimiro chemuchinjikwa mukona yepamusoro yekurudyi.
5. Kubata kiyi Ctrl pa keyboard, sarudza maseru maviri kana nzvimbo mbiri dzine nhamba yakafanana yezvinhu zvatinoronga kuchinjanisa. Tinobva tadzvanya bhatani "Macro" (tab "Developer", Boka "code").
6. Iwindo richaonekwa umo isu tinoona yakambogadzirwa macro. Sarudza iyo uye tinya "Mhanya".
7. Nekuda kwebasa, iyo macro ichachinjanisa zviri mukati memasero akasarudzwa.

Cherechedza: kana gwaro rakavharwa, iyo macro ichabviswa, saka nguva inotevera ichada kugadzirwa zvakare (kana zvichidikanwa). Asi, kana iwe uchitarisira kuti mune ramangwana iwe kazhinji uchafanirwa kuita mashandiro akadaro, iyo faira inogona kuchengetwa ine macro rutsigiro.

mhedziso

Kushanda nemaseru muExcel tafura hakungosanganisire kupinda, kugadzirisa kana kudzima data. Dzimwe nguva unofanirwa kufambisa kana kuchinjanisa maseru ane humwe hunhu. Kunyangwe ichokwadi chekuti hapana chakaparadzana chishandiso muExcel mashandiro ekugadzirisa basa iri, rinogona kuitwa nekukopa uye nekumisa kukosha, kufambisa sero, kana kushandisa macros.