Ungakhulisa Kanjani Amaseli Ku-Excel

Imvamisa ngenkathi usebenza ngamatafula, abasebenzisi badinga ukukhulisa amaseli. Kwesinye isikhathi idatha ayibekwa ezintweni zosayizi wamanje futhi kufanele bandise. Imvamisa kuba nesimo esiphindayo lapho, ukuze usindise indawo yokusebenza ephepheni futhi uqinisekise ukuhlanganiswa kokuthumela kolwazi, kuyadingeka ukunciphisa usayizi wamaseli. Sichaza izenzo ongashintsha ngazo usayizi wamaseli we-Excel.

Ukushintsha ububanzi bezinto zeshidi ngokuhudula imingcele kwenzeka kwisimiso esifanayo.

1. Siphatha isikhombisi emngceleni wesokudla somkhakha wekholomu kwiphaneli yokuxhumanisa evundlile lapho itholakala khona. Ngemuva kokuguqula isikhombisi emcibisholo we-bitirectional, senza inkinobho yegundane kwesobunxele kwinkinobho yesobunxele kanye nelungelo lokulunga (uma imingcele idingeka ukucindezela) noma i-Shipleries uma imingcele kufanele incushwe).



2. Lapho ufinyelela inani elamukelekayo lento, esiyishintsha usayizi, vumela inkinobho yegundane.

Uma ufuna ukukhulisa usayizi wezinto eziningi ngasikhathi sinye, khona-ke kulokhu udinga ukugqamisa kuqala imikhakha ehambisanayo kuphaneli ebheke mpo noma evundlile, kuya ngokuthi yini edingekayo ukuze ushintshwe ecaleni elithile: ububanzi noma ukuphakama.

1. Inqubo yokuhlukanisa, zombili izintambo namakholomu cishe afanayo. Uma udinga ukwandisa iseli ngokulandelana, bese uqhafaza inkinobho yegundane kwesobunxele emkhakheni wephaneli yokuxhumanisa ehambisanayo lapho kuqala khona okokuqala. Ngemuva kwalokho, ngendlela efanayo chofoza emkhakheni wokugcina, kepha kulokhu ephethe ukhiye we-Shift. Ngakho-ke, yonke imigqa noma amakholomu abiwa phakathi kwale mikhakha.

   

   Uma udinga ukukhetha amaseli athi akekho oseceleni komunye nomunye, khona-ke kuleli cala i-algorithm yesenzo ihlukile. Chofoza inkinobho yegundane kwesobunxele kwenye yemikhakha yekholomu noma izintambo ezizoqokonyiswa. Ngemuva kwalokho, ngokucindezela ukhiye we-CTRL, ubumba kuzo zonke ezinye izinto ezitholakala kwiphaneli yokuxhumanisa ethile ehambelana nezinto ezihlose ukwabiwa. Wonke amakholomu noma imigqa lapho kutholakala khona la maseli, kuzoqokonyiswa.



2. Ngemuva kwalokho, kufanele sishintshe usayizi wamaseli afiselekayo, hambisa imingcele. Khetha umngcele ohambisanayo kwiphaneli yokuxhumanisa futhi, ulinde ukubukeka komcibisholo we-bitirectional, chofoza inkinobho yegundane kwesobunxele. Ngemuva kwalokho hambisa umngcele kwiphaneli yokuxhumanisa ngokuya ngokufanela okudingeka ukwenziwe (ukunweba (ukunweba) ububanzi noma ukuphakama kwezinto zeshidi) njengoba kuchazwe ngokuhlukahluka.



3. Ngemuva kokuthi usayizi ufinyelele inani elifunekayo, vumela igundane. Njengoba ukwazi ukubona, ubukhulu bokungagcini nje komugqa noma ikholomu esishintshile, ngemingcele lapho ukukhohlisa khona, kodwa futhi nazo zonke izinto ezinikezelwe ngaphambili.

Indlela 2: Ukuguqula Inani Ngamagama Amanani

Manje ake uthole ukuthi ungashintsha kanjani usayizi wezinto zeshidi ngokusetha njengenkulumo ethile yezinombolo enkundleni eyenzelwe ngqo lezi zinhloso.

Ku-Excel ngokuzenzakalelayo, usayizi wezinto zeshidi usethwe kumayunithi akhethekile wokulinganisa. Iyunithi elilodwa elinjalo lilingana nophawu olulodwa. Ngokuzenzakalelayo, ububanzi beseli bungu-8.43. Lokho wukuthi, engxenyeni ebonakalayo yento eyodwa eshidi, uma kungandisiwe, ungafaka izinhlamvu ezingaphezu kuka-8. Ububanzi obuphezulu bungama-255. Inani elikhulu lezinhlamvu esitokisini lizohluleka. Ububanzi obuncane buyi-zero. Isici esinalo usayizi sifihliwe.

Ukuphakama komugqa okuzenzakalelayo kungamaphuzu ayi-15. Usayizi wayo ungahluka kusuka kumaphuzu angama-0 kuye kwangama-40.

1. Ukuze ushintshe ukuphakama kwento yamaqabunga, ukhethe. Ngemuva kwalokho, ukutholakala kuthebhu "Yasekhaya", ubumba kwicon "format", elitholakala etheyipini eqenjini "amaseli". Ukusuka ohlwini olwehliswayo, khetha inketho "Line Height".



2. Iwindi elincane livula ngensimu "line Height". Kulapha lapho kufanele sibuze inani elifunekayo kumaphoyinti. Senza isenzo nobumba enkombeni ethi "KULUNGILE".



3. Ngemuva kwalokhu, ukuphakama komugqa lapho into yamaqabunga ezinikezele ishintshelwa khona kunani elishiwo kumaphoyinti.

Cishe indlela efanayo ungashintsha ububanzi bekholomu.

1. Khetha into eshidi lapho ububanzi kufanele bushintshwe khona. Ngemuva kokuhlala kuthebhu "Yasekhaya", chofoza inkinobho ethi "format". Kumenyu evula, khetha inketho "Ububanzi bekholomu ...".



2. Kukhona iwindi elifanayo elifanayo kulowo esiwabonile ecaleni langaphambilini. Lapha, ensimini, udinga ukucacisa inani ngamayunithi akhethekile, kepha kulokhu kuphela kuzokhombisa ububanzi bekholomu. Ngemuva kokwenza lezi zenzo, cindezela inkinobho ethi "Kulungile".



3. Ngemuva kokwenza umsebenzi obekiwe, ububanzi bekholomu, okusho iseli oyidingayo, lizoshintshwa.

Kukhona enye inketho yokushintsha usayizi wephepha ngokubeka inani elicacisiwe ekukhulumeni kwamanani.

1. Ukuze wenze lokhu, khetha ikholomu noma intambo lapho iseli olufunayo litholakala khona, kuya ngokuthi ufuna ukushintsha ini: ububanzi nokuphakama nokuphakama. Ukukhethwa kwenziwa ngephaneli yokuxhumanisa usebenzisa lezo zindlela esizibhekele endlebeni 1. Ngemuva kwalokho ubumba ukugqamisa inkinobho yegundane elifanele. Imenyu yomongo icushiwe, lapho udinga khona ukukhetha "ukuphakama komugqa ..." noma "ububanzi bekholomu ...".



2. Iwindi likasayizi liyavula, okwakudingingelwa ngenhla. Idinga ukungena ekuphakameni okufunayo noma ububanzi besitokisi ngendlela efanayo njengoba kuchazwe ngaphambili.

Kodwa-ke, abanye abasebenzisi abasenelisekile ngohlelo lwe-Excel olukhombisa usayizi wezinto zeshidi ezigabeni ezivezwe ngenani lezinhlamvu. Kulaba basebenzisi, kungenzeka ukuthi kungenzeka ukuthi ushintshele kwelinye inani lokulinganisa.

1. Iya kuthebhu ethi "Ifayela" bese ukhetha into "yepharamitha" kumenyu yesobunxele mpo.



2. Iwindi lepharamitha liqala. Imenyu itholakala kwesobunxele sayo. Iya engxenyeni ethi "Ongakukhetha". Ngakwesokunene sewindi kunezilungiselelo ezahlukahlukene. Skrolela phansi umqulu phansi futhi ufuna i- "Screen" Ithuluzi le-Block. Kulesi block, insimu "amayunithi emugqeni" atholakala. Chofoza kuyo futhi kusuka ohlwini olwehliswayo, khetha iyunithi efanelekile yokulinganisa. Kukhona izinketho ezilandelayo:
   • Amasentimitha;
   • Millimeters;
   • Amayintshi;
   • Amayunithi azenzakalelayo.

   Ngemuva kokukhethwa kwenziwa, ngokungena kwezinguquko ngamandla, chofoza inkinobho ethi "KULUNGILE" ezansi kwewindi.

Manje ungaguqula ushintsho ngobukhulu be-cell usebenzisa lezo zinketho ezikhonjiswe ngenhla, usebenze iyunithi ekhethiwe yokulinganisa.

Indlela 3: Yenza kabusha usayizi we-othomathikhi

Kepha, uyabona ukuthi akulula ngokuphelele ukushintsha osayizi amaseli, ukuwaguqula kokuqukethwe okuthile. Ngenhlanhla, i-Excel inikeza amandla okushintsha ngokuzenzakalelayo usayizi wezinto zeshidi, ngokuya ngenani ledatha aqukethe.

1. Khetha iseli noma idatha yeqembu lapho engabekwa khona ekhasini eliqukethe. Kuthebhu "Ikhaya" ubumba kwinkinobho ejwayelekile "yefomethi". Kumenyu ehlukanisayo, khetha inketho okufanele isetshenziswe entweni ethile: "umugqa othomathikhi wokuphakama komugqa" noma "ububanzi bekholomu".



2. Ngemuva kokuthi kusetshenziswe ipharamitha ebekiwe, osayizi beseli bazoshintsha ngokuya ngokuqukethwe kwabo, endaweni ekhethiwe.

Isifundo: Umugqa wokuphakama auto autribution on Excel

Njengoba ubona, shintsha usayizi wamaseli ngezindlela eziningi. Bangahlukaniswa ngamaqembu amabili amakhulu: ukudonsa imingcele nokufakwa kosayizi wenombolo kunkambu ekhethekile. Ngaphezu kwalokho, ungabeka ukuphakama noma ububanzi namakholamu.