Kanjani ukwenza amaseli osayizi ofanayo ku-Excel

Imvamisa, lapho usebenza namatafula we-Excel, kufanele ushintshe osayizi bamaseli. Kuvela ukuthi izakhi zamanani ahlukene zikhona ephepheni. Vele, akuhlali kulungiswa ngezinjongo ezingokoqobo futhi kuvame ukuba nobuhle ngokuvamile awenelisi umsebenzisi. Ngakho-ke, umbuzo uphakama ukuthi ungawenza kanjani amaseli afanayo ngosayizi. Ake sibheke ukuthi zingaqondaniswa kanjani ku-Efpelle.

Usayizi wokuqondanisa

Ukuze uvumelanise ngosayizi wamaseli eshidini, udinga ukuchitha izinqubo ezimbili: shintsha usayizi wamakholomu nemigqa.

Ububanzi bekholomu bungahluka kusuka kumayunithi angama-0 kuye kwangama-255 (8.43 Amaphoyinti asethelwe ngokuzenzakalelayo), ukuphakama kwentambo kusuka kumaphoyinti angu-0 kuye kwangama-40,75). Iphuzu elilodwa lokuphakama lilinganiselwa ku-0.035 centimeters.

Uma ufuna ukukala ukuphakama kanye neyunithi ye-WIDTH, ungangena esikhundleni sezinye izinketho.

1. Ukuba sethebhu "File", chofoza into "yepharamitha".



2. Efasiteleni le-Excel Parameter elivula, senza ukuguqulwa kwento "ethuthukile". Engxenyeni ephakathi yewindi sithola i- "Screen" Parameter Block. Siveza uhlu mayelana "namayunithi kulayini" ipharamitha bese ukhetha okukodwa kwezinketho ezine:
   • Amasentimitha;
   • Amayintshi;
   • Millimeters;
   • Amayunithi (afakwe ngokuzenzakalelayo).

   Ngemuva kokuthi usunqumile ngenani, chofoza inkinobho ethi "Kulungile".

Ngakho-ke, ungabeka isilinganiso lapho umsebenzisi athambekele khona kangcono. Yile yunithi yohlelo ezolungiswa kamuva lapho icacisa ukuphakama kwemigqa nobubanzi bekholomu yedokhumenti.

Indlela 1: Ukuqondanisa kwamaseli webanga elizinikezele

Okokuqala, sizoqonda indlela yokuvumelanisa amaseli obubanzi obuthile, njengethebula.

1. Sigqamisa ububanzi eshidini lapho sihlela ukwenza usayizi wamaseli alingane.



2. Ukuba sethebhu "Yasekhaya", chofoza ku-Icon "ifomethi", ebekwe ku- "Ithuluzi Lamaseli". Uhlu lwezilungiselelo luyavula. Ku-Cell usayizi block, khetha into "umugqa wokuphakama ...".



3. Kuvulwa "umugqa omncane". Singena emkhakheni ofanayo okukuwo, usayizi kumayunithi afisa ukufaka kuyo yonke imigqa yebanga elenzelwe. Bese uchofoza inkinobho ethi "KULUNGILE".



4. Njengoba sibona, usayizi wamaseli webanga elenzelwe ukuphakama selilingana. Manje sizodinga ukukucabanga ngobubanzi. Ukuze wenze lokhu, ngaphandle kokususa ukukhetha, phinda ushayele imenyu ngenkinobho ethi "format format" ethepheni. Lesi sikhathi ku- "Usayizi weseli" Block, khetha ububanzi beClouse "...".



5. Iwindi liqala ngokufanayo njengoba kwenzeka lapho ukuphakama komugqa kunikezwa. Sifaka ububanzi bekholomu kumayunithi asensimini, okuzosetshenziswa ebangeni elizinikezele. Chofoza inkinobho ethi "KULUNGILE".

Njengoba sikwazi ukubona, ngemuva kokuphambanisa kwempahla, amaseli endawo ekhethiwe yaba ngokufana ngosayizi.

Kukhona enye indlela yale ndlela. Ungakhetha kwiphaneli evundlile yokuxhumanisa lezo zekholomu, ububanzi obudingayo ukwenza okufanayo. Bese uchofoza kule phaneli ngenkinobho yegundane efanele. Kumenyu evula, khetha ububanzi be-Clause "...". Emva kwalokho, iwindi livula ukwethula ububanzi bekholomu yebanga elizinikezele, esishilo kancane ngenhla.

Ngokufanayo, sigqamisa izixhumanisi ephaneli elithe mpo yomugqa webanga lapho sifuna ukukhiqiza ukuqondanisa khona. Ngenkinobho yegundane efanele kuphaneli, kumenyu evula, khetha into "umugqa wokuphakama ...". Ngemuva kwalokho, iwindi livuleka lapho kufanele kwenziwe ipharamitha eliphakeme.

Indlela 2: Ukuqondanisa kwamaseli eshidi lonke

Kepha kunezimo lapho kunesidingo lapho kunesidingo sokulinganisa amaseli hhayi nje ububanzi obufunayo, kepha lonke ishidi lilonke. Kubiwe ngesandla ukuzazisa - isifundo eside kakhulu, kepha kungenzeka ukuthi kwabelwe ngokuchofoza okukodwa ngokoqobo.

1. Chofoza kunxande etholakala phakathi kwamaphaneli wokuxhumanisa avundlile futhi mpo. Njengoba ubona, emva kwalokho, lonke ishidi lamanje labelwe ngokuphelele. Kunendlela ehlukile yokugqamisa lonke ishidi. Ukuze wenze lokhu, mane uthole i-CTRL + ikhibhodi kwikhibhodi.



2. Ngemuva kokuthi yonke indawo yephepha igqanyiswe, sishintsha ububanzi bamakholomu nokuphakama kwezintambo ngosayizi owodwa kwi-algorithm efanayo eyachazwa lapho ufunda indlela yokuqala.

Indlela 3: Ukudweba Imingcele

Ngaphezu kwalokho, ukuvumelanisa usayizi wamaseli kungakuhudula ngesandla imingcele.

1. Sigqamisa ishidi lisonke noma uhla lwamaseli kwiphaneli evundlile yokuxhumanisa ngezindlela ezaxoxwa ngenhla. Faka isikhombisi emngceleni wamakholomu kwiphaneli evundlile. Ngasikhathi sinye, esikhundleni sesikhombisi, kuzovela isiphambano lapho kunemicibisholo emibili ehlose izinkomba ezihlukile. Sula inkinobho yegundane kwesobunxele bese udonsa imingcele ngakwesokudla noma ngakwesobunxele kuye ngokuthi sidinga ukuwakhulisa noma sincane. Kulokhu, ububanzi buguqulwa hhayi esitokisini kuphela, nemingcele oyisebenzisa ngayo, kepha wonke amanye amaseli ebanga elenzelwe.

   

   Emva hudula ephelele udedele uyekele inkinobho yegundane, amaseli akhethiwe ububanzi kuyodingeka izilinganiso zobukhulu efanayo ukuthi uvumelane ngokugcwele ububanzi ukuthi zazo manipulation wawenziwa.



2. Uma ungazange ukhethe ishidi, khona-ke ukwaba amaseli phezu mpo Ukudidiyela panel. Ngokufana esigabeni esandulele, hudula imingcele omunye imigqa nge inkinobho clamping igundane kuze lamaseli ngale umugqa esesikwenzile ukuphakama wanelise. Khona-ke uyekele inkinobho yegundane.

   

   Ngemva lezi zenzo, zonke izakhi ze-esikhethiwe kuyodingeka ukuphakama efanayo iseli ngenhla lapho abasetshenziswa.

Indlela 4: Faka Ithebula

Uma ufaka itafula bebhalwe ishidi ngendlela evamile, khona-ke ngokuvamile iningi amakholomu inketho ifakwe kuyodingeka usayizi ezahlukene. Kodwa kukhona reception ezokwenza ukuyigwema.

1. Khetha ithebula ufuna ukukopisha. Chofoza le "Kopisha" uphawu, esemgwaqweni eteyipini kuthebhu Ekhaya kule "Exchange Buffer" block. Ungase futhi esikhundleni lezi zenzo emva Ukukhetha ukudayela CTRL + C ukhiye inhlanganisela on the ikhibhodi.



2. Thina ukugqamisa iseli eshidini esifanayo, kwenye ishidi noma kwenye incwadi. Lokhu cell uzoba elingenhla isici kwesokunxele etafuleni ifakiwe. Chofoza ngakwesokudla into ozinikele. I imenyu yengqikithi livela. Kuyo, uyongena ngalowo "Special Faka ..." lento. Ngo imenyu eyengeziwe, elizovela ngemva kwalokhu, chofoza, futhi, entweni ne ncamashi igama elifanayo.



3. A faka ifasitela ekhethekile liyavuleka. In the izilungiselelo "Faka" vimbela, silungisa inkinobho kuya "ububanzi" isikhundla. Chofoza inkinobho ethi "KULUNGILE".



4. Ngemva kwalokho, indiza ishidi kuzoba iseli yokufaka e usayizi ofanayo nalabo ezibe etafuleni umthombo.

Njengoba ubona, Excel zikhona izindlela eziningana ukusungula usayizi ofanayo cell, kokubili uhla othize noma itafula futhi ishidi iyonke. Into ebaluleke kakhulu lapho kwenziwa lokhu inqubo kahle ukwaba uhla, izilinganiso ofuna ukushintsha futhi asihole ngenani elilodwa. Okufakwa nemingcele kokuphakama nobubanzi amaseli zingahlukaniswa zibe izinhlobo ezimbili: ukubeka value specific amayunithi obonakaliswe izinombolo bese uhudula ibhukwana imingcele. Umsebenzisi ngokwayo ekhetha indlela elula xaxa yesenzo, ku-algorithm alokhu kangcono ngamakhasimende.