Maitiro ekurasa masero muExcel

Kazhinji kazhinji uchishanda nematafura, vashandisi vanofanirwa kurasa masero. Dzimwe nguva data haina kuiswa mune izvo zvinhu zvehukuru hwazvino uye ivo vanofanirwa kuwedzera. Kazhinji pane mamiriro ezvinhu okutarisa kana, kuitira kuti aponese nzvimbo yebasa panhamba uye simbisa kuenzanisa kweruzivo rwekutumira, inodikanwa kuderedza kukura kwemasero. Isu tinotsanangura zviito izvo iwe zvaungashanduka saizi yemasero muExcel.

Shanduko yehupamhi hweshebhu zvinhu nekukwevera miganhu inoitika mune imwe pfungwa.

1. Isu tinotakura iyo yekukatuka pamuganho wokurudyi weiyo column sekisimusi pane yakatwasuka inoronga pane iyo iripo. Mushure mekushandura iyo isai mu bidirectional museve, isu tinogadzira iyo kuruboshwe bhatani bhatani pane bhatani rekuruboshwe uye kodzero yekuve kurudyi (kana miganhu ichidiwa kusundira) kana kuti miganhu yacho ichinetseka).



2. Pakusvika kune kukosha kunogamuchirika kwechinhu, chatinoshandura saizi, rega bhatani re mbeva.

Kana iwe uchida kufonera zvinhu zvakawanda panguva imwe chete, ipapo mune ino nyaya iwe unofanirwa kutanga waunza zvikamu zvinowirirana pane zvimedu kana zvinoenderana pane izvo zvinodikanwa kuti zvishandurwe mune imwe nyaya: upamhi kana kukwirira kana kukwirira.

1. Maitiro ekuparadzanisa, ese ari maviri emakoramu uye makoramu anenge akafanana. Kana iwe uchifanira kuwedzera sero mumutsara, wobva wadzvanya bhatani rekuruboshwe rombo parutivi rwechikamu pane inoenderana inoronga pane iyo yekutanga yavo. Mushure meizvozvo, nenzira imwecheteyo tinya pane yekupedzisira chikamu, asi panguva ino panguva imwe chete yakabata kiyi yekuchinja. Saka, mitsara mose kana makoramu inogoverwa pakati peaya zvikamu.

   

   Kana iwe uchida kusarudza masero asiri padyo nemumwe, saka mune iyi nyaya iyo algorithm yekuita ndeye yakasiyana. Dzvanya bhatani rekuruboshwe mbeva pane imwe yemakoronga zvikamu kana tambo dzinofanira kujekeswa. Zvadaro, nekudzvanya kiyi yeCTRL, ivhu mune zvimwe zvinhu zvese zviri pane imwe nzira inoronga iyo inoenderana nezvinhu zvakagadzirirwa kugoverwa. Makoramu ese kana mitsara idzo masero aya ari kuwanikwa, acharatidzwa.



2. Zvadaro, isu tinofanirwa kushandura hukuru hwemasero anodiwa, fambisa miganhu. Sarudza muganho unoenderana pane iyo cordinate panel uye, yakamirira kutaridzika kweiyo bidirectional arrow, clamp iyo yekuruboshwe bhatani bhatani. Wobva wafambisa muganho pane kuronga pane izvo zvinonyatsoda kuitwa (kuwedzera (kutetepa) upamhi hweshebhu) sezvakanyatsotsanangurwa mumusiyano nekugara kamwe chete.



3. Mushure mekunge saizi inosvika iyo yaunoda kukosha, regai mhezi. Sezvauri kuona, ukuru hwenhu kwete chete mutsara kana ikholamu yachinja, ine miganhu yeanonyengera, asi zvakare zvese zvakambozvitsaurira zvinhu.

Nzira 2: Shanduko iyo kukosha mumashoko enhamba

Iye zvino ngatidzokere kuti uchinje sei saizi yeiyo sheet zvinhu nekuisa iyo chaiyo yekutaura yehuwandu mumunda zvakanyatsogadzirirwa izvi zvinangwa izvi zvakagadzirirwa izvi zvinangwa.

Mukuremekedza nekukanganisa, saizi yeiyo sheet zvinhu yakaiswa mumakona akakosha ekuyerwa. Imwe yakadaro unit yakaenzana nechiratidzo chimwe. Nokusvibiswa, kuenderana kwesero ndeye 8.43. Ndokunge, muchikamu chinooneka chechinhu chimwe chebepa, kana chisina kuwedzerwa, iwe unogona kupinda kashoma kupfuura mavara masere. Upamhi hwakanyanya ndeye 255. Nhamba yakakura yeavara muchitokisi ichakundikana. Iyo yakaderera yakaenzana zero. Chinhu icho neiyi size chakavanzika.

Iyo default mutsara urefu ndeye 15 mapoinzi. Saizi yayo inogona kusiyana kubva pa0 kusvika makumi mana nemakumi mana emapoinzi.

1. Kuti uchinje kukwidziridzwa kweiyo tsamba yetshizha, sarudza iyo. Ipapo, kuwana mu "Imba" tab, ivhu pane "fomati" icon, iyo iri patepi muboka iri muboka "masero". Kubva pane yekudonha-pasi rondedzero, sarudza sarudzo "mutsara urefu".



2. Iwindo diki rinovhura nemunda "mutsara urefu". Ndiripo pano tinofanirwa kubvunza kukosha kwaunoda mune mapoinzi. Isu tinoita chiito uye ivhu pane "ok" bhatani.



3. Mushure meizvi, kukwirira kwemutsara umo kwakadai kwakadudzirwa kwetshizha kuchinjwa kune kukosha kwakataurwa mumativi.

Dzinenge nzira imwechete yaunogona kuchinja iyo column yakafara.

1. Sarudza iyo sheet chinhu umo upamhi hunofanira kuchinjwa. Mushure mekugara mu "imba" tab, tinya pane "fomati" bhatani. Mune menyu inovhura, sarudza sarudzo "Column yakafara ...".



2. Iko kune iwindi rakafanana rataiona kune iyo yataona mune yapfuura nyaya. Pano, mumunda, iwe unofanirwa kutsanangura huwandu mumayuniti akakosha, asi panguva ino chete ichiratidza chikamu chekisimusi. Mushure mekuita izvi zviito, tinya "OK" bhatani.



3. Mushure mekuita basa rakatsanangurwa, iyo yekoramu yakafara, iyo inoreva sero raunoda, ichachinjwa.

Pane imwezve sarudzo yekudzora iyo sheet zvinhu nekuisa iyo yakataurwa kukosha mukutaura kwehuwandu.

1. Kuti uite izvi, sarudza imwe ikholamu kana tambo umo musero waunoda, zvichienderana nezvaunoda kuchinja: upamhi uye kukwirira. Iko kusarudzwa kunoitwa kuburikidza neyekuronga panorongedzerwa kushandisa idzo sarudzo dzatakakurukura munzira 1. ipapo ivhu kuratidza bhatani rekurudyi re mbeva. Menyu yemukati unoshanda, kwaunoda kusarudza iyo "mutsara kureba ..." kana "column yakafara ...".



2. Iyo hwindo saizi inovhura, iyo yakakurukurwa pamusoro. Izvo zvinoda kupinda pakukwirira kwaunoda kana upamhi hwechitokisi nenzira yakafanana zvakambotsanangurwa.

Nekudaro, vamwe vashandisi vachiri kugutsikana neiyo Excel System inoratidza iyo saizi yeiyo sheet zvinhu zviri muhuwandu hwakaratidzwa muhuwandu hwehuwandu hwevanhu. Kuneava vashandisi, pane mukana wekuchinja kune imwe chiyero kukosha.

1. Enda kune "Faira" tab uye sarudza iyo "parameter" chinhu mumusoro kuruboshwe menyu.



2. Iyo paramende hwindo rinotanga. Menyu iri mune kuruboshwe kwayo. Enda kuChikamu "Inosarudzwa". Kurudyi kwehwindo kune dzakasiyana siyana marongero. Pukuta pasi pepuranga pasi uye kutsvaga "Screen" chishandiso block. Mune ichi block, iyo munda "zvikamu pamutsetse" zviripo. Dzvanya pairi uye kubva pane yekudonha-pasi rondedzero, sarudza yakanyanya kukodzera chikamu chekuyera. Pane sarudzo dzinotevera:
   • Masentimita;
   • Millimita;
   • Inches;
   • Default zvikamu.

   Mushure mekusarudza kuitwa, kune iyo yekupinda shanduko nechisimba, tinya pane "ok" bhatani pazasi pewindo.

Iye zvino unogona kugadzirisa shanduko muhukuru hwemasero uchishandisa idzo sarudzo dzinoratidzwa pamusoro, dzichishanda chikamu chakasarudzwa cheyero.

Nzira 3: otomatiki resizer resaize

Asi, iwe unoona kuti hazvisi nyore zvachose kuti vade kuchinja masayizi emasero, achiverengera kune yakatarwa. Neraki, Excel inopa kugona kwekushandura otomatiki saizi yeiyo sheet zvinhu, maererano nekukosha kweiyo data yavanazvo.

1. Sarudza chitokisi kana yeboka data mune iyo isina kuiswa mune yeiyo sheet chinhu chine ivo. MuThebhu "Imba" Clay pane imwe bhatani bhatani "fomati". Mukukasira menyu, sarudza sarudzo kuti ishandiswe kune chaiyo chinhu: "otomatiki mutsara wekureba" kana "column yakafara otomatiki".



2. Mushure mekunge paramende yakataurwa yakaiswa, saizi yemasero ichachinja zvinoenderana nezviri mukati, nenzira yakasarudzwa.

Chidzidzo: mutsara kukwirira auto hunhu muExcel

Sezvauri kuona, shandura hukuru hwemasero munzira dzinoverengeka. Ivo vanogona kukamurwa kuita mapoka maviri makuru: kudhonza miganhu uye kuisa kwehuwandu hwehuwandu mumunda unokosha. Mukuwedzera, iwe unogona kuseta kureba kana upamhi uye makoramu.