Excel rondedzero

Kugadzira rondedzero-pasi rondedzero inobvumidza kwete chete kuchengetedza nguva kana uchisarudza sarudzo mune yekuzadza matafura, asi zvakare kuti uzvidzivirire kubva pakuita zvisirizvo kwedata isiriyo. Ichi chishandiso chakanakira uye chinoshanda. Ngatitsvagei kuti vangazvidzinga sei muExcel, uye maitiro ekuishandisa, uye nekutsvaga mamwe mimwe mimwe mimwe mimwe yekubata nayo.

Kushandiswa kwekudonha-pasi zvinyorwa

Kutevera, kana sezvazvakaita tsika kutaura, zvinyorwa zvekudonha-pasi zvinowanzoshandiswa mumatafura. Ndiwo mubatsiri wavo, unogona kudzikamisa huwandu hwetsika dzakaitwa munzvimbo yetafura. Ivo vanokutendera kuti usarudze kuita kukosha kweiyo chete kubva pane yakatarwa rondedzero. Uku kunomirira panguva imwe chete kuti uwane maitiro ekugadzira data uye kuchengetedza kubva pakukanganisa.

Maitiro ekugadzira

Chekutanga pane zvese, ngatitsvage nzira yekugadzira rondedzero yekudonha-pasi. Zviri nyore kuita izvi nechishandiso chinonzi "cheki yekutarisa".

1. Isu tinosimbisa iyo chikamu cheiyo tafura yakarongeka, mumasero ayo akarongwa kuti aise runyorwa rwekudonha-pasi. Kufamba mu "data" tab uye ivhu pane "data yekutarisa". Izvo zvinowanikwa pane iyo ribhoni mu "kushanda nedata" block.



2. Iyo "Verified" Window Window inotanga. Enda kune "parameter" chikamu. Mu "data mhando" nzvimbo kubva pane rondedzero, sarudza iyo "rondedzero" sarudzo. Pashure paizvozvo, tinoenda kumunda "kunobva". Pano iwe unofanirwa kutsanangura boka remazita rakagadzirirwa kushandiswa mune rondedzero. Mazita aya anogona kuitwa pamurume, uye iwe unogona kududzira chinongedzo kwavari kana vatove vakatumirwa muExcel mune imwe nzvimbo.

   Kana bhuku rairo rekupinda rakasarudzwa, ipapo rechinyorwa chimwe nechimwe chinhu chinodikanwa kuti upinde munzvimbo pamusoro pe semicolon (;).).

   

   Kana iwe uchida kusimbisa iyo data kubva kune iripo tafura, ipapo iwe unofanirwa kuenda kune iyo pepa razvinowanikwa (kana iri pane imwe), isa iyo ipo kana nzvimbo ye "nzvimbo yeiyo data yekuzivisa ye data , uye wobva waratidza huwandu hwemasero umo rondedzero iri kuwanikwa. Izvo zvakakosha kuti sero rimwe nerimwe rakaparadzana ririmo chinhu chakaparadzana chechinhu. Mushure meizvozvo, kuronga kweiyo rondedzero yakatarwa kunofanirwa kuratidzwa mu "sosi" nzvimbo.

   

   Imwe sarudzo yekuisa kutaurirana ndiyo basa renyorwa rwezita rezita. Sarudza iyo huwandu umo iyo data tsika inoratidzwa. Kuruboshwe rwetambo ye formula inzvimbo yemazita. Nekukanganisa, mariri, apo huwandu hwacho hwasarudzwa, kurongeka kwesero yekutanga yakasarudzwa inoratidzwa. Isu tiri kungopinda muzita nekuda kwezvinangwa zvedu, izvo zvatinofunga nezvakawanda zvakakodzera. Zvinodiwa zvikuru zvezita ndeche rimwe nerimwe mukati mebhuku, raive risina mapundu uye rakatanga netsamba. Izvozvi kuti iyo iyo iyo iyo iyo yatakazivikanwa pamberi pechinhu ichi chisati chazivikanwa.

   

   Zvino, muhwindo re data rekuzivisa mu "sosi" nzvimbo, iwe unofanirwa kuisa iyo "=" chiratidzo, uye ipapo ichangobva kutevera zita ratakapa huwandu. Chirongwa ichi chinobva chichiisa hukama pakati pezita uye uremu, uye zvichakwevera runyorwa rwuri mairi.

   

   Asi zvakanyatsonzwisisika zvichashandiswa kushandisa rondedzero yacho kana ukachinja ku "smart" tafura. Mutafura iyoyo, zvichave nyore kuchinja kukosha, saka zvinongochinja zvinongochinja zvinhu zvinonyorwa. Saka, huwandu uhwu huchatendeukira kune tafura yekutsiva.

   Kuti ushandure huwandu mu "Smart" tafura, sarudza iyo uye uiise mubhuta remba. Ikoko, ivhu pane bhatani "fomati setafura", iyo inoiswa patepi mune "masitaiti" block. Boka rakakura remaitiro rinovhura. Pane kushanda kwetafura, kusarudzwa kwechimwe chimiro hakuchina chero munhu, uye saka sarudza chero wavo.

   

   Mushure meizvozvo, hwindo diki rinovhura, iro rine kero yeiyo yakasarudzwa array. Kana kusarudzwa kwakaitwa nenzira kwayo, saka hapana chinoda kuchinjwa. Sezvo huwandu hwedu husina musoro, saka "tafura ine misoro" chinhu hachifanirwe kuve. Kunyangwe zvakananga mune yako nyaya, zvinogoneka, zita racho richashandiswa. Saka isu tinogona kungo tinya pane "OK" bhatani.

   

   Mushure meizvozvo, huwandu huchavezwa setafura. Kana ikapihwa, saka iwe unogona kuona munzvimbo yemazita, kuti zita raakapiwa otomatiki. Iri zita rinogona kushandiswa kuisa mu "Source" nzvimbo mu data rekusimbisa data zvichienderana neiyo yakambotsanangurwa algorithm. Asi, kana iwe uchida kushandisa rimwe zita, unogona kuzvitsiva, kungova mazita eZita.

   

   Kana rondedzero ikatumirwa mune rimwe bhuku, saka nekuda kwekuratidzira kwayo kwakaringana kunodiwa kuti ushandise basa reDVSL. Operator yakataurwa inoitirwa kuumba "SuperaBabelite" mareferensi kune pepa zvinhu mu fomu yemavara. Chaizvoizvo, maitiro acho achaitwa anenge akangofanana nezvakafanana nemhosva dzakambotsanangurwa, mu "nzvimbo" mushure meiyo chiratidzo "=" Mushure meizvozvo, mumabhureki, kero yeiyo huwandu inofanira kutsanangurwa sepfungwa yebasa iri, kusanganisira zita rebhuku uye pepa. Chaizvoizvo, sezvakaratidzwa mumufananidzo uri pazasi.



3. Pane izvi isu taigona uye tinopedza maitiro nekudzvanya pane "ok" bhatani mu data rekusimbisa data, asi kana uchida, unogona kugadzirisa fomu. Enda kune "mameseji ekupinda" chikamu che data rekusimbisa data. Pano mu "meseji" nzvimbo iwe unogona kunyora zvinyorwa izvo vashandisi vanozoona iyo inotsemuka kune iyo mashizha exement neyekudonha-pasi rondedzero. Isu tinonyora pasi meseji yatinozviona sezvakakosha.



4. Tevere, isu tinofamba kuenda ku "ERROR meseji" chikamu. Pano mune "meseji", iwe unogona kunyora zvinyorwa izvo mushandisi anozotarisa kana achiedza kupinda asina data, izvo, chero data irikushaikwa mune yekudonha-pasi rondedzero. Mu "maonero" nharaunda, unogona kusarudza iyo icon inofanira kuperekedzwa nenyevero. Isa iwo mavara emharidzo uye ivhu pane "ok".

Chidzidzo: Maitiro ekuita donhwe-pasi rondedzero muExcel

Kuita mabasa

Zvino ngatimboona kuti tinoshanda sei nechishandiso chatakagadzira pamusoro.

1. Kana tikasiya iyo isai kune chero yegedhi yeiyo nzvimbo iyo chinhambwe chakaiswa, tichaona iyo yeruzivo meseji yakaunzwa nesu pakutanga muhwindo rekusimbisa kwedata. Uye zvakare, pikicha iri muchimiro chebundu ruchachionekwa kurudyi rwechitokisi. Ndozvekuti inoshanda kuti uwane kusarudzwa kwezvinhu zvakanyorwa. Ivhu pane iyi triangle.



2. Mushure mekudzvanya pairi, menyu yacho kubva pane rondedzero yezvinhu ichavhurika. Iyo ine zvese zvinhu izvo zvakambogadzirwa kuburikidza neye data yekuzivisa yedata. Sarudza iyo sarudzo yatinozviona sezvakakosha.



3. Sarudzo yakasarudzwa icharatidzwa muchitokisi.



4. Kana isu tichiedza kupinda muchitokisi chero kukosha kusipo mune rondedzero, ichi chiito chinovharwa. Panguva imwecheteyo, kana iwe ukapa meseji yekunyevera kune iyo data yekuzivisa yedata, inoratidzwa pachiratidziri. Iwe unofanirwa kudzvanya pane iyo "Cancel" bhatani muwindo rekunyevera uye neyekutevera kuedza kuisa data chaiyo.

Nenzira iyi, kana zvichidikanwa, zadza tafura yese.

Kuwedzera chinhu chitsva

Asi chii chandinofanira kuda kuwedzera chinhu chitsva izvozvi? Zviito pano zvinobva pane kuti iwe ukagadzira sei rondedzero muwindo rekusimbisa data

1. Kana iyo data yekuumbwa kwerondedzero yakadhonzwa kubva patafura, wobva waenda kwazviri. Sarudza huwandu hwehuwandu. Kana ichi chisiri "Smart" tafura, asi yakavezwa yedata data, saka iwe unofanirwa kuisa tambo pakati pehurongwa. Kana iwe ukanyora "Smart" tafura, saka mune ino nyaya yakakwana kungoisa kukosha kwaunoda mumutsara wekutanga pasi peiyo uye iyi mutsara uchakanganisika muTafura yakarongeka. Uku kungori mukana we "smart" tafura, yatataura pamusoro.

   

   Asi ngatiti tiri kubata neyakaenzana chiitiko uchishandisa nguva nenguva. Saka, isu tinosimbisa sero pakati peiyo yakatarwa. Ndiko kuti, pamusoro pechitokisi ichi uye pasi payo panofanira kunge paine mimwe mitsara yehurongwa. Ivhu pane yakagadzirirwa chidimbu neiyo chaiyo mbeva bhatani. Mune menyu, sarudza sarudzo "paste ...".



2. Iwindo rinotanga, uko kusarudzwa kweiyo chinhu chinofanirwa kuitwa. Sarudza iyo "tambo" sarudzo uye tinya pane "ok" bhatani.



3. Saka, tambo isina chinhu yakawedzerwa.



4. Isa kukosha kwatinoshuvira kuratidzwa mune yekudonha-pasi rondedzero.



5. Mushure meizvozvo, tinodzokera kuhwendefa, iyo inoisa rondedzero yekudonha-pasi. Nekudzvanya pamusoro pembenha, kurudyi kweimwe sero renzvimbo, tinoona kuti kukosha kwakakodzera kuti zvinhu zviripo zvakave zvakawedzerwa. Zvino, kana iwe uchida, unogona kusarudza kuisa mukati mechigadzirwa.

Asi zvekuita kana rondedzero yetsika ikasimbiswa kubva patafura yakaparadzana, asi yakaitwa mumigwagwa? Kuti uwedzere chinhu mune ino kesi, zvakare ine yake algorithm yekuita.

1. Isu tinosimbisa iyo tafura ye tafura yeafura, mune izvo zvinhu zvekudonha-pasi rwuri. Enda ku "data" tab uye tinya pane "data Verified" bhatani zvakare mu "basa nedata" Boka.



2. Hwindo rekusimbisa rinotangwa. Isu tinoenda kune "parameter" chikamu. Sezvauri kuona, zvese zvirongwa pano zvakafanana chaizvo patakavaisa pakutanga. Tichafarira "sosi" mune ino nyaya. Isu tinowedzera kune iyo yatove nerondedzero kuburikidza nenongedzo ine comma (;) kukosha kana kukosha kwatinoda kuona mukudonha-pasi rondedzero. Mushure mekuwedzera ivhu kuti "ok".



3. Zvino, kana tikavhura runyorwa rwekudonha muTafura Array, tichaona kukosha kwacho ipapo.

Kubvisa chinhu

Kubviswa kwerondedzero yeiyo chinhu chinoitwa pane chaizvo iyo yakafanana algorithm sekuwedzera.

1. Kana iyo data yakasimbiswa kubva kuTafura Array, wozoenda kune ino tafura uye clay kurudyi-tinya pasero panowanikwa. Mukati menyu, mira sarudzo pane "Delete ..." sarudzo.



2. Hwindo rinobvisa hwindo rakatoda kune iro ratakaona pavanenge vachiwedzera. Pano tinoisa switch ku "tambo" chinzvimbo uye ivhu pane "ok".



3. Tambo kubva patafura, sezvatinoona, kubviswa.



4. Zvino tinodzokera kuTafura iyoyo uko kune masero ane rondedzero-pasi rondedzero. Ivhu mumizere kurudyi rwechero chitokisi. Muzvinyorwa zvakabviswa tinoona kuti chinhu chiri kure hachipo.

Chii chandinofanira kuita kana tsika dzakawedzerwa kune data ye data yeruzivo pamunhu, uye kwete kushandisa imwe tafura?

1. Isu tinosimbisa tafura neiyo yekudonha-pasi rondedzero uye enda kubhokisi rekutarisa rezvetsika, sezvatatozviita kare. Muwindo rakataurwa, tinoenda kune "parameter" chikamu. Mu "kunobva" nharaunda, isu tinogovera iyo curtor kune kukosha kwaunoda kudzima. Wobva wadzvanya bhatani rekudzima pane iyo keyboard.



2. Mushure mekunge chinhu chakabviswa, tinya pane "zvakanaka". Izvozvi hazvingadaro mune yekudonha-pasi rondedzero, sezvatakaona mune yakapfuura vhezheni yezviito netafura.

Kuzere kubviswa

Panguva imwecheteyo, pane mamiriro ezvinhu apo iyo yekudonha-pasi rondedzero inofanirwa kubviswa zvachose. Kana zvikasakosha kuti iyo data yakapinda inochengeterwa, wozobviswa iri nyore kwazvo.

1. Isu tinogovera iyo yakazara rondedzero iyo iyo yekudonha-pasi rondedzero inowanikwa. Kutamira ku "Imba" tab. Dzvanya pane "yakajeka" icon, iyo inoiswa pane ribhoni mune yekugadzirisa unit. Mune menyu inovhura, sarudza iyo "yakajeka zvese" chinzvimbo.



2. Kana chiitiko ichi chasarudzwa mune yakasarudzwa zvinhu, zvese zvinokatyiswa zvichabviswa, uye chinangwa chikuru chebasa chasvikwa: Rondedzero yekudonha ichadzimwa uye ikozvino unogona kupinda chero kukosha Nemaoko muchitokisi.

Mukuwedzera, kana mushandisi asingade kuchengetedza iyo data yakapinda, saka pane imwe sarudzo yekubvisa iyo yekudonha-pasi rondedzero.

1. Isu tinosimbisa huwandu hwemasero asina chinhu, ayo akaenzana nehuwandu hwehuwandu hwezvinhu zvakarongeka nezvinyorwa zvekudonha-pasi. Kufambisa mu "Imba" tab uye ipapo ini ndinodzvanya pane "Kopa" icon, iyo inowanikwa pane rabbon mu "Exchange Buffer".

   

   Zvakare, pachinzvimbo cheichi chiitiko, unogona kudzvanya pachikamu chakasarudzwa neiyo kurudyi mbeva bhatani uye kumira ku "Kopa" sarudzo.

   

   Kunyatsoreruka nekukurumidza mushure mekusarudzwa, shandisa seti ye ctrl + c mabhatani.

2. Mushure meizvozvo, isu tinogovera chidimbu icho chetata tafura, pane zvinhu zvekudonha-pasi zviripo. Isu tinodzvanya pane iyo "Insert" bhatani, Localized pane tepi mune yeTab yeMusha mu "Exchange Buffer" chikamu.

   

   Iyo yechipiri sarudzo yezviito ndeyekunyatsoratidza iyo kurudyi mbeva bhatani uye kumisa kusarudzwa pane iyo "Insert" sarudzo mune inoisa parameter boka.

   

   Chekupedzisira, zvinokwanisika kungoda kusarudza masero anodiwa uye kunyora musanganiswa weCtrl + v mabhatani.

3. Neimwe yematanho ari pamusoro pachinzvimbo chemasero ane tsika uye anodziya-pasi zvinyorwa, chidimbu chakachena chose chinoiswa.

Kana iwe uchida, iwe unogona kuisa huwandu husina huwandu, asi chidimbu chakakokwa nedata. Kushaikwa kwekudonha-pasi zvinyorwa ndezvekuti ivo havagone kuiswa pamunhu, asi vanogona kuteedzerwa uye kuiswa. Mune ino kesi, kuongororwa kwedata hakuzoshande. Uyezve, sezvataiona, chimiro chekudonha-pasi rondedzero yacho ichaparadzwa.

Kazhinji, zvinodikanwa kuti urege kubvisa runyorwa rwekudonha-pasi, asi panguva imwe chete ichisiya tsika dzakasunzwa kuishandisa, uye kuumbwa. Mune ino kesi, matanho akakodzera ekubvisa iyo yakataurwa kuzadza chishandiso chinoitwa.

1. Isu tinoratidza chidimbu chose mune izvo zvinhu zvine rondedzero-pasi rondedzero inowanikwa. Kutamira ku "data" tab uye ivhu pane "data yekutarisa", iyo, sezvatiri kuyeuka, iri patepi mune "kushanda nedata" Boka.



2. Iyo ichangobva kuzivikanwa test hwindo re data rekuisa rinovhura. Kuve muchikamu chero chipi zvacho chedanho rakatsanangurwa, tinoda kuita chiito chimwe - tinya pane "Bvisa zvese" bhatani. Iyo iri mukona yepazasi kuruboshwe yewindo.



3. Mushure meizvozvo, iyo yedata yekuzivisa yedata inogona kuvharwa nekudzvanya pane yakajairika yekuvhara bhatani mukona kwayo kurudyi kona seyakafanana kana "ok" bhatani pazasi pepahwindo.



4. Ipapo isu tinogovera chero yemasero umo iyo yekudonha-pasi rondedzero yakaiswa kare. Sezvatinoona, ikozvino hapana zano pakusarudza chinhu, kana gwenzi rekudaidza runyorwa kurudyi rwechinyakare. Asi panguva imwe chete, kuumbwa kunoramba kuchikwaniswa uye zvese kukosha kwakapinda uchishandisa rondedzero yasara. Izvi zvinoreva kuti nebasa ratakararama zvakabudirira: chishandiso chatisingade zvimwe, kubviswa, asi mhedzisiro yebasa rake yakaramba iri nhamba.

Sezvauri kuona, runyorwa rwekudonha-pasi runogona kufambisa zvakanyanya kuiswa kwedatha patafura, pamwe nekudzivirira iyo yekutanga tsika isiriyo. Izvi zvichaderedza huwandu hwezvikanganiso kana uchizadza matafura. Kana iwe uchifanira kuwedzera chero kukosha kwekuwedzera, iwe unogona kugara uchiitisa maitiro ehurongwa. Sarudzo yekugadzirisa ichaenderana nenzira yekusikwa. Mushure mekuzadza tafura, iwe unogona kudzima rondedzero yekudonha-pasi, kunyangwe zvisingadiwi kuita izvi. Vazhinji vashandisi vanofarira kuisiya kunyangwe mushure mekupera kwetafura yapera.