Faka ngokuzenzakalelayo ubude bomugqa ku-Excel ngokuqukethwe. Izindlela ezi-5 zokuhlela

Lapho usebenza kuspredishithi se-Excel, kuvame ukuba nezikhathi lapho ulwazi olutholakala kuseli luphuma emingceleni. Ukuze uthole isibonisi esifanele, ungasusa ulwazi olungadingekile kuseli, kodwa lena indlela engasebenzi kahle, njengoba ithembisa ukulahlekelwa kolwazi oluphelele. Isixazululo esihle ukuhambisa imingcele yeseli ukuze ilingane yonke idatha. Esihlokweni sizohlaziya izinketho ezimbalwa zokusetha ngokuzenzakalelayo ubude bomugqa.

Kuyini ukuphakama komugqa ku-Microsoft Excel

Ukuphakama komugqa kungenye yezinhlaka zolwazi lwethebula. Ngokuzenzakalelayo, ubude buyakwazi ukulingana nombhalo obhalwe emugqeni owodwa. Uma ukugoqwa komugqa kunikwe amandla, ukuphakama kwekholomu kuyanda ngokwakho ukuze lonke ulwazi kuseli luboniswe kahle kuyo.

Ukuthi ithebula libukeka kanjani ngaphambi kokusebenzisa ukukhetha okuzenzakalelayo, yiziphi izizathu ezingadingeka

Ukuze uthole isibonelo esingokomfanekiso, ake sicabangele isimo lapho kukhona amaseli anolwazi oluningi lombhalo epuletini. Ithebula langempela libukeka kanje:

Singabona ngokucacile ukuthi kunamaseli amaningi lapho umbhalo ofakiwe ungangeni khona. Kulesi simo, umsebenzisi akakwazi ukwandisa ububanzi bamakholomu, ngoba lapho unyathelisa, ipuleti yonke ngeke ingene ephepheni lephepha. Ukuze ubonise kahle yonke idatha ekuyo, kufanele usebenzise enye yezindlela zokukhetha ngokuzenzakalelayo ubude bomugqa. Ungathola ngazo zonke izindlela ngokufunda imininingwane engezansi.

Faka ngokuzenzakalelayo ubude bomugqa

Ukulungiswa okuzenzakalelayo kobude bomugqa kuyithuluzi elikhethekile elilungisa ukuphakama kweseli ngalinye lomugqa ekugcwalisweni kweseli eligcwele kakhulu.. Kuyaphawuleka ukuthi ububanzi kuleli cala abushintshi. Umsebenzi ulungisa ngokuzenzakalelayo imingcele, kodwa okuningi kokukhohlisa kwenziwa ngokuzimela. Kunezindlela ezimbalwa zokusebenzisa ukukhetha okuzenzakalelayo. Ake sixoxe ngazo zonke kabanzi.

Indlela yoku-1: Ubude be-AutoFit ngefomethi yeseli

Lena indlela yokuqala, okudingeka isetshenziswe lapho kuqaliswa izindlela ezisele. Ukufanisa okuzenzakalelayo kusebenza kuphela kumaseli anikwe amandla ukugoqa amagama. Imiyalo enemininingwane imi kanje:

1. Chofoza kwesokudla kuseli noma ububanzi. Kokuhlukile okucatshangelwayo, sikhetha ithebula lonke. Imenyu yokuqukethwe encane iyavezwa. Sithola “Fometha amaseli …” bese uchofoza kuwo LMB.

2. Isibonisi sizobonisa ibhokisi elibizwa ngokuthi Format Cells. Sithuthela esigatshaneni esithi "Ukuqondanisa". Sithola umyalo othi "Bonisa" bese usetha ibhokisi lokuhlola eduze kwepharamitha ethi "Goqa umbhalo". Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

3. Ilungile! Ngemva kokwenza zonke izinqubo, okuqukethwe kwamaseli akhethiwe kuboniswe ngokuphelele kuwo. Ukuphakama kwemigqa kushintshile ngendlela yokuthi lonke ulwazi kumaseli luboniswe ngokugcwele.

Qaphela! Kuyenzeka ukuthi kububanzi obusesimeni kukhona ukugoqa kwegama, kepha idatha namanje ayingeni kumaseli, noma, ngokuphambene nalokho, kunendawo eningi engenalutho. Ukuze uqonde ukuthi ungayilungisa kanjani le nkinga, cabangela izindlela ezilandelayo.

Indlela yesi-2. Ukulungisa ubude ngebha yokuxhumanisa

Imiyalo enemininingwane imi kanje:

1. Sithola iphaneli yokuxhumanisa yohlobo olume mpo bese uchofoza inombolo yomugqa, ukuphakama okuzenzakalelayo esihlela ukulungisa. Ngemva kokukhetha irowu, kufanele igqanyiswe ngokuphelele.

2. Hambisa ikhesa yegundane phansi komugqa okhethiwe. Isikhombi sizothatha isimo semicibisholo emibili ebheke eziqondisweni eziphambene. Cindezela i-LMB kabili.

3. Ilungile! Ngemva kokwenza le nqubo, ukuphakama komugqa okhethiwe kwashintsha ngokuzenzakalelayo ukuze manje wonke amaseli akwazi ukulingana nolwazi oluqukethwe kuwo. Imingcele yamakholomu ayishintshile nganoma iyiphi indlela.

Indlela yesi-3: Ukuphakama Okuzenzakalelayo Kwemigqa Eminingi

Indlela engenhla ayifanele uma usebenza ngenani elikhulu ledatha, ngoba kuzothatha isikhathi esiningi ukukhetha umugqa ngamunye wepuleti. Kukhona enye indlela egcina isikhathi esiningi. Imiyalo enemininingwane imi kanje:

1. Futhi sithola iphaneli yokuxhumanisa yohlobo olume mpo. Manje asikhethi umugqa owodwa, kodwa ngesikhathi esisodwa, ubukhulu esihlela ukushintsha.

2. Njengasenguqulweni yangaphambilini, chofoza kabili i-LMB enombolweni yomugqa kuze kube yilapho isikhombi sithatha isimo semicibisholo emibili ebheke ezinhlangothini eziphambene. Le nqubo izokuvumela ukuthi usebenzise ukukhetha kobude obuzenzakalelayo.

3. Ilungile! Sisebenzise ubude obulungile kumugqa ngamunye okhethiwe, futhi manje lonke ulwazi luboniswa ngendlela efanele kumaseli akhethiwe.

Indlela yesi-4: Sebenzisa amathuluzi akuribhoni

Iningi lemisebenzi ewusizo ye-spreadsheet processor itholakala phezulu kwesixhumi esibonakalayo kuribhoni yethuluzi elikhethekile. Kukhona into ekhethekile lapha ekuvumela ukuthi usebenzise ukukhetha kobude obuzenzakalelayo. Imiyalo enemininingwane imi kanje:

1. Senza ukukhetha kwendawo, ukukhetha okuzenzakalelayo kobude esihlela ukukhiqiza.

2. Sithuthela esigabeni esibizwa ngokuthi "Ikhaya", esitholakala phezulu kwesixhumi esibonakalayo sespredishithi. Sithola ibhulokhi yemiyalo ethi "Amaseli" bese ukhetha into ethi "Format". Ohlwini lokudonsela phansi, thola inkinobho ethi “Faka ngokuzenzakalelayo ubude bomugqa” bese uchofoza kukho.

3. Ilungile! Senze ubude obulungile kumugqa ngamunye okhethiwe futhi manje lonke ulwazi luboniswa ngendlela efanele kumaseli akhethiwe.

Indlela yesi-5: Lungisa ubude bamaseli ahlanganisiwe

Umsebenzi okhethekile okuvumela ukuthi usebenzise ukukhetha okuzenzakalelayo kobude bomugqa awukwazi ukusetshenziswa kumaseli ohlobo oluhlanganisiwe. Kunoma yikuphi, kunezici ezengeziwe kusipredishithi ezikuvumela ukuthi usebenzise le nqubo.

Incazelo yale ndlela ukuthi ngeke senze inqubo yokuhlanganisa amaseli, kodwa simane senze ukubonakala kwamaseli axhumayo, okuzosivumela ukuthi sisebenzise ukukhetha okuzenzakalelayo. Imiyalo enemininingwane imi kanje:

1. Ekuqaleni, senza ukukhetha kulawo maseli esifuna ukwenza kuwo inqubo yokuhlanganisa.

2. Chofoza kwesokudla endaweni ekhethiwe. Imenyu yokuqukethwe ivezwa esibukweni. Sithola into ebizwa ngokuthi “Fometha Amaseli …” bese uchofoza kuyo nge-LMB.

3. Iwindi lamaseli efomethi livele esibukweni. Ukudlulela esigabeni esithi "Ukuqondanisa". Nweba uhlu lokuqala ngqa bese uchofoza umbhalo othi “Ukukhetha okumaphakathi”. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

4. Ulwazi olukwiseli yokuqala luboniswa phakathi nendawo yamaseli akhethiwe. Kufanele kuqashelwe ukuthi akukho ukuhlangana okwenzekile. Sisanda kudala ukubonakala kwenyunyana.

5. Esigabeni sokugcina, sisebenzisa umsebenzi wokukhetha okuzenzakalelayo kobude bomugqa usebenzisa enye yezindlela ezichazwe ngenhla.

6. Ilungile! Sisebenzise ubude obulungile kumugqa ngamunye okhethiwe, futhi manje lonke ulwazi luboniswa ngendlela efanele kumaseli akhethiwe.

Kuyaphawuleka! I-algorithm yesenzo ngayinye ifaneleka kuzo zombili izinguqulo zangaphambili ze-Excel spreadsheet processor kanye nezakamuva.

Ake sicabangele isibonelo esincane lapho sisebenzisa khona ulwazi esilutholile ekukhetheni okuzenzakalelayo kobude bomugqa. Isibonelo, sinethebula elilandelayo, okufanele silethe ekubonisweni okulungile ekhasini lokusebenza:

Umgomo wethu: ukusebenzisa ukubonisa okulungile kwedatha epuletini emgqeni owodwa. Imiyalo enemininingwane imi kanje:

1. Ukusebenzisa inhlanganisela yokhiye kukhibhodi "CTRL + A" sikhetha wonke amanani.
2. Ubude bomugqa bushintshile ukuze idatha manje iboniswe emugqeni owodwa. Olunye ulwazi alubonakali. Kudingeka siqinisekise ukuthi yonke idatha iboniswa ngokuphelele ekhasini lokusebenza.

3. Sikhetha amakholomu A, B kanye no-C.
4. Hambisa ikhesa yegundane esigabeni samakholomu A no-B bese uchofoza kabili i-LMB.

5. Ilungile! Inhloso iqediwe. Manje lonke ulwazi olutholakala kumaseli wekhasi lokusebenzela luboniswa ngendlela efanele.

Indlela yokusetha ubude bomugqa oqondile?

Ngokuvamile, abasebenzisi bespredishithi be-Excel babhekana nesimo lapho kudingeka khona ukusetha ubude bomugqa oqondile lapho usebenza nanoma yiluphi ulwazi lwethebula. Imiyalo enemininingwane imi kanje:

1. Eshidini lokusebenzela lespredishithi, sikhetha imigqa edingekayo ngenkinobho yegundane engakwesokunxele, ubude obuqondile esihlela ukukusetha.
2. Chofoza kwesokudla endaweni ekhethiwe yekhasi lokusebenzela.
3. Imenyu yokuqukethwe encane iboniswe esikrinini. Sithola into ebizwa ngokuthi “Row Height” bese uchofoza kuyo nge-LMB.
4. Iwindi elibizwa ngokuthi “Row Height” livele esikrinini. Emkhakheni wokufaka, sishayela ekuphakameni komugqa esikudingayo ngamaphuzu. Amaphuzu amathathu - cishe imilimitha eyodwa.
5. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK" etholakala phansi kwefasitela.

6. Ilungile! Senze inkomba yobude obuqondile bomugqa kusipredishithi se-Excel.

Khumbula! Ubude bomugqa obuzenzakalelayo bungamaphikseli angu-12.75.  

Uma kungenakwenzeka ukufaka ngokuzenzakalelayo ubude bomugqa

Kunezimo ezingemnandi lapho zonke izindlela ezingenhla zingavumeli ukukhethwa okuzenzakalelayo kokuphakama komugqa. Ngokuvamile, isizathu sokusebenza okungalungile komsebenzi ukuthi umsebenzisi uhlanganise inani lamaseli ndawonye.

Khumbula ukuthi ukuphakama komugqa okuzenzakalelayo akusebenzi kumaseli ahlanganisiwe. Endabeni yokuhlanganisa amaseli, kuzodingeka ukuba kwenziwe inqubo yokukhetha amapharamitha alungile ngokuzimela. Kunezinketho ezimbili zokuxazulula le nkinga:

1. Ukwelula ngokuzenzela kwemingcele ngokubamba i-LMB.
2. Sebenzisa umsebenzi wobude bomthungo onembile.

Kunoma yikuphi, kufaneleka kakhulu ukungasebenzisi ukuhlanganisa iseli, kodwa ukusebenzisa “ukubonakala” kokuxhumana. Lokhu kukuvumela ukuthi usebenzise ukukhetha okuzenzakalelayo kobude bomugqa kusipredishithi se-Excel.

Isiphetho

Njengoba singabona, kunezindlela ezimbalwa ezihlukene zokuqalisa inqubo yokukhetha ubude obuzenzakalelayo kuphrosesa yespredishithi se-Excel. Inketho ekuvumela ukuthi usethe ubude bomugqa ngamunye ngokwehlukana inhle ekusebenzeni ngamanani amancane wedatha. Ukuze usebenze ngamatafula amakhulu, kufanele unake ezinye izindlela. Inani elikhulu lezindlela zokukhetha ezizenzakalelayo livumela umsebenzisi ngamunye ukuthi azikhethele inketho elula kakhulu.