Maitiro ekuita masero akafanana muExcel

Kazhinji kana uchishanda neExcel maspredishiti, zvinove zvakafanira kugadzirisa maseru saizi. Izvo zvinodikanwa kuita izvi kuitira kuenderana neruzivo rwese rwunodiwa ipapo. Asi nekuda kwekuchinja kwakadaro, kutaridzika kwetafura kunokanganisa zvakanyanya. Kuti ugadzirise mamiriro ezvinhu aya, zvinodikanwa kuita sero imwe neimwe saizi yakafanana neyakasara. Iye zvino tichadzidza zvakadzama kuti ndezvipi zviito zvinoda kutorwa kuti zvizadzise chinangwa ichi.

Kuisa zvikamu zvekuyera

Pane maviri makuru ma paramita ane hukama nemasero uye anoratidza saizi yawo:

1. Column width. Nekumisikidza, kukosha kunogona kubva pa0 kusvika 255. Iyo yakasarudzika kukosha ndeye 8,43.
2. Mutsara urefu. Values ​​inogona kubva pa0 kusvika 409. Iyo default ndeye 15.

Imwe neimwe poindi yakaenzana ne0,35 mm.

Panguva imwecheteyo, zvinokwanisika kugadzirisa zvikamu zvekuyera umo hupamhi nekukwirira kwemasero zvichagadziriswa. Kuti uite izvi, tevera mirairo:

1. Tsvaga iyo "Faira" menyu uye uvhure. Pachava nechinhu "Settings". Anofanira kusarudzwa.
   

   

2. Tevere, hwindo richaonekwa, kudivi rekuruboshwe iro rondedzero yakapihwa. Unofanira kuwana chikamu “Kuwedzera” wobva wadzvanya pairi. Kurudyi kwehwindo iri, tiri kutsvaga boka remaparamita anonzi "Ratidza". Panyaya yezvinyorwa zvekare zveExcel, ichanzi "Screen". Pane imwe sarudzo "Zvikwata zviri mumutsara", iwe unofanirwa kudzvanya paikozvino yakatarwa kukosha kuti uvhure runyoro rwemayuniti ese aripo echiyero. Excel inotsigira zvinotevera - inches, centimeters, millimeters.
   

   

3. Mushure mekusarudza sarudzo yaunoda, tinya "OK".
   

   

Saka, ipapo iwe unogona kusarudza chiyero chekuyera chakanyanya kukodzera mune imwe nyaya. Mamwe maparameter achaiswa maererano nayo.

Kurongeka Kwenzvimbo Yesero - Nzira 1

Iyi nzira inobvumidza iwe kurongedza maseru saizi mune yakasarudzwa renji:

1. Sarudza huwandu hwemasero anodiwa.
   

   

2. Vhura iyo tab "Kumba"boka riripi "Masero". Pane bhatani pazasi chaipo pacho. "Fomati". Kana iwe ukadzvanya pairi, runyoro runozaruka, apo mumutsara wepamusoro pachave nesarudzo "line urefu". Unofanira tinya pairi.
   

   

3. Tevere, hwindo rine mutsara wenguva dzeurefu sarudzo richaonekwa. Shanduko dzichaitwa kune ese ma parameter enzvimbo yakasarudzwa. Kana zvese zvaitwa, unofanirwa kudzvanya "OK".
   

   

4. Mushure mezvose izvi zviito, zvaive zvichikwanisika kugadzirisa urefu hwemasero ose. Asi inoramba ichigadzirisa hupamhi hwemakoramu. Kuti uite izvi, iwe unofanirwa kusarudza iyo yakafanana siyana zvakare (kana nekuda kwechimwe chikonzero sarudzo yakabviswa) uye vhura iyo imwechete menyu, asi ikozvino isu tiri kufarira iyo sarudzo. "column width". Iyo yechitatu kubva kumusoro.
   

   

5. Zvadaro, isa kukosha kunodiwa. Mushure meizvozvo, tinosimbisa zviito zvedu nekudzvanya bhatani "OK".
   

   

6. Hooray, zvese zvaitwa manje. Mushure mekuita manipulations anotsanangurwa pamusoro, ese maseru saizi paramita akafanana muhuwandu hwese.
   

   

Asi iyi handiyo yega nzira inogoneka yekuona kuti maseru ese ane saizi yakafanana. Kuti uite izvi, unogona kuzvigadzirisa pane coordination panel:

1. Kuti uise hurefu hunodiwa hwemaseru, fambisa chitubu kune yakatwasuka coordination panel, uko sarudza nhamba dzemitsara yese uye wobva wadaidza menyu yemukati nekudzvanya-kurudyi pane chero sero rerodha yepaneru. Pachava nesarudzo "line urefu", pauri iwe unofanirwa kubaya kare nebhatani rekuruboshwe.
   

   

2. Ipapo iyo hwindo rimwe chete richabuda sepamuenzaniso wapfuura. Tinofanira kusarudza urefu hwakakodzera uye tinya pa "OK".
   

   

3. Upamhi hwemakoramu hwakaiswa nenzira imwecheteyo. Kuti uite izvi, zvinodikanwa kuti usarudze iyo inodiwa renji pane yakachinjika coordination panel uye wobva wavhura iyo mamiriro menyu, pakusarudza iyo sarudzo. "column width".
   

   

4. Tevere, tsanangura kukosha kwaunoda uye tinya "OK".

Kubatanidza pepa rose - nzira 2

Mune zvimwe zviitiko, zvinodikanwa kurongedza kwete yakatarwa siyana, asi zvese zvinhu. 

1. Nomuzvarirwo, hapana chikonzero chokuti masero ose asarudzwe mumwe nomumwe. Izvo zvinodikanwa kuti uwane diki rectangle iri pajunction yeyakamira uye yakachinjika coordinate mabara. Kana imwe sarudzo ipfupi yekhibhodi Ctrl + A.
   

   

2. Heano maitiro ekusimbisa maseru ebasa mune imwe inoyevedza kufamba. Iye zvino unogona kushandisa nzira yekutanga kuseta maseru paramita.
   

   

Kuzvigadzirisa - nzira 3

Muchiitiko ichi, unoda kushanda nemiganhu yesero zvakananga. Kuti uite nzira iyi, unoda:

1. Sarudza nzvimbo imwe chete kana maseru ese epepa rakati. Mushure meizvozvo, isu tinoda kufambisa chitubu kune chero yepirumu miganhu mukati menzvimbo yakasarudzwa. Kupfuurirazve, chitubu chichava chidiki chekuwedzera chiratidzo chine miseve inotungamira kwakasiyana. Kana izvi zvikaitika, unogona kushandisa bhatani rekuruboshwe kuti uchinje nzvimbo yemuganhu. Sezvo nzvimbo yakaparadzana yakasarudzwa mumuenzaniso watiri kutsanangura, shanduko dzinoshandiswa pairi.
   

   

2. Ndizvozvo, zvino maseru ese mune imwe nhanho ane hupamhi hwakafanana. Mission yakapera, sezvavanotaura.
   

   

3. Asi isu tinogona kuona mune iyo skrini kumusoro kuti kureba kuchiri kwakasiyana. Kuti ugadzirise kukanganisa uku, unoda kugadzirisa ukuru hwemitsara nenzira imwecheteyo. Izvo zvinodikanwa kuti usarudze mitsara inoenderana pane yakatwasuka coordinate panel (kana pepa rose) uye shandura chinzvimbo chemiganhu yechero ipi zvayo. 17.png
4. Zvino zvaitwa zvechokwadi. Takakwanisa kuona kuti masero ose akaenzana.

Iyi nzira ine imwe drawback - hazvibviri kugadzirisa hupamhi uye urefu. Asi kana kukwirira kwakarurama kusingadiwi, zvakanyanya nyore kupfuura nzira yekutanga.

Zvinokosha! Kana iwe uchida kuona kuti maseru ese epepa ane saizi yakafanana, iwe unofanirwa kusarudza imwe neimwe yadzo uchishandisa bhokisi riri pakona yepamusoro kuruboshwe kana kushandisa musanganiswa. Ctrl + A, uye isa iwo chaiwo kukosha nenzira imwechete.

Maitiro ekurongedza mitsara mushure mekuisa tafura - Nzira 4

Zvinowanzoitika kuti kana munhu akaedza kunamira tafura kubva pa clipboard, anoona kuti mumasero akaiswa, hukuru hwavo hahuenderani neaya ekutanga. Ndiko kuti, masero ematafura epakutanga uye akaiswa ane hurefu hwakasiyana uye upamhi. Kana iwe uchida kuzvifananidza, unogona kushandisa nzira inotevera:

1. Kutanga iwe unoda kuzarura tafura yatinoda kukopa uye kuisarudza. Mushure mezvo tsvaga boka rekushandisa "Clipboard" Tab "Kumba"bhatani riripi "Kopa". Unofanira kubhuya pairi. Mukuwedzera, makiyi anopisa anogona kushandiswa Ctrl + Ckukopa mutsara waunoda wemasero kuclipboard.
   

   

2. Tevere, iwe unofanirwa kudzvanya pasero umo icho chakakopwa chichaiswa. Ndiye achave kona yekumusoro kuruboshwe yetafura yeramangwana. Kuti uise chimedu chaunoda, unofanirwa kudzvanya-kurudyi pachiri. Mune iyo pop-up menyu, iwe unofanirwa kuwana iyo sarudzo "Namira Yakakosha". Asi usadzvanya museve uri padivi pechinhu ichi, nekuti chinovhura mamwe sarudzo, uye iwo haadiwe izvozvi.
   

   

3. Ipapo bhokisi rebhokisi rinobuda, unofanirwa kutsvaga boka “Isert”pane chinhu chacho "Column Width", wobaya bhatani reredhiyo riri pedyo nayo. Mushure mekusarudza, unogona kusimbisa zviito zvako nekudzvanya "OK".
   

   

4. Zvadaro zviyero zvehukuru hwesero zvinoshandurwa kuitira kuti kukosha kwavo kufanane neiyo mutafura yepakutanga.
   

   

5. Ndizvozvo, zvino zvinogoneka kunamira mutsara uyu mune rimwe gwaro kana pepa kuitira kuti saizi yemaseru ayo ienderane negwaro rekutanga. Ichi chigumisiro chinogona kuwanikwa nenzira dzakawanda. Iwe unogona kudzvanya-kurudyi pane sero inova yekutanga sero yetafura - iyo yakakopwa kubva kune imwe sosi. Ipapo menyu yemukati ichaonekwa, uye ipapo iwe unofanirwa kuwana chinhu “Isert”. Pane bhatani rakafanana pane tab "Kumba". Asi nzira iri nyore ndeyekudzvanya kiyi musanganiswa Ctrl + V. Kunyangwe zvakanyanya kuoma kurangarira pane kushandisa nzira mbiri dzakapfuura, asi kana yakadzikwa nemusoro, unogona kuchengetedza nguva yakawanda.
   

   

Zvinokurudzirwa kuti udzidze akajairika Excel hotkey mirairo. Sekondi imwe neimwe yebasa haisi nguva yakawedzerwa chete yakachengetedzwa, asiwo mukana wekusaneta.

Ndizvozvo, ikozvino hukuru hwemasero ematafura maviri huchafanana.

Kushandisa Macro Kugadzirisa Upamhi uye Hurefu

Kana iwe kazhinji uchifanirwa kuve nechokwadi chekuti hupamhi uye kukwirira kwemaseru zvakafanana, zviri nani kunyora diki macro. Kuti uite izvi, unofanirwa kugadzirisa zvivakwa uchishandisa VBA mutauro. RowHeight и ColumnWidth.

Kana tichitaura nezve dzidziso, ipapo kugadzirisa urefu uye hupamhi hwesero, unofanirwa kudzora aya mutsara uye mbiru paramita.

Iyo macro inobvumidza iwe kugadzirisa hurefu chete mumapoinzi, uye hupamhi mumabhii. Hazvibviri kuisa zvikamu zvechiyero chaunoda.

Kuti ugadzirise urefu hwemutsara, shandisa pfuma RowHeight Chinhu -. Somuenzaniso, hongu.

ActiveCell.RowHeight = 10

Pano, kureba kwemutsara uko sero rinoshanda riripo richava 10 points. 

Kana iwe ukaisa mutsara wakadaro mune macro edhita, kureba kwemutsara wechitatu kuchachinja, izvo kwatiri zvichave makumi matatu mapoinzi.

Mitsetse(3).RowHeight = 30

Zvinoenderana nemusoro wenyaya yedu, iyi ndiyo nzira yaunokwanisa kushandura kureba kwesero maseru anosanganisirwa mune imwe mhando:

Range(«A1:D6»).RowHeight = 20

Uye seizvi - chikamu chose:

Columns(5).RowHeight = 15

Nhamba yekoramu inopiwa mumaparenthesi. Izvo zvakafanana netambo - nhamba yetambo inopiwa mumabhuraketi, iyo yakaenzana netsamba yealfabheti inoenderana nenhamba.

Kugadzirisa hupamhi hwembiru, shandisa pfuma ColumnWidth Chinhu -. Syntax yakafanana. Ndiko kuti, kwatiri isu, iwe unofanirwa kusarudza pane huwandu hwaunoda kuchinja. Ngaive A1:D6. Uye wobva wanyora mutsara unotevera wekodhi:

Range(«A1:D6»).ColumnWidth = 25

Nekuda kweizvozvo, sero rega rega riri mukati merudzi urwu rine mabhii makumi maviri neshanu paupamhi.

Ndeipi nzira yekusarudza?

Chekutanga pane zvese, iwe unofanirwa kutarisisa pamabasa ayo mushandisi anoda kupedzisa. Kazhinji, zvinokwanisika kugadzirisa hupamhi uye kureba kwesero chero ripi zvaro uchishandisa zvigadziriso zvemanyore kusvika ku pixel. Iyi nzira yakanakira pakuti zvinokwanisika kugadzirisa iyo chaiyo hupamhi-kusvika-kureba reshiyo yega yega maseru. Izvo zvakashata ndezvekuti zvinotora nguva yakawanda. Mushure mezvose, unofanira kutanga wafambisa mutsara wembeva pamusoro peribhoni, wobva waisa kureba zvakasiyana nekhibhodi, zvakasiyana nehupamhi, chengetedza bhatani re "OK". Zvose izvi zvinotora nguva.

Nekudaro, iyo yechipiri nzira ine gadziriso yemanyorero yakananga kubva kune yekubatanidza mapaneru ndiyo yakanyanya nyore. Iwe unogona chaizvo mumakonzo maviri kudzvanya gadzira iyo saizi marongero eese maseru epepa kana chidimbu chakati chegwaro.

A macro, kune rumwe rutivi, isarudzo yakazara otomatiki iyo inokutendera kuti ugadzirise maseru paramita nekungodzvanya kushoma. Asi zvinoda hunyanzvi hwekugadzira, kunyangwe zvisina kuoma kuibata kana zvasvika kumapurogiramu akareruka.

mhedziso

Nokudaro, kune nzira dzakasiyana-siyana dzekugadzirisa hupamhi uye urefu hwemasero, imwe neimwe inokodzera mamwe mabasa. Nekuda kweizvozvo, tafura inogona kunakidza kutarisa uye kugadzikana kuverenga. Chaizvoizvo, izvi zvese zvinoitirwa izvi. Kupfupisa ruzivo rwakawanikwa, tinowana nzira dzinotevera:

1. Kugadzirisa hupamhi nekukwirira kwechikamu chakati chemasero kuburikidza neboka "Masero", iyo inogona kuwanikwa pane tab "Kumba".
2. Kugadzirisa maseru paramita yegwaro rese. Kuti uite izvi, unofanirwa kudzvanya pamubatanidzwa Ctrl + A kana pasero panosangana mbiru ine nhamba dzemitsara uye mutsara une mazita emakoramu emaarufabheti.
3. Manual gadziriso yemasero saizi uchishandisa iyo coordination panel. 
4. Kugadzirisa otomatiki kwehukuru hwesero kuitira kuti akwane chimedu chakakopwa. Pano vakagadzirwa saizi yakafanana netafura yakakopwa kubva kune rimwe pepa kana bhuku rebasa.

Kazhinji, hapana chakaoma pamusoro peizvi. Nzira dzese dzakatsanangurwa dzinonzwisisika pane intuitive level. Zvakakwana kuzvishandisa kakawanda kuitira kuti usakwanisa kuzvishandisa iwe pachako, asiwo kudzidzisa mumwe munhu zvakafanana.