Microsoft Excel chishandiso chine simba chine hupfumi hwekuita, icho chakanyanya kukodzera kuita zviito zvakasiyana nedata rinounzwa mune tabular fomu. MuShoko, iwe unogonawo kugadzira matafura uye kushanda nawo, asi zvakadaro, iyi haisi purogiramu yepurogiramu munyaya iyi, nokuti ichiri kugadzirirwa mamwe mabasa nezvinangwa.
Asi dzimwe nguva mushandisi anotarisana nebasa rekufambisa tafura yakagadzirwa muExcel kune yekunyora zvinyorwa. Uye haasi munhu wose anoziva kuti angazviita sei zvakanaka. Muchinyorwa chino, tichaongorora zvakadzama nzira dzese dziripo dzekufambisa tafura kubva paspredishiti mupepeti kuenda kune chinyorwa chinyorwa.
Zviri mukati: "Maitiro ekufambisa tafura kubva kuExcel kuenda kuIzwi"
Nguva dzose kopi-paste yetafura
Iyi ndiyo nzira iri nyore yekupedzisa basa racho. Kuchinjisa kubva kune imwe mupepeti kuenda kune imwe, unogona kungoisa iyo yakakopwa ruzivo. Ngationei kuti tozviita sei.
- Chokutanga pane zvose, vhura faira netafura yaunoda muExcel.
- Tevere, sarudza negonzo tafura (ese kana chimwe chikamu chayo) chaunoda kuendesa kuIzwi.
- Mushure meizvozvo, tinya-kurudyi chero munzvimbo yakasarudzwa uye sarudza "Copy" kubva pane zviri mukati menyu. Iwe unogona zvakare kushandisa yakakosha keyboard nzira yekudimbudzira Ctrl + C (Cmd + C ye macOS).
- Mushure mekunge iyo data yaunoda ikopwa kune clipboard, vhura iyo Word text editor.
- Gadzira gwaro idzva kana kuvhura riripo.
- Isa chitubu paunoda kunamira chikwangwani chakakopwa.
- Tinya-kurudyi panzvimbo yakasarudzwa uye sarudza "Namira" kubva pane menyu. Iwe unogona zvakare kushandisa iyo keyboard nzira yekudimbudzira Ctrl+V (Cmd+V ye macOS).
- Zvese zvagadzirwa, tafura inoiswa muIzwi. Ngwarira kumucheto kwayo wezasi wekurudyi.
- Kudzvanya chiratidzo chegwaro folda kunovhura rondedzero ine ekuisa sarudzo. Kwatiri isu, ngatitarisei pane yekutanga fomati. Nekudaro, iwe zvakare une sarudzo yekuisa data semufananidzo, mameseji, kana kushandisa chimiro chetafura inotangwa.
Cherechedza: Iyi nzira ine kusakosha kwakanyanya. Iyo sheet wide inogumira mune yemavara edhita, asi kwete muExcel. Nokudaro, tafura inofanira kuva yehupamhi hwakakodzera, zvichida ine makoramu akawanda, uye kwete yakafara zvikuru. Zvikasadaro, chikamu chetafura hachizokwane pane pepa uye chinoenda kupfuura pepa rezvinyorwa zvinyorwa.
Asi, chokwadi, munhu haafaniri kukanganwa pamusoro pechinhu chakanaka, kureva, kukurumidza kwekushanda kwekopi-paste.
Namatidza special
- Danho rekutanga kuita zvimwechete sezviri munzira yatsanangurwa pamusoro, kureva kuvhura uye kukopa kubva kuExcel kuenda kubhodhi rekodhi tafura kana chikamu chayo.
- Tevere, enda kune iyo text editor uye isa chitubu panzvimbo yekuisa yetafura.
- Wobva wadzvanya-kurudyi wosarudza "Special Bet ..." kubva pane menyu.
- Nekuda kweizvozvo, hwindo rine zvigadziriso zvekusarudza paste rinofanira kuoneka. Sarudza chinhu "Isa", uye kubva pane rondedzero pazasi - "Microsoft Excel Sheet (chinhu)". Simbisa kuiswa nekudzvanya bhatani re "OK".
- Nekuda kweizvozvo, tafura inoshandurwa kuita mufananidzo fomati uye inoratidzwa mune yemavara edhita. Panguva imwecheteyo, ikozvino, kana isina kukwana zvakakwana pane pepa, zviyero zvayo zvinogona kugadziriswa nyore nyore, sekushanda nemifananidzo, nekukwevera mapuranga.
- Zvakare, nekudzvanya kaviri patafura, unogona kuivhura muExcel fomati yekugadzirisa. Asi mushure mekunge zvigadziriso zvese zvaitwa, iyo tafura yekuona inogona kuvharwa uye shanduko dzichakurumidza kuratidzwa mune yemavara edhita.
Kuisa tafura kubva mufaira
Mune nzira mbiri dzakapfuura, danho rekutanga raive rekuvhura nekukopa spreadsheet kubva kuExcel. Munzira iyi, izvi hazvidiwi, saka isu tinobva tavhura text editor.
- Mumenyu yepamusoro, enda kune "Insert" tab. Tevere - mubhokisi rezvishandiso "Text" uye mune iyo rondedzero inovhura, tinya pane chinhu "Chinhu".
- Muhwindo rinoonekwa, tinya "Kubva faira", sarudza faira ine tafura, wobva wadzvanya pane zvakanyorwa "Insert".
- Tafura ichaendeswa semufananidzo, semunzira yechipiri inotsanangurwa pamusoro apa. Saizvozvo, iwe unogona kushandura saizi yayo, pamwe nekugadzirisa iyo data nekudzvanya kaviri patafura.
- Sezvawatoona, kwete chete chikamu chakazadzwa chetafura chinoiswa, asi kazhinji zvese zviri mukati mefaira. Naizvozvo, usati waita yekuisa, bvisa zvese zvisina basa kubva pazviri.
mhedziso
Saka, iwe wakadzidza nzira yekuchinjisa tafura kubva kuExcel kuenda kuIzwi mavara edhita munzira dzinoverengeka. Zvichienderana nenzira yakasarudzwa, mhedzisiro yakawanikwa inosiyanawo. Nokudaro, usati wasarudza imwe sarudzo, funga pamusoro pezvaunoda kuwana pakupedzisira.