Ungawenza kanjani amaseli afane ku-Excel

Ngokuvamile lapho usebenza namaspredishithi e-Excel, kuba kudingekile ukuhlela osayizi bamaseli. Kuyadingeka ukwenza lokhu ukuze kulingane lonke ulwazi oludingekayo lapho. Kodwa ngenxa yezinguquko ezinjalo, ukubukeka kwetafula kuwohloka kakhulu. Ukuze uxazulule lesi simo, kuyadingeka ukwenza iseli ngalinye libe nosayizi ofanayo nalo lonke. Manje sizofunda ngokuningiliziwe ukuthi yiziphi izinyathelo okudingeka zithathwe ukuze kuzuzwe lo mgomo.

Ukusetha amayunithi wokulinganisa

Kunamapharamitha amabili ayinhloko ahlobene namaseli futhi abonisa ubukhulu bawo:

1. Ububanzi bekholomu. Ngokuzenzakalelayo, amanani angasukela ku-0 kuye ku-255. Inani elizenzakalelayo ngu-8,43.
2. Ubude bomugqa. Amanani angasukela ku-0 kuye ku-409. Okuzenzakalelayo kungu-15.

Iphuzu ngalinye lilingana no-0,35 mm.

Ngesikhathi esifanayo, kungenzeka ukuhlela amayunithi okulinganisa lapho ububanzi nokuphakama kwamaseli kuzonqunywa. Ukuze wenze lokhu, landela imiyalelo:

1. Thola imenyu ethi "Ifayela" bese uyivula. Kuzoba khona into ethi “Izilungiselelo”. Kumele akhethwe.
   

   

2. Okulandelayo, iwindi lizovela, ohlangothini lwesobunxele lapho kunikezwe khona uhlu. Udinga ukuthola isigaba “Ngaphezu kwalokho” bese uchofoza kukho. Ngakwesokudla kwaleli windi, sifuna iqembu lamapharamitha elibizwa Bonisa. Endabeni yezinguqulo ezindala ze-Excel, izobizwa "Isikrini". Kukhona inketho "Amayunithi asemgqeni", udinga ukuchofoza kunani elisethiwe njengamanje ukuze uvule uhlu lwawo wonke amayunithi okulinganisa atholakalayo. I-Excel isekela okulandelayo – amayintshi, amasentimitha, amamilimitha.
   

   

3. Ngemva kokukhetha inketho oyifunayo, chofoza "KULUNGILE".
   

   

Ngakho-ke, ungakhetha iyunithi yokulinganisa efaneleka kakhulu esimweni esithile. Eminye imingcele izosethwa ngokuvumelana nayo.

Ukuqondanisa Indawo Yeseli - Indlela 1

Le ndlela ikuvumela ukuthi uqondanise osayizi beseli ebangeni elikhethiwe:

1. Khetha ububanzi bamaseli adingekayo.
   

   

2. Vula ithebhu "Ikhaya"liphi iqembu “Amaseli”. Kunenkinobho ezansi kwayo. "Ifomethi". Uma uchofoza kukho, uhlu luzovuleka, lapho emgqeni ophezulu kakhulu kuzoba khona inketho "ubude bomugqa". Udinga ukuchofoza kuso.
   

   

3. Okulandelayo, iwindi elinezinketho zobude bomugqa wesikhathi lizovela. Izinguquko zizokwenziwa kuwo wonke amapharamitha wendawo ekhethiwe. Lapho konke kwenziwa, udinga ukuchofoza "KULUNGILE".
   

   

4. Ngemva kwazo zonke lezi zenzo, kwakungenzeka ukulungisa ukuphakama kwawo wonke amaseli. Kodwa kusele ukulungisa ububanzi bamakholomu. Ukuze wenze lokhu, udinga ukukhetha uhla olufanayo futhi (uma ngesizathu esithile ukukhetha kususiwe) bese uvula imenyu efanayo, kodwa manje sinesithakazelo kunketho. "ububanzi bekholomu". Ingowesithathu ukusuka phezulu.
   

   

5. Okulandelayo, setha inani elidingekayo. Ngemva kwalokho, siqinisekisa izenzo zethu ngokucindezela inkinobho "KULUNGILE".
   

   

6. Hooray, konke sekuphelile manje. Ngemva kokwenza ukukhohlisa okuchazwe ngenhla, wonke amapharamitha kasayizi weseli ayafana kulo lonke ibanga.
   

   

Kodwa lena akuyona ukuphela kwendlela engenzeka yokuqinisekisa ukuthi wonke amaseli anosayizi ofanayo. Ukuze wenze lokhu, ungayilungisa kuphaneli yezixhumanisi:

1. Ukusetha ubude obudingekayo bamaseli, hambisa ikhesa kuphaneli yokuxhumanisa eqondile, lapho ukhetha khona izinombolo zayo yonke imigqa bese ushayela imenyu yokuqukethwe ngokuchofoza kwesokudla kunoma iyiphi iseli yephaneli yokuxhumanisa. Kuzoba khona inketho "ubude bomugqa", okudingeka uchofoze kukho kakade ngenkinobho yesokunxele.
   

   

2. Khona-ke iwindi elifanayo lizovela njengesibonelo sangaphambilini. Sidinga ukukhetha ubude obufanele bese uchofoza "KULUNGILE".
   

   

3. Ububanzi bamakholomu busethwe ngendlela efanayo. Ukuze wenze lokhu, kubalulekile ukukhetha uhla oludingekayo kuphaneli yokuxhumanisa enezingqimba bese uvula imenyu yokuqukethwe, lapho ongakhetha khona inketho. "ububanzi bekholomu".
   

   

4. Okulandelayo, cacisa inani olifunayo bese uchofoza "KULUNGILE".

Ukuqondanisa ishidi lilonke - indlela 2

Kwezinye izimo, kuyadingeka ukuvumelanisa hhayi uhla oluthile, kodwa zonke izakhi. 

1. Ngokwemvelo, asikho isidingo sokuthi wonke amaseli akhethwe ngamanye. Kuyadingeka ukuthola unxande omncane otholakala lapho kuhlangana khona amabha wokuxhumanisa aqondile navundlile. Noma enye inketho isinqamuleli sekhibhodi u-Ctrl + A.
   

   

2. Nansi indlela yokugqamisa amaseli eshidi ngomnyakazo owodwa omuhle. Manje ungasebenzisa indlela 1 ukuze usethe amapharamitha weseli.
   

   

Ukuzilungiselela - indlela yesi-3

Kulesi simo, udinga ukusebenza nemingcele yeseli ngokuqondile. Ukuze usebenzise le ndlela, udinga:

1. Khetha indawo eyodwa noma wonke amaseli eshidi elithile. Ngemva kwalokho, sidinga ukuhambisa ikhesa kunoma yimiphi imingcele yekholomu ngaphakathi kwendawo ekhethiwe. Ngaphezu kwalokho, ikhesa izoba wuphawu oluncane lokuhlanganisa olunemicibisholo eholela ezindleleni ezihlukene. Uma lokhu kwenzeka, ungasebenzisa inkinobho yegundane engakwesokunxele ukuze uguqule indawo yomngcele. Njengoba kukhethwe indawo ehlukile esibonelweni esisichazayo, izinguquko zisetshenziswa kuyo.
   

   

2. Yilokho kuphela, manje wonke amaseli kububanzi obuthile anobubanzi obufanayo. I-mission iphelile, njengoba besho.
   

   

3. Kodwa singabona esithombeni ngenhla ukuthi ukuphakama kusehlukile. Ukuze ulungise leli phutha, udinga ukulungisa usayizi wemigqa ngendlela efanayo ncamashi. Kuyadingeka ukukhetha imigqa ehambisanayo kuphaneli yokuxhumanisa mpo (noma ishidi lonke) futhi ushintshe indawo yemingcele yanoma iyiphi yazo. 17.png
4. Manje sekwenziwe nakanjani. Sikwazile ukwenza isiqiniseko sokuthi wonke amaseli anosayizi ofanayo.

Le ndlela ine-drawback eyodwa - akunakwenzeka ukulungisa kahle ububanzi nobude. Kodwa uma ukunemba okuphezulu akudingekile, kulula kakhulu kunendlela yokuqala.

Kubalulekile! Uma ufuna ukuqinisekisa ukuthi wonke amaseli eshidi anosayizi ofanayo, udinga ukukhetha ngalinye usebenzisa ibhokisi ekhoneni eliphezulu kwesokunxele noma usebenzisa inhlanganisela. Ctrl + A, futhi usethe amanani alungile ngendlela efanayo.

Indlela yokuqondisa imigqa ngemva kokufaka itafula - Indlela yesi-4

Ngokuvamile kwenzeka ukuthi lapho umuntu ezama ukunamathisela itafula ebhodini lokunamathisela, ubona ukuthi ebangeni elinamathiselwe lamaseli, osayizi bawo abahambisani nalawo okuqala. Okusho ukuthi, amaseli amatafula okuqala nafakiwe anobude nobubanzi obuhlukene. Uma ufuna ukuwafanisa, ungasebenzisa le ndlela elandelayo:

1. Okokuqala udinga ukuvula ithebula okudingeka silikopishe bese silikhetha. Ngemuva kwalokho thola iqembu lamathuluzi "Ibhodi lokunamathisela" ithebhu "Ikhaya"iphi inkinobho "Kopisha". Kufanele uchofoze kukho. Ngaphezu kwalokho, okhiye abashisayo bangasetshenziswa Ctrl + Cukukopisha ububanzi obufunekayo bamaseli ebhodini lokunamathisela.
   

   

2. Okulandelayo, kufanele uchofoze kuseli okuzofakwa kulo isiqeshana esikopishiwe. Nguye ozoba ngenhla kwesokunxele setafula lesikhathi esizayo. Ukufaka isiqeshana oyifunayo, udinga ukuchofoza kwesokudla kuso. Kumenyu ye-pop-up, udinga ukuthola inketho "Namathisela Okukhethekile". Kodwa ungachofozi umcibisholo oseduze kwale nto, ngoba izovula izinketho ezengeziwe, futhi azidingeki okwamanje.
   

   

3. Bese kuvela ibhokisi lengxoxo, udinga ukuthola iqembu "Faka"lapho into ikhona “Ububanzi Bekholomu”, bese uchofoza inkinobho yomsakazo eduze kwayo. Ngemva kokuyikhetha, ungaqinisekisa izenzo zakho ngokucindezela "KULUNGILE".
   

   

4. Khona-ke amapharamitha kasayizi weseli ayashintshwa ukuze inani lawo lifane nalelo kuthebula lokuqala.
   

   

5. Yilokho nje, manje usungakwazi ukunamathisela lobu bubanzi kwenye idokhumenti noma ishidi ukuze usayizi wamaseli awo afane nedokhumenti yokuqala. Lo mphumela ungafinyelelwa ngezindlela eziningana. Ungakwazi ukuchofoza kwesokudla kuseli ezoba iseli yokuqala yethebula - leyo ekopishwe komunye umthombo. Bese kuvela imenyu yokuqukethwe, futhi lapho udinga ukuthola into "Faka". Kunenkinobho efanayo kuthebhu "Ikhaya". Kodwa indlela elula ukucindezela inhlanganisela yokhiye Ctrl + V. Nakuba kunzima kakhulu ukukhumbula kunokusebenzisa izindlela ezimbili ezedlule, kodwa uma ubambe ngekhanda, ungagcina isikhathi esiningi.
   

   

Kunconywa kakhulu ukufunda imiyalo evame kakhulu ye-Excel hotkey. Njalo umzuzwana owodwa womsebenzi awugcini nje isikhathi esengeziwe esilondoloziwe, kodwa futhi nethuba lokukhathala kancane.

Yilokho, manje osayizi beseli bamatafula amabili bazofana.

Ukusebenzisa iMacro ukuhlela Ububanzi nobude

Uma ngokuvamile kufanele uqiniseke ukuthi ububanzi nokuphakama kwamaseli kuyafana, kungcono ukubhala i-macro encane. Ukuze wenze lokhu, udinga ukuhlela amanani ezakhiwo usebenzisa ulimi lwe-VBA. I-RowHeight и Ububanzi bekholomu.

Uma sikhuluma ngethiyori, bese uhlela ubude nobubanzi beseli, udinga ukulawula le mingcele yomugqa nekholomu.

I-macro ikuvumela ukuthi ulungise ukuphakama kuphela ngamaphoyinti, nobubanzi ngezinhlamvu. Akwenzeki ukusetha amayunithi okulinganisa owadingayo.

Ukuze ulungise ubude bomugqa, sebenzisa isakhiwo I-RowHeight into -. Ngokwesibonelo, yebo.

I-ActiveCell.RowHeight = 10

Lapha, ukuphakama komugqa lapho iseli elisebenzayo likhona kuzoba amaphuzu ayi-10. 

Uma ufaka umugqa onjalo kumhleli we-macro, ukuphakama komugqa wesithathu kuzoshintsha, okuyinto kithi kuyoba amaphuzu angu-30.

Imigqa(3).RowHeight = 30

Ngokwesihloko sethu, nansi indlela ongashintsha ngayo ubude bawo wonke amaseli afakwe ebangeni elithile:

Ibanga(«A1:D6»).RowHeight = 20

Futhi kanje - ikholomu yonke:

Amakholomu(5).RowHeight = 15

Inombolo yekholomu inikezwe kubakaki. Kuyafana nezintambo - inombolo yentambo inikezwa kubakaki, elilingana nohlamvu lwezinhlamvu oluhambisana nenombolo.

Ukuze uhlele ububanzi bekholomu, sebenzisa isakhiwo Ububanzi bekholomu into -. I-syntax iyafana. Okusho ukuthi, esimweni sethu, udinga ukunquma ngebanga ofuna ukulishintsha. Makube ngu-A1:D6. Bese ubhala umugqa wekhodi olandelayo:

Ububanzi(«A1:D6»).Ububanzi bekholomu = 25

Njengomphumela, iseli ngalinye ngaphakathi kwalolu banga linezinhlamvu ezingu-25 ububanzi.

Iyiphi indlela yokukhetha?

Okokuqala, udinga ukugxila emisebenzini okumele umsebenzisi ayiqedele. Ngokuvamile, kungenzeka ukulungisa ububanzi nobude banoma iyiphi iseli usebenzisa ukulungisa okwenziwa ngesandla kuze kufike kuphikseli. Le ndlela ifanelekile ngoba kungenzeka ukulungisa isilinganiso esiqondile sobubanzi nobude beseli ngalinye. Ububi ukuthi kuthatha isikhathi esengeziwe. Ngemuva kwakho konke, kufanele uqale ususe ikhesa yegundane phezu kweribhoni, bese ufaka ukuphakama ngokwehlukana nekhibhodi, ngokwehlukana ububanzi, cindezela inkinobho ethi "KULUNGILE". Konke lokhu kuthatha isikhathi.

Ngokulandelayo, indlela yesibili enokulungiswa ngesandla ngokuqondile kusuka kuphaneli yokuxhumanisa ilula kakhulu. Ngokuchofoza okubili ungakwazi ukwenza izilungiselelo zosayizi ezifanele kuwo wonke amaseli eshidi noma ingxenye ethile yedokhumenti.

I-macro, ngakolunye uhlangothi, inketho ezenzakalelayo evumela ukuthi uhlele amapharamitha weselula ngokuchofoza okumbalwa nje. Kodwa kudinga amakhono okuhlela, nakuba akunzima kangako ukukwazi kahle uma kuziwa ezinhlelweni ezilula.

iziphetho

Ngakho-ke, kunezindlela eziningana ezihlukene zokulungisa ububanzi nokuphakama kwamaseli, ngalinye elifanele imisebenzi ethile. Ngenxa yalokho, ithebula lingaba mnandi kakhulu ukulibuka futhi likhululeke ukulifunda. Eqinisweni, konke lokhu kwenzelwa lokhu. Ukufingqa ulwazi olutholiwe, sithola izindlela ezilandelayo:

1. Ukuhlela ububanzi nobude bebanga elithile lamaseli ngeqembu “Amaseli”, engatholakala kuthebhu "Ikhaya".
2. Ukuhlela amapharamitha weseli yawo wonke idokhumenti. Ukuze wenze lokhu, kufanele uchofoze inhlanganisela Ctrl + A noma kuseli lapho kuhlangana khona ikholomu enezinombolo zomugqa kanye nomugqa onamagama ekholomu yezinhlamvu zamagama.
3. Ukulungiswa mathupha kosayizi beseli kusetshenziswa iphaneli yokuxhumanisa. 
4. Ukulungiswa okuzenzakalelayo kosayizi bamaseli ukuze balingane nesiqeshana esikopishiwe. Lapha zenziwe zalingana netafula elikopishwe kwelinye ishidi noma incwadi yokusebenzela.

Ngokuvamile, akukho lutho oluyinkimbinkimbi ngalokhu. Zonke izindlela ezichaziwe ziqondakala ezingeni elinembile. Kwanele ukuzisebenzisa izikhathi eziningana ukuze ukwazi ukuzisebenzisa wena kuphela, kodwa futhi ufundise umuntu okufanayo.