Kaningi, lapho kusebenza namatafula, abasebenzisi badinga ukukhulisa amaseli. Kwesinye isikhathi imininingwane ayihambelani nezinto ezisayizi wamanje futhi kufanele zinwetshwe. Imvamisa kuba khona isimo esibuyela emuva lapho, ukuze kugcinwe isikhala somsebenzi ephepheni futhi kuqinisekiswe ukubumbeka kokubekwa kolwazi, kuyadingeka ukunciphisa usayizi wamaseli. Sichaza ngezenzo ongashintsha ngazo usayizi wamaseli e-Excel.
Funda futhi: Ungayandisa kanjani iseli e-Excel
Izinketho zokushintsha inani lezakhi zeshidi
Kufanele kuqashelwe zisuka nje ukuthi ngenxa yezizathu zemvelo, ukushintsha usayizi weseli elilodwa kuphela ngeke kusebenze. Ngokushintsha ukuphakama kwengxenye eyodwa kweshidi, lapho siguqula ukuphakama kwalo lonke ulayini lapho kutholakala khona. Ukushintsha ububanzi bayo - sishintsha ububanzi bekholomu lapho itholakala. Ngokubanzi, azikho izinketho eziningi zokukhulisa iseli ku-Excel. Lokhu kungenziwa ngokuhudula ngesandla imingcele, noma ngokubeka usayizi othize kwinkulumo yezinombolo usebenzisa ifomu elikhethekile. Ake sifunde ngakunye kwalokhu okukhethwa kukho ngemininingwane eminingi.
Indlela yoku-1: Hudula bese uphonsa imingcele
Ukushintsha usayizi weseli ngokuhudula imingcele kuyindlela elula futhi enembile kunazo zonke.
- Ukuze wenyuse noma wehlise ukuphakama kweseli, sihamba ngomngcele ophansi womkhakha kuphaneli yokuqondisa mpo yomugqa elikuyo. Isikhombisi kufanele siguqule sibe ngumcibisholo okhomba kuzinhlangothi zombili. Senza isiqeshana senkinobho yegundane bese sidonsela isikhombisi phezulu (uma ufuna ukusinciphisa) noma phansi (uma udinga ukusandisa).
- Ngemuva kokuthi ukuphakama kweseli kufinyelele ezingeni elamukelekayo, khipha inkinobho yegundane.
Ukushintsha ububanzi bezinto zeshidi ngokuhudula imingcele kwenzeka ngokuya ngomgomo ofanayo.
- Siphokophela ngaphezulu komngcele ofanele wesigaba sekholamu kuphaneli yokuqondisa evundlile lapho itholakala. Ngemuva kokuguqula ikhesa ibe umcibisholo wokufuna imali, sicindezela inkinobho yegundane kwesobunxele bese siyidonsela ngakwesokudla (uma imingcele kudingeka ihlukaniswe) noma ngakwesobunxele (uma imingcele kufanele incishiswe).
- Lapho usufika ngosayizi owemukelekile wento esikushiyele usayizi, khipha inkinobho yegundane.
Uma ufuna ukukhulisa kabusha izinto eziningana ngasikhathi sinye, khona-ke kuleli cala kufanele uqale ukhethe imikhakha ehambisanayo kupaneli eliqonde mpo noma elivundlile, kuya ngokuthi yini ofuna ukuyishintsha ecaleni elithile: ububanzi noma ukuphakama.
- Inqubo yokukhetha yemigqa emibili namakholomu icishe ifane. Uma udinga ukwandisa amaseli ngokulandelana, bese uchofoza kwesobunxele emkhakheni kupaneli ehambisanayo ehambelana nalo lapho kutholakala owokuqala. Ngemuva kwalokho, chofoza nje emkhakheni wokugcina ngendlela efanayo, kepha kulokhu ubambe ukhiye ngasikhathi sinye I-Shift. Ngakho-ke, kuzogqamiswa yonke imigqa noma amakholamu akhona phakathi kwale mikhakha.
Uma udinga ukukhetha amaseli angahambelani komunye nomunye, khona-ke kulokhu i-algorithm yezenzo ihlukile. Qhafaza kwesobunxele kwenye yezingxenye zekholamu noma umugqa ozokhethwa. Ngemuva kwalokho, ubambe ukhiye phansi Ctrl, chofoza kuzo zonke ezinye izinto ezitholakala kuphaneli ethile yokuxhumanisa ehambelana nezinto ezenzelwe ukukhethwa. Onke amakholomu noma imigqa lapho la maseli etholakala khona kuzoqokonyiswa.
- Ngemuva kwalokho, sidinga ukuhambisa imingcele ukukhulisa amaseli adingekayo. Sikhetha umngcele ohambisanayo kwiphaneli yokuhlanganisa futhi, njengoba sesilinde ukuvela komcibisholo oqondile, sibamba inkinobho yegundane kwesobunxele. Ngemuva kwalokho sihambisa umngcele kuphaneli yokuhlanganisa ngokuhambisana nalokho okudingeka ukwenziwa (ukunwebisa (ukubopha) ububanzi noma ukuphakama kwezinto zeshidi) njengoba kuchazwe enguqulweni ngesilinganiso esisodwa.
- Ngemuva kokuthi usayizi ufinyelele kusayizi oyifunayo, khipha igundane. Njengoba ukwazi ukubona, inani alishintshanga nje kuphela kumugqa noma ikholamu ngemingcele lapho kwenziwa khona inkohliso, kodwa futhi nakuzo zonke izinto ezikhethiwe ngaphambilini.
Indlela 2: shintsha inani ngamanani ezinombolo
Manje ake sibheke ukuthi ungasenza kanjani usayizi wezinto zamakhasi ngokuzibeka ngenkulumo ethile yenombolo enkambu eyenzelwe lezi zinhloso.
Ku-Excel, ngokuzenzakalela, usayizi wezinto zeshidi uchazwa amayunithi akhethekile. Iyunithi elilodwa elinjalo lilingana nohlamvu olulodwa. Ngokuzenzakalelayo, ububanzi beseli bungama-8.43. Okusho ukuthi, engxenyeni ebonakalayo yengxenye eyodwa yephepha, uma ungayikhulisi, ungafaka izinhlamvu ezingaphezulu kwezingu-8. Ububanzi obukhulu bungama-255. Awukwazi ukufaka izinhlamvu eziningi kuseli. Ububanzi obuncane bungama-zero. Into enalesi size ifihliwe.
Ukuphakama komugqa ozenzakalelayo ngamaphuzu ayi-15. Usayizi waso ungahluka kusuka kumaphuzu angama-0 kuye kwangama-409.
- Ukuze ushintshe ukuphakama kwento eshidi, khetha yona. Ngemuva kwalokho, ngihlale kuthebhu "Ikhaya"chofoza isithonjana "Ifomathi"ebhalwe ethepheni eqenjini "Amaseli". Ukusuka ohlwini olwehliswayo, khetha inketho Ukuphakama komugqa.
- Kuvula iwindi elincane ngensimu Ukuphakama komugqa. Yilapho kufanele sibeke khona inani elifunekayo ngamaphoyinti. Yenza isenzo bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalokho, ukuphakama komugqa lapho into ekhethiwe ibekwe kuyo kuzoshintshelwa kunani elishiwo kumaphoyinti.
Cishe ngendlela efanayo, ungashintsha ububanzi bekholomu.
- Khetha into eshidi lapho ushintsha khona ububanzi. Ukuhlala kuthebhu "Ikhaya" chofoza inkinobho "Ifomathi". Kumenyu evulayo, khetha inketho "Ububanzi bekholamu ...".
- Iwindows licishe lifane nelinye livula kulokho esikubonile ecaleni elidlule. Lapha futhi enkundleni udinga ukusetha inani kumayunithi akhethekile, kodwa kulokhu kuphela lapho kuzobonisa ububanzi bekholomu. Ngemuva kokuqeda lezi zinyathelo, chofoza inkinobho "Kulungile".
- Ngemuva kokwenza umsebenzi obekiwe, ububanzi bekholomu, ngakhoke iseli esilidingayo, lizoguqulwa.
Kukhona enye inketho yokukhulisa usayizi wezinto zeshidi ngokuchaza inani elicacisiwe ngamagama ezinombolo.
- Ukuze wenze lokhu, khetha ikholamu noma umugqa lapho iseli elifunekayo litholakala khona, ngokuya ngalokho ofuna ukukushintsha: ububanzi nokuphakama. Ukukhetha kwenziwa ngephaneli yokudidiyela usebenzisa izinketho esicabange ngazo Indlela 1. Bese uqhafaza ekukhethweni ngenkinobho yegundane elifanele. Imenyu yokuqukethwe icushiwe lapho udinga ukukhetha into "Ukuphakama kolayini ..." noma "Ububanzi bekholamu ...".
- Iwindi lesayizi esishiwo ngenhla liyavula. Kuyo udinga ukufaka ukuphakama okufunayo noma ububanzi beseli ngendlela efanayo naleyo echazwe ngaphambilini.
Kodwa-ke, abanye abasebenzisi abaseneliseki ngohlelo lwe-Excel lokucacisa usayizi wezinto zeshidi emaphuzwini, aboniswe ngenombolo yezinhlamvu. Kulaba basebenzisi, kungenzeka ukushintshela kwelinye inani lokulinganisa.
- Iya kuthebhu Ifayela bese ukhetha into "Izinketho" kumenyu mpo yangakwesobunxele.
- Iwindows ongakhetha iqala. Engxenyeni yayo yesinxele imenyu. Iya esigabeni "Kuthuthukile". Ngakwesokunene sewindi kukhona izilungiselelo ezahlukahlukene. Skrolela phansi ibha yokuhambisa bese ubheka ibhokisi lamathuluzi Isikrini. Leli bhokisi liqukethe insimu "Amayunithi kulayini". Siyachofoza kukho futhi ohlwini lokudonsa phansi sikhetha iyunithi efanelekile yesilinganiso. Izinketho zingokulandelayo:
- Amasentimitha
- Amamilimitha
- Amayintshi
- Amayunithi ngokwakhona.
Ngemuva kokuthi ukhetho lwenziwe, ukuze izinguquko ziqale ukusebenza, chofoza inkinobho "Kulungile" phansi kwewindi.
Manje usungashintsha ushintsho ngosayizi wamaseli usebenzisa izinketho eziboniswe ngaphezulu, ngokuya ngeyunithi ekhethiwe lesilinganiso.
Indlela Yesithathu: Khulisa kabusha i-Auto
Kodwa, kumele uvume ukuthi akuyona into elula kakhulu ukukhulisa amaseli ngesandla, ukuwaguqulela kokuqukethwe okuthile. Ngenhlanhla, i-Excel inikeza amandla okushintsha usayizi ngokuzenzakalelayo izinto zeshidi ngokuya ngosayizi wedatha eyiqukethe.
- Khetha iseli noma iqembu lapho idatha ingahambisani nokuthile kweshidi eliqukethe. Kuthebhu "Ikhaya" chofoza inkinobho ojwayelekile "Ifomathi". Kumenyu evulayo, khetha inketho okufanele isetshenziswe entweni ethile: "I-Auto Fit Row Height" noma Auto Fit Ikholomu Ububanzi.
- Ngemuva kokuthi kusetshenziswe ipharamitha ebekiwe, amasayizi weseli azoshintsha ngokuya ngokuqukethwe, ohlangothini olukhethiwe.
Isifundo: I-Auto Fit Row Height ku-Excel
Njengoba ukwazi ukubona, kunezindlela eziningana zokukhulisa usayizi amaseli. Zingahlukaniswa ngamaqembu amakhulu amakhulu: ukudonsela imingcele nokungena ngosayizi wokubala endaweni ekhethekile. Ngaphezu kwalokho, ungabeka ukukhetha okuzenzakalelayo kokuphakama noma ububanzi bemigqa namakholomu.
