Isu tinonzwisisa kuti kana iwe uchichinja kutevedzana kwemavara muMicrosoft izwi, iwe unofanirwa kushandura zvese nemaoko nekuti Microsoft izwi harikupi iwe chimiro chekuchinjanisa mitsara kana makoramu ekugadzirisa zvakare zvinyorwa. Zvinogona kutsamwisa uye kutora nguva kurongazve mitsara kana koramu data pamaoko paMicrosoft izwi. Nekudaro, haufanirwe kuenda nechinhu chimwe chete neMicrosoft Excel paunowana shanduko muExcel iyo iwe yaunogona kushandisa kuchinjanisa makoramu muExcel.
Paunenge uchishanda paExcel sheet, une maseru akazadzwa neimwe data, asi iwe netsaona isa data risiri iro rekoramu imwe kana mutsara mune imwe column kana mutsara. Panguva iyoyo, mubvunzo unomuka wokuti maitiro ekuchinjanisa makoramu kana mitsara muExcel ? Naizvozvo, kuti ikubatsire kuona Excel's swap function, tauya negwara diki raunogona kutevera.
Zviri mukati[ hide ]
- Maitiro eKuchinjanisa Makoramu kana Mitsetse muMicrosoft Excel
- Zvikonzero zvekuziva kuchinjisa makoramu kana mitsara muExcel
- Method 1: Chinjana Column nekudhonza
- Nzira 2: Chinjana Makoramu neCopy/Pasting
- Method 3: Shandisa Column Maneja Kurongazve Makoramu
Maitiro eKuchinjanisa Makoramu kana Mitsetse muMicrosoft Excel
Zvikonzero zvekuziva kuchinjisa makoramu kana mitsara muExcel
Paunenge uchiita basa rakakosha kune mukuru wako, kwaunofanirwa kuisa iyo chaiyo data mumakoroni chaiwo kana mitsara muExcel sheet, unoisa netsaona iyo data yekoramu 1 muColumn 2 uye data remutsara 1 mumutsara 2. Saka, unogadzirisa sei kukanganisa uku nekuti kuzviita nemaoko kunokutora nguva yakawanda? Uye apa ndipo panowanikwa shanduko yeMicrosoft excel inobatsira. Nekuchinjanisa basa, unogona kushandura zviri nyore chero mitsara kana makoramu pasina kuzviita nemaoko. Naizvozvo, zvakakosha kuziva maitiro ekuchinjanisa makoramu kana mitsara muExcel.
Tiri kutaura nzira shoma dzeKuchinjanisa makoramu kana mitsara muExcel. Unogona kuedza zviri nyore chero ipi yeiyi nzira dzinotevera dzekuchinjanisa makoramu kana mitsara mune Excel worksheet.
Method 1: Chinjana Column nekudhonza
Nzira yekukwevera inoda imwe tsika sezvo inogona kunge yakaoma kupfuura iyo inonzwika. Zvino, ngatimboti iwe une pepa reExcel rine zvibodzwa zvakasiyana zvepamwedzi zvenhengo dzechikwata chako uye iwe unoda kuchinjanisa zvibodzwa zveColumn D kuenda kukoromo C, wozotevera matanho aya eiyi nzira.
1. Tiri kutora Muenzaniso wezvibodzwa zvakasiyana zvepamwedzi zvenhengo dzechikwata chedu, sezvauri kuona pamufananidzo uri pazasi. Mune ino skrini, isu tiri kuenda chinjanisa zvibodzwa zvepamwedzi zveColumn D kuenda kuColumn C neVice-versa.
2. Zvino, unofanira sarudza chikamu kuti unoda kuchinjanisa. Muchiitiko chedu, isu tiri kusarudza koramu D nekudzvanya kumusoro paColumn D . Tarisa pascreenshot kuti unzwisise zviri nani.
3. Mushure mekunge wasarudza mbiru yaunoda kushandura, unofanirwa unza mbeva yako pasi kumucheto kwemutsara , kwauchaona kuti mbeva yekutuka ichatendeuka kubva pa chena pamwe nekaseve ine mativi mana .
4. Paunoona museve une mativi mana mushure mekuisa chitubu pamucheto wembiru, unofanira bata kiyi yekuchinja uye tinya kuruboshwe kudhonza iyo column kunzvimbo yaunofarira.
5. Paunokweva mbiru kuenda kunzvimbo itsva, uchaona an mutsara wekuisa mushure meiyo column yaunoda kufambisa yako yese column.
6. Pakupedzisira, unogona kukweva mbiru uye wosunungura kiyi yekuchinja kuti uchinje iyo column yese. Nekudaro, iwe ungangofanira kushandura iyo column musoro wega zvichienderana nedata rauri kushanda pariri. Muchiitiko chedu, tine data yemwedzi, saka tinofanira kushandura musoro wekoramu kuchengetedza kutevedzana.
Iyi yaive imwe nzira yekuchinjanisa makoramu, uye zvakafanana, unogona kushandisa nzira imwechete kuchinjanisa data mumitsara. Iyi nzira yekukwevera ingangoda kudzidzira, asi nzira iyi inogona kuuya inoshanda mushure mekunge wagona.
Zvakare Verenga: Ungashandura sei faira reExcel (.xls) kuita vCard (.vcf) faira?
Nzira 2: Chinjana Makoramu neCopy/Pasting
Imwe nzira iri nyore kuita chinjanisa makoramu muExcel ndiyo nzira yekukopa/kunamira, iri nyore kushandisa kune vashandisi. Iwe unogona kutevera matanho aya kune iyi nzira.
1. Danho rokutanga nderoku sarudza chikamu yaunoda kuchinjanisa nayo nekudzvanya pamusoro wembiru . Kwatiri isu, tiri kuchinjisa Column D kuenda kuColumn C.
2. Zvino, cheka koramu yakasarudzwa nekudzvanya-kurudyi pane iyo mbiru uye kusarudza iyo yakatemwa sarudzo. Nekudaro, iwe unogona zvakare kushandisa nzira yekudimbudzira nekudzvanya iyo ctrl + x makiyi pamwe chete.
3. Iwe unofanirwa kusarudza mbiru pamberi iyo yaunoda kuisa yako yakachekwa column uye ipapo tinya kurudyi pambiru yakasarudzwa kusarudza sarudzo ye' Isa masero akachekwa ' kubva pane pop-up menyu. Muchiitiko chedu, isu tiri kusarudza chikamu C.
4. Ukangodzvanya pane sarudzo ye' Isa masero akachekwa ,' ichachinjanisa koramu yako yese kunzvimbo yaunoda. Pakupedzisira, iwe unogona kushandura iyo column musoro nemaoko.
Method 3: Shandisa Column Maneja Kurongazve Makoramu
Iwe unogona kushandisa in-yakavakirwa column maneja kuti chinjanisa makoramu muExcel . Ichi chishandiso chinokurumidza uye chinoshanda chekuchinja makoramu muExcel sheet. Iyo column maneja inobvumira vashandisi kushandura kurongeka kwemakoramu pasina kukopa nemaoko kana kunamira iyo data. Saka, usati waenderera mberi nenzira iyi, unofanirwa kuisa iyo yekupedzisira suite kuwedzera mune yako Excel sheet. Zvino, heino maitiro ekuchinjanisa makoramu muExcel uchishandisa nzira iyi:
1. Mushure mekubudirira kuisa iyo yekupedzisira suite maadd-ons paExcel sheet yako, unofanirwa kuenda ku 'Ablebits data' tab wobva wadzvanya pa ‘Manage.’
2. Mune maneja tab, iwe unofanirwa sarudza iyo Column maneja.
3. Zvino, hwindo remaneja wembiru richabuda kudivi rekurudyi reExcel sheet yako. Muchikamu chemaneja, iwe uchaona runyoro rwemakoramu ako ese.
Four. Sarudza chikamu pane pepa rako reExcel raunoda kufambisa uye shandisa kumusoro & pasi miseve muhwindo maneja wekoramu kuruboshwe kufambisa koramu yako yakasarudzwa zviri nyore. Kwatiri, tiri kusarudza koramu D kubva papepa rebasa uye tichishandisa museve unoenda kumusoro kuifambisa pamberi pekoramu C. Saizvozvo; unogona kushandisa makiyi emiseve yekufambisa iyo column data. Nekudaro, kana iwe usingade kushandisa maturusi emuseve, saka iwe zvakare une sarudzo yekukwevera iyo koramu mune yekona maneja hwindo kunzvimbo yaunoda.
Iyi yaive imwe nzira iri nyore yaunogona nayo chinjanisa makoramu muExcel. Saka, chero mabasa aunoita mu column maneja hwindo anoitwa panguva imwe chete pane yako huru Excel sheet. Nenzira iyi, iwe unogona kuve nekutonga kwakazara pamusoro peese mabasa emuneja wekoramu.
Zvinokurudzirwa:
- Kurumidza Chinja Pakati Pemashiti Ekushanda muExcel
- Maitiro ekubvisa password kubva kuExcel File
- Maitiro ekushandura Coaxial Cable kuHDMI
Tinovimba kuti gwaro iri rakabatsira uye iwe wakakwanisa kunzwisisa maitiro ekuchinjanisa makoramu kana mitsara muExcel . Idzi nzira dziri pamusoro dziri nyore kuita, uye dzinogona kuuya dzakabatsira kana iwe uri pakati perimwe basa rakakosha. Uyezve, kana iwe uchiziva chero imwe nzira yekuchinjisa makoramu kana mitsara, unogona kutizivisa mune zvakataurwa pazasi.
Pete Mitchell Pete munyori wevashandi vepamusoro paCyber S. Pete anoda zvinhu zvese tekinoroji uye zvakare anodisa DIYer pamoyo. Ane makore gumi eruzivo rwekunyora sei-tos, maficha, uye tekinoroji madhairekitori painternet.