Wogwiritsa ntchito aliyense wogwira ntchito ku Excel posachedwa amakumana ndi vuto lomwe zomwe zili mu foni sizili m'malire ake. Pankhaniyi, pali njira zingapo kuchokera pamenepa: kuchepetsa kukula kwa zomwe zili; bwerani ndi zomwe zilipo; kukuza kukula kwa maselo; kukulitsa kutalika kwake. Pafupifupi njira yotsiriza, yomwe ikufanana ndi kutalika kwa mzere, timalankhulanso.
Kusankhidwa kwa Atop
AutoSize ndi chida cholumikizidwa cha Excel chomwe chimakuthandizani kuti mukulitse maselo ndi zomwe muli nazo. Ziyenera kudziwika nthawi yomweyo kuti, ngakhale ndi dzina, ntchitoyi siyingochitika zokha. Kuti muwonjezere chinthu china, muyenera kusankha masanjidwe angapo ndikugwiritsira ntchito chida chomwe mwasankhacho.
Kuphatikiza apo, ziyenera kunenedwa kuti kuphatikiza kwazodziwikiratu kumagwira ntchito ku Excel kokha kwa maselo omwe kukulunga kwa mawu kumathandizidwa pakuwapanga. Kuti mupeze malowa, sankhani khungu kapena mtundu patsamba. Dinani pa kusankha ndi batani la mbewa yoyenera. Pa mndandanda wazomwe zayambitsidwa, sankhani malo "Mtundu wamtundu ...".
Tsamba losintha limayambitsa. Pitani ku tabu Kuphatikiza. Mu makatani "Onetsani" onani bokosi pafupi ndi paramayo Kukutira Kwa Mawu. Kusunga ndi kugwiritsa ntchito kusintha kwa masanjidwewo, dinani batani "Zabwino"yomwe ili pansi pazenera ili.
Tsopano kukulunga kwamawu kumathandizidwa pa chidutswa chosankhidwa cha pepalalo, ndipo mutha kuyika chingwe chachitali kwa iye. Tiyeni tiwone momwe tingachitire izi m'njira zosiyanasiyana pogwiritsa ntchito mtundu wa Excel 2010. Komabe, ziyenera kudziwidwa kuti algorithm yofananira machitidwe ingagwiritsidwe ntchito pazosintha zamtsogolo za pulogalamuyi komanso za Excel 2007.
Njira 1: Kugwirizanitsa Gulu
Njira yoyamba imaphatikizapo kugwira ntchito ndi gulu loyang'anira lomwe maunambala amtundu wa tebulo ali.
- Dinani manambala a mzerewo pa gulu lolumikizana lomwe mukufuna kugwiritsa ntchito auto-urefu. Pambuyo pa izi, mzere wonse udziwonetsedwa.
- Tifika pamalire a mzere m'gawo la oyang'anira. Chopunthira chizikhala ngati muvi woloza mbali ziwiri. Dinani kawiri batani lakumanzere.
- Pambuyo pa izi, pamene m'lifupi mwake sunasinthe, kutalika kwa mzerewo kumangokulira momwe zingafunikire kuti zolemba zonse m'maselo ake onse aziwoneka papepala.
Njira yachiwiri: lolani magalimoto oyenerera kukhala ndi zingwe zingapo
Njira yomwe ili pamwambapa ndiyabwino mukafunikira kuloleza kufanana kwa mzere umodzi kapena awiri, koma bwanji ngati pali zinthu zambiri zofanana? Kupatula apo, ngati mutenga nawo gawo pa algorithm yomwe idafotokozedwa koyambirira, ndiye kuti njirayi idzakhala nthawi yambiri. Pankhaniyi, pali njira yotulukirapo.
- Pagulu logwirizanitsa, sankhani mizere yonse yomwe mukufuna kulumikizana ndi zomwe mukufuna. Kuti muchite izi, gwiritsani batani lamanzere lamanzere ndikusuntha chotembezera pazogwirizana gulu.
Ngati mtunduwo ndi waukulu kwambiri, dinani kumanzere pagawo loyamba, ndiye dinani batani Shift pa kiyibodi ndikudina gawo lotsiriza la gulu logwirizanitsa la malo omwe mukufuna. Poterepa, mizere yake yonse idzafotokozedwa.
- Ikani cholozera pamalire apansi a magawo aliwonse osankhidwa pazogwirizanitsa. Pankhaniyi, cholozera chizitenga mawonekedwe ofanana ndendende ndi nthawi yomaliza. Dinani kawiri batani lakumanzere.
- Pambuyo pochita izi pamwambapa, mizere yonse yamtundu wosankhidwa idzakulitsidwa kutalika ndi kukula kwa deta yosungidwa m'maselo awo.
Phunziro: Momwe mungasankhire maselo mu Excel
Njira 3: batani lazida
Kuphatikiza apo, kuti mupange kusankhidwa kwazokha ndi kutalika kwa maselo, mutha kugwiritsa ntchito chida chapadera pa tepi.
- Sankhani mtundu womwe uli pa pepalalo pomwe mukufuna kusankha kusankha auto. Kukhala mu tabu "Pofikira"dinani batani "Fomu". Chida ichi chili muzilinga. "Maselo". Pamndandanda womwe umawoneka m'gululi "Kukula kwa khungu" sankhani "Auto Fit Row Height".
- Pambuyo pake, mizere yamagulu osankhidwa idzakulitsa kutalika kwawo momwe mungafunikire kuti maselo awo awonetse zonse zomwe zili mkati mwake.
Njira 4: yoyenera maselo ophatikizika
Nthawi yomweyo, ziyenera kukumbukiridwa kuti ntchito yosankha auto siliyophatikiza maselo ophatikizika. Koma pankhaniyi, inenso, pali yankho ku vutoli. Njira yotuluka ndikugwiritsa ntchito algorithm yomwe kuphatikiza ma cell enieni kumachitika, koma kuwoneka kokha. Chifukwa chake, titha kugwiritsa ntchito ukadaulo wa kusankha auto.
- Sankhani maselo omwe amafunika kuphatikiza. Dinani pa kusankha ndi batani la mbewa yoyenera. Pitani pazosankha "Mtundu wamtundu ...".
- Pazenera lopakika lomwe limatseguka, pitani tabu Kuphatikiza. Mu makatani Kuphatikiza m'munda wamtunda "Wowongoka" sankhani mtengo "Kusankhidwa pakati". Masinthidwe atatha, dinani batani "Zabwino".
- Pambuyo pa izi, deta imapezeka kudera lonse logawidwa, ngakhale kuti zimapitilizabe kusungidwa mu foni yakumanzere, popeza kuphatikiza kwa zinthuzo, sizinachitike. Chifukwa chake, ngati, mwachitsanzo, ndikofunikira kuchotsa zolemba, ndiye izi zitha kuchitidwa mu foni yakumanzere. Kenako, sankhani mtundu wonse wa pepalalo. Mwa njira zitatu zomwe zidafotokozeredwa pamwambapa, yatsani luso.
- Monga mukuwonera, pambuyo pa izi, kutalika kwa mzere kunangosankhidwa pomwe kunamizira kophatikizira kwazinthu kunatsalira.
Pofuna kuti musamakhazikitse pamanja mzere aliyense payekhapayekha, kuwononga nthawi yayitali, makamaka ngati tebulo ndilokulirapo, ndibwino kugwiritsa ntchito chida chotere cha Excel ngati auto-fit. Ndi iyo, mutha kusintha mawonekedwe a mizere iliyonse mosiyanasiyana malinga ndi zomwe zili. Vuto lokhalo lingabuke ngati mukugwira ntchito ndi pepala lomwe maselo ophatikizidwawo ali, koma pankhani iyi, inunso mutha kupeza njira yochotsera izi polinganiza zomwe zidalipo ndi zomwe mwasankhazo.
