Autofit mutsara kureba muExcel nezvirimo. 5 nzira dzekugadzirisa

Paunenge uchishanda muExcel spreadsheet, pane kazhinji nguva apo ruzivo rwuri muchitokisi rwunobuda kunze kwemiganhu. Nokuda kwekuratidzwa kwakarurama, unogona kubvisa ruzivo rusingakoshi kubva muchitokisi, asi iyi inzira isingabatsiri, sezvo inopikira kurasikirwa kwemashoko akakwana. Mhinduro huru ndeyekufambisa sero miganhu kuti ikwane data rese. Muchinyorwa isu tichaongorora akati wandei sarudzo dzekuisa nemazvo urefu hwemutsara otomatiki.

Chii chinonzi kureba kwemutsara muMicrosoft Excel

Kureba kwemutsara ndeimwe yetabular ruzivo paramita. Nokusingaperi, kureba kunokwanisa kukwana zvinyorwa zvakanyorwa mumutsetse mumwe. Kana kupetwa kwemutsara kuchigoneswa, kureba kwekoramu kunowedzera pachayo kuitira kuti ruzivo rwese rwuri musero runyatso kuratidzwa mairi.

Iyo tafura inotaridzika sei usati washandisa autoselection, nekuda kwezvikonzero zvipi zvingave zvichidikanwa

Kuti uwane muenzaniso wemufananidzo, ngatitarisei mamiriro ezvinhu apo kune maseru ane ruzivo rwakakura rwemavara mundiro. Tafura yepakutanga inoita seizvi:

Tinogona kuona zvakajeka kuti kune masero akawanda umo zvinyorwa zvakapinda hazvikodzeri. Mumamiriro ezvinhu aya, mushandisi haakwanisi kuwedzera hupamhi hwemakoroni, sezvo pakudhinda, ndiro yose haingakwanisi papepa repepa. Kuti unyatso kuratidza data rese mairi, unofanirwa kushandisa imwe yenzira dzekusarudza otomatiki urefu hwemutsara. Iwe unogona kuziva nezvese nzira nekuverenga ruzivo rwuri pazasi.

Autofit line urefu

Kugadzirisa otomatiki kwehurefu hwemutsara chishandiso chakakosha chinogadzirisa kureba kwesero rega rega remutsara kusvika pakuzadzwa kwesero rakazadzwa zvakanyanya.. Zvakakosha kuziva kuti hupamhi munyaya iyi hahushanduki. Basa racho rinogadzirisa miganhu, asi mazhinji ekugadzirisa anoitwa akazvimiririra. Pane nzira dzakawanda dzekuita otomatiki kusarudza. Ngatitaure nezvemumwe nemumwe zvakadzama.

Nzira 1: AutoFit Height kuburikidza neSero Format

Iyi ndiyo nzira yekutanga, inodiwa kuti ishandiswe pakuita nzira dzakasara. Kufananidza otomatiki kunongoshanda kumaseru ane kupeta kwemazwi akabatidzwa. Detailed instructions ndeidzi:

1. Kurudyi tinya pane sero kana renji. Mukusiyana kuri kutariswa, tinosarudza tafura yose. A small context menu inoratidzwa. Isu tinowana "Format masero ..." uye tinya pairi LMB.

2. Chiratidziro chicharatidza bhokisi rakanzi Format Cells. Isu tinotamira kune "Alignment" chikamu. Isu tinowana iyo "Ratidza" yekuraira block uye isa cheki bhokisi padivi pe "Putira mameseji" parameter. Mushure mekuita zvese manipulations, tinya "OK".

3. Ready! Mushure mekuita maitiro ese, zviri mukati memasero akasarudzwa zvakaratidzwa zvizere mazviri. Kureba kwemitsetse kwakashanduka nenzira yekuti ruzivo rwese mumasero runoratidzwa zvizere.

Chenjerera! Izvo zvinoitika kuti mumarenji mune iyo mamiriro kune izwi kuputira, asi iyo data haisati yakwana mumaseru, kana, pane zvinopesana, kune yakawanda isina chinhu nzvimbo. Kuti unzwisise nzira yekugadzirisa dambudziko iri, funga nzira dzinotevera.

Nzira 2. Kugadzirisa hurefu kuburikidza nebhari yekubatanidza

Detailed instructions ndeidzi:

1. Isu tinowana iyo yekubatanidza pani yerudzi rwakamira uye tinya pane iyo mutsara nhamba, iyo otomatiki kureba kwatinoronga kugadzirisa. Mushure mekusarudza mutsara, inofanira kujekeswa muhuwandu hwayo.

2. Fambisa mutsara we mouse kusvika pasi pemutsara wakasarudzwa. Chinongedzo chichatora chimiro chemiseve miviri inonongedza kumativi akasiyana. Dzvanya LMB kaviri.

3. Ready! Mushure mekuita maitiro aya, kureba kwemutsara wakasarudzwa kwakashanduka otomatiki kuitira kuti masero ese akwane ruzivo rwurimo. Miganhu yemakoramu haina kuchinja chero nzira.

Method 3: Autofit Urefu kune Multiple Row

Nzira iri pamusoro haina kukodzera kana uchishanda nehuwandu hwemashoko, sezvo zvichatora nguva yakawanda kuti usarudze mutsara wega wega weplate. Pane imwe nzira inochengetedza nguva yakawanda. Detailed instructions ndeidzi:

1. Zvakare tinowana iyo coordination panel yemhando yakatwasuka. Iye zvino tinosarudza kwete mutsara mumwe chete, asi zvose kamwechete, ukuru hwatinoronga kuchinja.

2. Sezvakangoita mushanduro yapfuura, tinya kaviri LMB pane nhamba yemutsara kusvikira chinongedzo chatora chimiro chemiseve miviri inonongedza kwakapesana. Iyi nzira ichakubvumidza iwe kuita otomatiki urefu hwekusarudza.

3. Ready! Isu takaita hurefu hwakakodzera hwemutsara wega wega wakasarudzwa, uye ikozvino ruzivo rwese rwakanyatsoratidzwa mumaseru akasarudzwa.

Nzira 4: Shandisa maturusi ari paribhoni

Mazhinji emabasa anobatsira espredishiti processor ari pamusoro peiyo interface pane yakakosha mudziyo ribhoni. Pane chinhu chakakosha pano chinokutendera kuti uite otomatiki kureba kusarudzwa. Detailed instructions ndeidzi:

1. Isu tinoita sarudzo yenzvimbo, iyo otomatiki sarudzo yehurefu hwatinoronga kugadzira.

2. Isu tinotamira kune chikamu chinonzi "Kumba", chiri pamusoro peiyo spreadsheet interface. Isu tinowana block yemirairo "Masero" uye sarudza chinhu "Format". Muchinyorwa chekudonhedza, tsvaga bhatani "Auto-fit line urefu" uye tinya pairi.

3. Ready! Isu takaita hurefu hwakakodzera hwemutsara wega wega wakasarudzwa uye ikozvino ruzivo rwese rwakanyatsoratidzwa mumaseru akasarudzwa.

Method 5: Gadzirisa kureba kwemasero akabatanidzwa

Basa rakakosha iro rinokutendera kuti ushandise otomatiki kusarudzwa kwemarefu emutsara haigone kuiswa kumaseru emhando yakabatanidzwa. Chero zvazvingaitika, pane mamwe maficha muspredishiti anobvumidza iwe kuita iyi nzira.

Zvinoreva nzira iyi ndezvekuti isu hatizoite maitiro ekubatanidza maseru, asi kungoita chimiro chekubatanidza maseru, izvo zvinotitendera kushandisa otomatiki sarudzo. Detailed instructions ndeidzi:

1. Pakutanga, tinoita sarudzo yemasero aya atinoda kuita maitiro ekubatanidza.

2. Kurudyi tinya panzvimbo yakasarudzwa. Menyu yezvinyorwa inoratidzwa pachiratidziri. Isu tinowana chinhu chinonzi "Format Cells ..." uye tinya pachiri neLMB.

3. Hwindo reFormat Cells rakaonekwa pachiratidziro. Kuenderera mberi kune "Alignment" chikamu. Wedzera iyo yekutanga runyorwa uye tinya pane zvakanyorwa "Centered sarudzo". Mushure mekuita zvese manipulations, tinya pakanzi "OK".

4. Ruzivo rwuri musero rekutanga runoratidzwa pakati pemasero akasarudzwa. Zvinofanira kucherechedzwa kuti hapana kubatanidzwa kwakaitika. Isu takangogadzira chimiro chemubatanidzwa.

5. Padanho rekupedzisira, tinoshandisa basa rekusarudza otomatiki yehurefu hwemutsara tichishandisa imwe yenzira dzinotsanangurwa pamusoro apa.

6. Ready! Isu takaita hurefu hwakakodzera hwemutsara wega wega wakasarudzwa, uye ikozvino ruzivo rwese rwakanyatsoratidzwa mumaseru akasarudzwa.

Zvakakosha kucherechedza! Yese chiitiko algorithm yakanakira ese ekutanga mavhezheni eExcel spreadsheet processor uye ichangoburwa.

Ngatitarisei muenzaniso mudiki umo isu tinoshandisa ruzivo rwakawanikwa pane otomatiki sarudzo yehurefu hwemutsara. Semuenzaniso, isu tine tafura inotevera, iyo yatinofanira kuunza kune chaiyo kuratidzwa pane pepa rebasa:

Chinangwa chedu: kuita iyo chaiyo kuratidzwa kwedata mundiro mumutsara mumwe. Detailed instructions ndeidzi:

1. Tichishandisa kiyi yekubatanidza pane keyboard "CTRL + A" tinosarudza ese maitiro.
2. Kureba kwemutsara kwakashanduka kuitira kuti data ikozvino ionekwe mumutsara mumwe. Zvimwe zvemashoko hazvionekwe. Isu tinofanirwa kuve nechokwadi chekuti data rese rinoratidzwa papepa rekushanda zvizere.

3. Isu tinosarudza makoramu A, B uye C.
4. Fambisa chitubu chembeva kuchikamu chemakoramu A neB uye tinya kaviri LMB.

5. Ready! Chinangwa chapera. Iye zvino ruzivo rwese rwuri mumaseru epepa rebasa rinoratidzwa nenzira kwayo.

Nzira yekuisa mutsara chaiwo urefu?

Kazhinji, vashandisi veExcel spreadsheet vanotarisana nemamiriro ezvinhu apo panofanirwa kuseta iyo chaiyo mutsara kureba kana uchishanda nechero tabular ruzivo. Detailed instructions ndeidzi:

1. Papepa rekushanda, tinosarudza mitsetse inodiwa nebhokisi rekuruboshwe, kureba chaiko kwatinoronga kuisa.
2. Tinya-kurudyi panzvimbo yakasarudzwa yepepa rebasa.
3. Menyu diki yemukati yakaratidzwa pachiratidziri. Isu tinowana chinhu chinonzi "Row Height" uye tinya pairi neLMB.
4. Hwindo rakanzi "Row Height" rakaonekwa pachiratidziri. Mundima yekupinza, tinotyaira mumutsara urefu watinoda mumapoinzi. Mapoinzi matatu - ingangoita mirimita imwe.
5. Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK" riri pazasi pehwindo.

6. Ready! Isu takaita chiratidzo chehurefu chaihwo hwemutsara muExcel spreadsheet.

Rangarira! Iyo yakasarudzika mutsara urefu ndeye 12.75 pixels.  

Kana zvisingagoneke kuenderana neatomatiki urefu hwemutsara

Kune mamiriro ezvinhu asingafadzi kana nzira dzose dziri pamusoro dzisingabvumiri kusarudzwa kweotomatiki yehurefu hwemutsara. Kazhinji kazhinji, chikonzero chekushanda kwakashata kwebasa racho ndechekuti mushandisi akabatanidza nhamba yemasero pamwechete.

Ramba uchifunga kuti kureba kwemutsara otomatiki hakushandi kumaseru akabatanidzwa. Panyaya yekubatanidza maseru, zvichave zvakafanira kuita maitiro ekusarudza iyo yakakwana parameter yakazvimirira. Pane nzira mbiri dzekugadzirisa dambudziko iri:

1. Kutambanudza miganhu nemaoko nekubata LMB.
2. Shandisa iyo chaiyo stitch urefu basa.

Chero zvazvingava, zvakanyanya kukodzera kusashandisa sero kubatanidza, asi kushandisa "kuonekwa" kwekubatanidza. Izvi zvinokutendera kuti ushandise otomatiki kusarudzwa kweurefu hwemutsara muspredishiti Excel.

mhedziso

Sezvatinoona, kune nzira dzakasiyana siyana dzekushandisa iyo otomatiki urefu hwekusarudza maitiro muExcel spreadsheet processor. Sarudzo inokubvumira kuti uise hurefu hwemutsara wega wega wakasiyana wakanakira kushanda ne data shoma. Kuti ushande nematafura makuru, unofanirwa kubhadhara kune dzimwe nzira. Nhamba huru ye otomatiki nzira dzekusarudza inobvumira mushandisi wega wega kusarudza imwe iri nyore sarudzo ivo pachavo.