Paunenge uchishanda muzvirongwa zvehofisi, ungangoda kuendesa data. Kazhinji isu tiri kutaura nezvekukopa matafura kubva kuExcel kuenda kuIzwi. Zvisinei, dzimwe nguva unofanira kuita reverse. Funga nezve nzira dzaunogona kutamisa tafura kubva kuIzwi kuenda kuExcel.
Nzira yekutanga: nyore kukopa uye kuisa
Iyi nzira inokurumidza uye haidi kushanda nesimba.
"Copy" basa mune rondedzero inoonekwa
MuShoko, unofanira kusarudza tafura inoda kutamiswa. Izvi zvinogona kuitwa nekudzvanya bhatani rekurudyi. Mushure mekuita uku, unofanirwa kudzvanya pane yakasarudzwa uye sarudza iyo "Copy" chinhu kubva pane iyo rondedzero.
"Copy" basa pane "Kumba" tab
Uyewo pane "Kumba" tab pane bhatani riri mumhando yemagwaro maviri. Inonzi Copy. Kutanga, iwe unofanirwawo kusarudza tafura, uye wobva wadzvanya pairi.
Universal keyboard mapfupi ekukopa
Hazvishamisi kuti mapurogiramu akasiyana ashandise nzira yekudimbudzira imwechete kukopa data. Sarudza chidimbu chaunoda uye bata pasi musanganiswa "CTRL + C".
Mushure mematanho ese, tafura ichakopwa kune clipboard. Iwe unofanirwa kuiisa zvakananga mufaira pachayo. Vhura gwaro reExcel raunoda, sarudza sero richange riri kumusoro kuruboshwe. Mushure meizvozvo, tinya-kurudyi pairi. Menyu inozoonekwa kubva paunogona kusarudza paste sarudzo. Pane zvingasarudzwa zviviri:
- shandisa maitiro ekutanga;
- uchishandisa yekupedzisira fomati.
Namira chimiro paKumba tab
Paunenge uchinamira data, iwe unofanirwa kuita nenzira imwechete sekukopa. Enda ku "Home" tab uye uwane "Isa" bhatani. Dzvanya pairi.
Kudimbudzira kiyibhodhi yekunamira
Kuti uise tafura mufaira, unogona kushandisa musanganiswa wemakiyi anopisa. Ingo dzvanya CTRL+V. Ready.
Zvinokosha! Data kazhinji haikodzeri mumaseru mushure mekufamba, saka ungangoda kufambisa miganhu.
Mushure mekuita kwese manipulations, tinogona kutaura kuti tafura yakafambiswa zvakabudirira.
Yechipiri Nzira: Kupinza Tafura muExcel Gwaro
Iyi nzira inoshandiswa nevanhu vashoma. Nekudaro, inogona zvakare kushandiswa kuendesa tafura kubva kuShoko gwaro kuenda kuExcel.
Kushandura tafura kuti ive zvinyorwa zviri nyore
Kutanga iwe unoda kusarudza tafura. Ipapo iwe unofanirwa kuwana iyo "Layout" tab uye sarudza iyo "Data" sarudzo. Wobva wasarudza "Shandura kuChinyorwa" kubva pane yekudonha-pasi menyu. Iwindo diki richaonekwa pamberi pako, tinya pa "Tab sign" parameter. Simbisa chiito nekudzvanya pakanzi "OK". Mushure meizvozvo, iwe uchaona kuti tafura yakashandurwa kuita mavara akajeka.
Kuchengetedza tafura mune zvinyorwa
Iwe unofanirwa kuwana iyo "Faira" tebhu pane yepamusoro pani. Iwindo idzva richaonekwa pamberi pako, tsvaga "Save As" sarudzo kuruboshwe uye sarudza "Browse". Zvinofanira kuonekwa kuti shanduro dzekare dzepurogiramu hadzina basa iri. Kana hwindo rekuchengetedza raonekwa, iwe uchafanirwa kupa faira zita uye tsanangura nzvimbo iyo ichave iri. Ipapo iwe unofanirwa kusarudza "Plain text" semhando yefaira.
Kuisa tafura muExcel gwaro
MuExcel gwaro, enda kune "Data" tab. Ikoko iwe unofanirwa kuwana sarudzo "Tora data rekunze". Nzira dzinoverengeka dzichaonekwa pamberi pako, iwe unofanirwa kusarudza "Kubva pane zvinyorwa". Enda kunzvimbo yegwaro respredishiti, tinya pairi, uye sarudza Import.
Encoding sarudzo uye dzimwe sarudzo
Iwindo rinoonekwa richava nesarudzo dzakawanda. Pasi pechinyorwa "Source data fomati" iyo parameter "ine delimiters" inofanira kuratidzwa. Mushure meizvozvo, zvichave zvakakosha kutsanangura iyo encoding yakashandiswa pakuchengetedza tafura mune zvinyorwa zvinyorwa. Kazhinji unofanirwa kushanda ne "1251: Cyrillic (Windows)". Pane mukana mudiki wekuti akasiyana encoding akashandiswa. Ichada kuwanikwa uchishandisa nzira yekusarudza (sarudzo "Faira fomati"). Kana iyo encoding chaiyo yakatsanangurwa, ipapo mavara ari pazasi pehwindo anozoverengeka. Ipapo iwe unofanirwa kudzvanya bhatani re "Next".
Kusarudza iyo yekuparadzanisa hunhu uye column data fomati
Muhwindo idzva, iwe unofanirwa kutsanangura chimiro chetabhu seye delimiter character. Mushure nhanho iyi, tinya "Next". Ipapo iwe unofanirwa kusarudza iyo column fomati. Semuenzaniso, iyo default ndeye "General". Dzvanya bhatani rekuti "Pedzisa".
Kusarudza Paste Sarudzo uye Kupedzisa Kushanda
Iwe uchaona hwindo kwaunogona kusarudza mamwe maitiro ekuisa. Saka, iyo data inogona kuiswa:
- kune pepa razvino;
- kune pepa idzva.
Ready. Iye zvino unogona kushanda netafura, magadzirirwo ayo, etc. Zvechokwadi, vashandisi vanowanzofarira nzira yekutanga nokuti iri nyore uye inokurumidza, asi nzira yechipiri inoshandawo uye inoshanda.