7 Nzira dzekuwedzera Masero muExcel

Paunenge uchishandisa Microsoft Excel spreadsheet, dzimwe nguva pane dzimwe nguva apo kukosha kwakapinda hakuenderane neyakajairwa sero saizi. Nokudaro, zvakakosha kukwanisa kuwedzera miganhu yesero kuitira kuti ruzivo rwese rwakapinda runyatsoratidzwa mugwaro. Ichi chinyorwa chichatarisa nzira nomwe dzekusundira miganhu.

Extension procedure

Kune huwandu hukuru hwenzira dzekuwedzera miganhu yezvikamu. Iwe unogona kuwedzera chikamu kana huwandu hwemaseru iwe pachako kana nekushandisa akasiyana siyana otomatiki mabasa aripo muspredishiti.

Nzira 1: Manual Border Shift

Kuwedzeredza kwemabhodha nemaoko ndiyo nzira iri nyore uye iri nyore. Izvi zvinoitwa nekudyidzana nezviyero zvakati chechetere uye zvakadzikama zvekoroni nemitsetse. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoseta mbeva cursor kudivi rekurudyi rechikamu pane mutongi weiyo yakatwasuka mhando yekoramu yatinoda kuwedzera. Paunenge uchiyangarara pamusoro pemuganhu uyu, cursor inotora chimiro chemuchinjikwa ine miseve miviri inonongedza kwakasiyana. Nekubata bhatani rekuruboshwe rembeva tinofambisa muganhu kuenda kudivi rerudyi, kureva zvishoma kupfuura pakati pesero isu tiri kuwedzera.

2. Zviito zvakafanana zvinoshandiswa kuwedzera mitsetse. Iwe unongoda kuisa cursor pazasi pemutsara waunoda kuwedzera, uyezve nekubata bhatani rekuruboshwe dhonza muganho kusvika pamwero uri pazasi.

Zvinokosha! Kana iwe ukaisa chisungo kwete kurudyi, asi kuruboshwe rworuboshwe (kwete pasi, asi nechepamusoro pemutsara) uye kuita nzira yekuwedzera, ipapo zvikamu hazvizoshanduki muhukuru. Pachave nekuchinja kwakajairika kudivi nekugadzirisa zviyero zvezvikamu zvasara zvebepa.

Method 2: Wedzera Miganhu Yemitsetse Yakawanda kana Makoramu

Iyi nzira inokubvumira kuti uwedzere makoramu akawanda nemitsara panguva imwe chete. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoita sarudzo yezvikamu zvakati wandei kamwechete pane mutongi weakatwasuka uye akachinjika coordination.

2. Isu tinoisa cursor kudivi rekurudyi rekurudyi sero kana padivi rezasi rechikamu chiri pazasi chaipo. Zvino, nekubata pasi bhatani rekuruboshwe, dhonza museve kurudyi nepasi kuti uwedzere miganhu yetafura.

3. Nekuda kweizvozvo, kwete chete yekupedzisira huwandu hunowedzera, asiwo ukuru hwese zvachose zvikamu zvenzvimbo yekusarudza.

Method 3: kutsanangura iyo chaiyo sero size

Nerubatsiro rwekuzvipinza kwenhamba data mune yakakosha fomu, unogona kugadzirisa saizi yemiganhu yemaseru egwaro muExcel spreadsheet processor. Nekutadza, chirongwa chine saizi yehupamhi hwe8,43 uye hurefu hwe12,75. Unogona kuwedzera hupamhi kusvika 255 mayunitsi uye kureba kusvika 409 mayunitsi.  Nhanho-ne-nhanho tutori inoita seizvi:

1. Kugadzirisa sero hupamhi hwezvivakwa, sarudza mutsara waunoda pachiyero chakachinjika. Mushure mekusarudza, tinya-kurudyi pane renji. Menyu yemamiriro ekunze inoonekwa pachiratidziri, maunoda kusarudza chinhu "Column wide ...".

2. Iwindo rakakosha rinoonekwa pachiratidziro umo iwe unofanirwa kuseta yaunoda column upamhi. Isu tinotyaira mumutengo wenhamba tichishandisa keyboard uye tinya "OK".

Iyo imwechete nzira inoshandisa kugadzirisa urefu hwemitsara. Iyo yekufamba inotaridzika seiyi:

1. Sarudza sero kana mutsara wemaseru mumhando yakatwasuka coordinate scale. Tinya kurudyi panzvimbo iyi. Mumenu yemukati inooneka, tinya pane chinhu "Row urefu ...".

2. Hwindo diki rinoonekwa pachiratidziri. Muhwindo iri, iwe unofanirwa kuisa zviratidzo zvitsva zvehurefu hwezvikamu zvemhando yakasarudzwa. Mushure mekuita zvese zvigadziriso, tinya "OK".

Iwo akapinzwa manhamba kukosha anoona kuwedzera kwehurefu uye hupamhi hwezvikamu.

Vazhinji vashandisi havagutsikane nehurongwa hunoshandiswa muspredishiti processor kuratidza saizi yemasero epepa mumayuniti anoratidzwa muhuwandu hwemavara. Mushandisi anogona kushandura chiyero chekuyera kune imwe chero nguva. Iyo yekufamba inotaridzika seiyi:

1. Isu tinotamira kuchikamu che "Faira" uye tinya pane "Options" chinhu, icho chiri kuruboshwe rwehwindo.
2. Iwindo rekusarudza rinoonekwa pahwindo. Iwe unofanirwa kuterera kuruboshwe, pano iwe unofanirwa kudzvanya pane "Advanced" tab.
3. Pazasi isu tiri kutsvaga dhizaini yezvigadziriso inonzi "Screen".
4. Pano tinowana kunyorwa kwe "Units pamutongi." Isu tinovhura rondedzero uye tinosarudza iyo yakanyatsokodzera unit yekuyera isu pachedu. Kune zvikamu zvakadai semasentimita, millimeters uye inches.
5. Mushure mekuita sarudzo, unofanirwa kudzvanya pakanzi "OK" kuti shanduko dziite.
6. Ready! Iye zvino unogona kuita shanduko yehukuru hwesero mumayuniti anonyanya kukubatsira.

Kana musero respredishiti Microsoft Excel zviratidzo (#######) zvinoratidzwa, zvinoreva kuti koramu haina kukwana upamhi zviratidzo kuratidza zvakarurama zviri mukati sero. Kuwedzera miganhu kunobatsira kudzivirira chikanganiso ichi chakashata.

Nzira 4: Ribhoni Zvishandiso

PaMicrosoft Excel spreadsheet tool ribhoni, pane bhatani rakakosha rinokutendera kuti ugadzirise saizi yemabhodha esero. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza sero kana huwandu hwesero, kukosha kwatinoda kugadzirisa.

2. Isu tinotamira kune "Kumba" chikamu.
3. Dzvanya pane "Format" chinhu, chiri paribhoni yezvishandiso mubhuroka inonzi "Masero". Rondedzero yezvinogoneka shanduko inoratidzwa pachiratidziri.
4. Tinoda zvinhu zvakaita se "Column width ..." uye "Row urefu ...". Nekudzvanya pane chimwe nechimwe chezvinhu, tinopinda mune zvidiki zvigadziriso windows, izvo zvakatokurukurwa mumirairo iri pamusoro.
5. Mumabhokisi ekugadzirisa saizi yemiganhu yesero, isa zvinongedzo zvinodikanwa zvehurefu nehupamhi hwenzvimbo yakasarudzwa yezvikamu. Kuti uwedzere miganhu, zvinodikanwa kuti zviratidzo zvitsva zvinounzwa zvive zvakakwirira kudarika zvepakutanga. Tinya bhatani "OK".

6. Ready! Kuwedzerwa kwemiganhu yemasero kwakabudirira.

Method 5: Wedzera Masero Ese ePepa kana Bhuku Rebasa

Kazhinji, vashandisi vespredishiti Microsoft Excel vanoda kuwedzera zvachose maseru ese epepa rebasa kana gwaro rose zvaro. Ngatione kuti tozviita sei. Iyo yekufamba inotaridzika seiyi:

1. Chokutanga pane zvose, tinosarudza masero ose papepa rekushanda. Iko kune yakakosha kiyi musanganiswa Ctrl + A, iyo inokutendera iwe kuti usarudze ipapo zvachose maseru ese epepa. Pane imwe nzira yechipiri yekusarudza pakarepo, iyo inoitwa nekudzvanya pane yekona yekona iri padyo neyakachinjika uye yakatwasuka coordinate scale.

2. Mushure mekunge masarudza maseru ese mune imwe yenzira dziri pamusoro, unofanirwa kudzvanya pane chinhu chatinoziva chinonzi "Format", chiri patoolbar ye "Sero" block.
3. Isu tinoisa nhamba dzenhamba muzvinhu "Row urefu ..." uye "Column wide" nenzira imwechete senge mune mirairo iri pamusoro.

Nemaitiro akafanana manipulations, unogona kuwedzera saizi yezvikamu zvegwaro rese. Pane misiyano midiki chete mune algorithm yezviito. Iyo yekufamba inotaridzika seiyi:

1. Pazasi peMicrosoft Excel spreadsheet, pamusoro pebhawa yemamiriro, pane zvinyorwa mapepa mapepa. Iwe unofanirwa kudzvanya-kurudyi pane chero mapfupi. Menyu yemamiriro ezvinhu inooneka, iyo yaunoda kudzvanya pane chinhu "Sarudza ese mapepa".

2. Kusarudzwa kwemapepa ese kwakabudirira. Iye zvino inoramba ichibatsirwa neanozivikanwa "Format" chinhu chekushandura saizi yemasero egwaro rese. Kugadzirisa kunoitwa nenzira imwechete sezviri mumirairo iri pamusoro.

Method 6: AutoFit Cell Height uye Width kune Content

Iyi nzira inowanzoshandiswa kugadzirisa pakarepo ukuru hwemasero, kazhinji pakuwedzera. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoisa iyo mbeva cursor pane yakatwasuka coordination chiyero kumuganhu wekurudyi wekoramu, kukosha kwatinoronga kuchinja otomatiki. Mushure mekunge cursor yatora chimiro chemuchinjikwa nemiseve mumativi akasiyana, tinya kaviri bhatani rekuruboshwe.

2. Upamhi hwembiru hunozoenderana nechikamu chine nhamba huru yemabhii.
3. Uku kunyengedza kunogona kuitwa pakarepo maererano nenhamba huru yemakoramu. Iwe unongoda kuzvisarudza pane iyo coordination panel, uye wobva wadzvanya kaviri pamuganho wekurudyi wechero zvinhu zvinosanganisirwa munzvimbo yakasarudzwa.

4. Iwo manipulations mamwe chete anogona kushandiswa kuita otomatiki kusarudzwa kwemarefu emutsara. Iwe unongoda kusarudza chimwe chete kana huwandu hwezvinhu pane yakatwasuka coordination panel, wobva wadzvanya kaviri pamuganho wepazasi wemutsara (kana muganho wepasi wesero chero) inosanganisirwa munzvimbo yakasarudzwa.

Method 7: Gadzirisa Zviri mukati kusvika Column Width

Iyo inotevera nzira iri pasi pekutariswa haigone kunzi yakazara-yakazara kuwedzera kwehukuru hwezvikamu, inosanganisira otomatiki kuderedzwa kwemavara mavara kune hukuru hwakakodzera hukuru hwemasero. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoita sarudzo yehuwandu hwemasero kwatinoda kushandisa maparameter e otomatiki kusarudzwa kwehupamhi. Tinya-kurudyi panzvimbo yakasarudzwa. Menyu yezvinyorwa inoonekwa pachiratidziri. Dzvanya pane "Format Cells..." chinhu.

2. Hwindo rekufomatidza rabuda. Tinoenda kune chikamu chinonzi "Alignment". Mu "Display" parameter block, tarisa bhokisi riri padyo ne "AutoFit Width" chinhu. Isu tinowana chinhu "OK" pazasi pehwindo uye tinya pairi.

3. Mushure mekuita manipulations ari pamusoro, ruzivo rwakapinda mumaseru runodzikira kuti rukwane muchikamu.

Zvinokosha! Kana paine ruzivo rwakawanda rwakataipa musero riri kuchinjwa, nzira ye auto-sizeing ichaita kuti zvinyorwa zvidiki zvekuti risaverengeke. Nokudaro, kana pane zvinyorwa zvakawanda, zvino zviri nani kushandisa dzimwe nzira dzekushandura miganhu yesero. Uyezve, zvinofanirwa kucherechedzwa kuti otomatiki kusarudzwa kunoshanda chete neruzivo rwechinyorwa, saka haigone kushandiswa kune nhamba zviratidzo.

mhedziso

Muspredishiti Microsoft Excel, kune nhamba huru yenzira dzakasiyana dzekugadzirisa saizi kwete chete sero, asi pepa rose uye kunyangwe gwaro, kuitira kuti chero munhu azvisarudzire yakanakira sarudzo kuti aite maitiro ekuwedzera.