Maitiro ekudhinda pane imwe pepa muExeale

Kana iri kudhinda matafura uye imwe data, gwaro rekunyorera rinowanzoitika kana data racho rinopfuura miganhu yepepa. Izvo zvinonyanya kufadza kana tafura isina kukwana yakatwasuka. Chokwadi, mune iyi nyaya, mazita etambo anozove pane chimwe chikamu chegwaro rakadhindwa, uye akapatsanurwa mbiru pane imwe. Kunyanya kuodzwa mwoyo, kana zvishoma zvishoma hazvina kuve nzvimbo yakakwana yekuisa zvizere tafura pane peji. Asi kubuda kubva pachigaro chiripo. Ngatifungei nezvekudhinda data pane rimwe papepa munzira dzakasiyana siyana.

Dhinda pane imwe pepa

Usati wachinjira kugadzirisa mubvunzo wekuti wakaita sei iyo data pane imwe chete pepa, iwe unofanirwa kusarudza kuti uzviite zvachose. Zvinofanira kunzwisiswa kuti mazhinji eiwo nzira dzichakurukurwa pazasi, ratidza kuderera kwehurongwa kuti ubve pane chimwe chakadhindwa. Kana iyo LEAF muganho idiki idiki muhukuru, zvinogamuchirika. Asi kana huwandu hwakakosha hweruzivo husina kukwana, saka kuedza kuisa data rese pane rimwe pepa kunogona kutungamira kuchokwadi kuti kuchaderedzwa zvekuti ivo vanozoverengera zvekuti vanozoverengera. Mune ino kesi, mune ino kesi, iyo yakanakisa yekubuditsa iyo peji papepa rakakura refomati, glue mashitsi kana kuwana imwe nzira kunze.

Saka mushandisi anofanira kuona kana akakodzera kuyedza kugadzirisa data kana kwete. Isu tichaenderera kurondedzero yenzira dzakasarudzika.

Nzira 1: Shanduko Yakatarisana

Iyi nzira ndeimwe yesarudzo dzakatsanangurwa pano, umo iwe haufanire kushandisa kuderedzwa pachiyero. Asi zvakakodzera chete kana gwaro racho riine nhamba diki yemitsetse, kana kuti mushandisi haina kukosha kuti ive yakakwana kuti ive yako peji pakureba, uye ichave yakakwana kuti iyo data ichave iri panzvimbo yepepa muhupamhi.

1. Chekutanga pane zvese, iwe unofanirwa kutarisa kana tafura yakaiswa mumiganhu yeiyo yakadhindwa pepa. Kuti uite izvi, shandura kune iyo "Peji Markup" maitiro. Kuti ugadzire clickey pane icon ine zita rimwe chete, iro riri pane iyo Status Bar.

   

   Iwe unogona zvakare kuenda ku "View" tabu uye tinya pane bhatani pane iyo peji Makokepu ", iyo iri patepi mu" bhuku racho kutarisa modes "Toolbar.



2. Mune chero yeaya sarudzo, chirongwa chinopinda mumamiriro emakoji emaki. Mune ino kesi, miganhu yeega yega yakadhindwa chinhu chinoonekwa. Sezvatinoona, kwatiri, tafura inotendeukira kune maviri mashizha akapatsanurwa, izvo zvisingagamuchirwe.



3. Kuitira kuti ugadzirise mamiriro acho ezvinhu, enda ku "Peji Markup" tab. Isu tinodzvanya "bhatani" iro rinowanikwa patepi mu "Peji Paramende" Toolbar uye kubva pane diki rondedzero inoratidzika, sarudza iyo "albhamu" chinhu.



4. Mushure mekuita zviri pamusoro, tafura yakakwana panhamba, asi kutaridzika kwake kwakatsauka kubva mubhuku riri pamamiriro ekunze.

Kune zvakare imwe shanduro yekushanduka kweshizha remagetsi.

1. Enda kune "faira" tab. Tevere, tungamira ku "printa" chikamu. Muchikamu chepakati chewindo rakavhura hwindo rakadhindwa remagedhi. Dzvanya pazita rekuti "bhuku rinotarisisa". Mushure meizvozvo, rondedzero nekukwanisa kusarudza imwe sarudzo. Sarudza zita rekuti "kurodha kutaridzika".



2. Sezvatinoona, munzvimbo yekugadzirira, mushure mezviito zviri pamusoro, pepa rakachinja nzira pane mamiriro uye izvozvi data rese rakabatanidzwa zvakakwana munzvimbo inodhinda yeimwe nzvimbo.

Mukuwedzera, iwe unogona kushandura iyo yekutarisa kuburikidza nepairamende hwindo.

1. Kuve mu "Faira" tab, mu "printa" chikamu nekudzvanya pane zvakanyorwa "Zvirongwa zvepage", izvo zviri pazasi pemamiriro ezvinhu. Muwindow newindow newindow, iwe unogona zvakare kuwana dzimwe sarudzo, asi isu tichataura zvakadzama nezve rondedzero yeiyo nzira 4 zvakadzama.



2. Iyo paramende hwindo rinotanga. Enda kune yake tabhu inonzi "peji". Mu "kutaridzika" zvigadziriso block, isu tinogadzirazve switch kubva ku "bhuku" chinzvimbo kune "nzvimbo ye" nzvimbo "chinzvimbo. Wobva wadzvanya pane "OK" bhatani pazasi pewindo.

Kutarisisa kwegwaro kuchachinjwa, uye, saka, nzvimbo yeiyo yakadhindwa chinhu yakawedzerwa.

Chidzidzo: Maitiro ekuita sheetwork pepa muExale

Nzira yechipiri: Shanduko yemiganhu yemasero

Dzimwe nguva zvinoitika kuti nzvimbo yepepa inoshandiswa zvisina basa. Ndokunge, mune mamwe makoramu pane nzvimbo isina chinhu. Izvi zvinowedzera kukura kwepeji muhupamhi, uye saka zvinoratidza iyo kupfuura iyo miganhu yeepa rakadhindwa. Mune ino kesi, zvine musoro kuderedza kukura kwemasero.

1. Isu tinosimbisa mhombwe pamusangano wekurongedza pamuganhu wemakoramu kurudyi kweiyo ikholamu iyo yaunofunga kuti inokwanisika kuderedza. Mune ino kesi, iyo yekukonzera inofanira kushanduka kuita muchinjiko nemiseve yakatungamirwa mumativi maviri. Vhara bhatani rekuruboshwe bhatani uye fambisa muganho kuruboshwe. Kufamba uku kuri kuenderera kusvikira muganho wenguva inosvika iyo data yesero yekamuri, iyo yakazadzwa kupfuura vamwe.



2. Kuvhiya kwakadaro kunoitwa pamwe nemamwe makoramu. Mushure meizvozvo, zvinowedzera zvakanyanya mukana wekuti zvese data yematafura zvichakwanira pane chimwe chakadhindwa chinhu, sezvo tafura yacho pachayo ichava yakawanda compact.

Kana zvichidikanwa, kuvhiya kwakadaro kunogona kuitwa nemitsetse.

Iko kukanganisa kwenzira iyi ndeyekuti hakuwanzo kuwanikwa, asi chete mune zviitiko zvekushanda kweBexcel Special Speet yakashandiswa zvisina basa. Kana iyo data iri yakagadziriswa sezvinobvira, asi ichiri kuiswa pachinhu chakadhindwa, panguva iyoyo iwe unofanirwa kushandisa dzimwe sarudzo dzatichazotaura nezvazvo.

Nzira 3: Dhinda Zvirongwa

Izvo zvinokwanisika kuita zvese data kana kudhinda pane chimwe chinhu, iwe unogona zvakare mumamiriro ekudhinda nekuputika. Asi mune ino kesi, zvinodikanwa kuti ufunge kuti iyo iyo data ichadzikiswa.

1. Enda kune "faira" tab. Tevere, tungamira ku "printa" chikamu.



2. Wobva warega zvakare teerera kune iyo yekudhinda marongero block muchikamu chewindo. Pazasi pane iyo inoyera marongero emunda. Nekusarudzika, panofanira kunge paine "razvino" paramende. Dzvanya pane iyo yakatarwa munda. Rondedzero yacho inovhura. Sarudza mazviri chinzvimbo "pinda pepa re peji rimwe".



3. Mushure meizvozvo, nekuderedza chiyero, ese data mugwaro razvino ichaiswa pane imwe yakadhindwa chinhu, iyo inogona kucherechedzwa muhwindo rewindo.

Zvakare, kana pasina chinoda kuderedza mitsara yese pane pepa rimwe, iwe unogona kusarudza iyo "log columns papeji" mune inoyera paramita. Mune ino kesi, iyo tafura data ichave yakatsakatiswa pane chimwe chinhu chakadhindwa, asi munzira yakatwasuka, asi munzira yakatwasuka hakuzove nekudzora kwakadaro.

Nzira 4: peji peji rwindo

Isa iyo data pane imwe yakadhindwa chinhu inogona zvakare kushandisa hwindo rinonzi "Peji Zvirongwa".

1. Pane nzira dzinoverengeka dzekutanga iyo peji Zvirongwa hwindo. Yekutanga yavo ndeye kuchinjira kune iyo "peji peji marongep" tab. Tevere, iwe unofanirwa kudzvanya pachiratidzo mune fomu yemuseve anofarira, iyo inoiswa mukona yekurudyi ye "peji peji" mudziyo block.

   

   Chinhu chakafanana nehwindo repahwindo raunoda kuti uchave uchidzvanya pane imwe chete pikicha pachayo mukona yezasi kurudyi ye "Fit" Boka reThepi.

   

   Kune zvakare sarudzo yekupinda muhwindo iri kuburikidza nePrinta Zvirongwa. Enda kune "faira" tab. Tevere, tinya pazita rekuti "prinda" mumenyu kuruboshwe kwehwindo rakavhurika. Mune zvigadziriso block, iyo iri pakati pewindo, tinya pakanyorwa "paramende", iri pasi.

   

   Pane imwe nzira yekutanga iyo paramende hwindo. Fambisa mu "printa" chikamu cheiyo faira yefaira. Tevere, tinya pane iyo inovharira marongero emunda. Nekusarudzika, iyo "iripo" paramende inotsanangurwa. Mune rondedzero iyo inovhura, sarudza chinhu "marongero eiyo tsika yekuyera ...".



2. Ndechipi chimwe chezviito zvinotsanangurwa pamusoro apa, waizosarudza, "Zvirongwa zve" peji "hwindo rinozarura pamberi pako. Isu tinoenda ku "peji" tab kana hwindo rakavhurika mune imwe tab. Mu "chiyero" zvigadziriso block, tinoisa chinja ku "nzvimbo kwete kupfuura" chinzvimbo. Muminda "peji Muupamhi "uye" p. Yakakwira "inofanira kuiswa" 1 "nhamba. Kana izvi zvisiri izvo, iwe unofanirwa kuisa iyo data yehuwandu muminda inoenderana. Mushure meizvozvo, kuitira kuti zvigadziriswe zvakatorwa nepurogiramu kuti uite, tinya pane "ok" bhatani, iyo iri pazasi pewindo.



3. Mushure mekuita ichi chiito, zvese zviri mukati mebhuku zvichagadzirirwa kudhinda pane rimwe pepa. Zvino enda ku "prinda" chikamu che "Faira" tab uye tinya pane hombe bhatani inonzi "pirinda". Mushure meizvozvo, zvinyorwa zvinodhindwa pamudanda pane rimwe pepa.

Sezvazviri munzira yapfuura, mune hwindo reParamende, iwe unogona kugadzira marongero ayo iyo data ichaiswa pane pepa chete munzira yakatwasuka, uye mumugumo wenzvimbo haazove. Nezve izvi zvinangwa, zvinodikanwa kuti udzorerwe kuchinjika kuchinzvimbo "posisa kwete kupfuura" mu "peji peji" MuUpamo "Ratidza kukosha" 1 ", uye iyo Munda" peji Kureba "siya isina chinhu.

Chidzidzo: Kuda kudhinda peji muutapwa

Sezvauri kuona, pane huwandu hwakakura hwenzira dzekugara data rese rekudhinda pane peji rimwe. Uyezve, sarudzo dzakatsanangurwa dzakasiyana chaizvo. Iko kukosha kwekushandiswa kwenzira yega yega kunofanirwa kuvezwa nemamiriro ekongiri. Semuenzaniso, kana iwe ukasiya nzvimbo yakawandisa isina chinhu mumakoramu, saka sarudzo yakakwana kwazvo ichangofambisa miganhu yavo. Zvakare, kana dambudziko racho risinga dziise tafura yakadhindwa pakureba, asi chete muupamhi chete, saka zvingaite sezvine musoro kufunga nezvekushanduka kutaridzika kwenyika. Kana idzi sarudzo dzisina kukodzera, iwe unogona kushandisa nzira dzakabatana nekuderera mukupenya, asi mune ino nyaya iyo saizi yedata ichaderedzwa.