Ungaphindaphinda kanjani ikholomu ngomugqa kusipredishithi se-excel

Lapho usebenza namaspredishithi e-Excel, ngezinye izikhathi kuba nesidingo sokusabalalisa ulwazi olusuka kukholomu eyodwa phezu kwemigqa embalwa emakiwe. Ukuze ungakwenzi lokhu ngesandla, ungasebenzisa amathuluzi akhelwe ngaphakathi wohlelo ngokwalo. Okufanayo kusebenza ekukhiqizeni kabusha kwemisebenzi, amafomula. Uma ziphindaphindwa ngokuzenzakalelayo ngenombolo edingekayo yemigqa, ungathola ngokushesha umphumela oqondile wokubala.

Ukusatshalaliswa kwedatha isuka kukholomu eyodwa iye emigqeni ehlukene

Ku-Excel, kunomyalo ohlukile ongasabalalisa ngawo ulwazi oluqoqwe kukholamu eyodwa emigqeni ehlukene.

Ukuze usabalalise idatha, udinga ukulandela izinyathelo ezimbalwa ezilula:

1. Iya kuthebhu ethi "EXCEL", etholakala ekhasini eliyinhloko lamathuluzi.
2. Thola ibhulokhi ngamathuluzi "Ithebula", chofoza kuyo ngenkinobho yegundane kwesokunxele.
3. Kumenyu evulayo, khetha inketho ethi "Phinda kabili ikholomu ngemigqa".
4. Ngemuva kwalokho, iwindi elinezilungiselelo zesenzo esikhethiwe kufanele livuleke. Esigabeni sokuqala samahhala, udinga ukukhetha ohlwini oluhlongozwayo ikholomu ofuna ukuyiphindaphinda.
5. Uma ikholomu ikhethiwe, udinga ukunquma uhlobo lwesihlukanisi. Kungaba ichashazi, ukhefana, isemicolon, isikhala, ukugoqwa kombhalo komunye umugqa. Ngokuzithandela, ungakhetha umlingiswa wakho ozohlukanisa naye.

Ngemva kokuqeda zonke izinyathelo ezichazwe ngenhla, kuzokwakhiwa ishidi lokusebenza elisha lapho kuzokwakhiwa khona ithebula elisha kusukela emigqeni eminingi lapho idatha evela kukholomu ekhethiwe izosatshalaliswa khona.

Kubalulekile! Kwesinye isikhathi kuba nezimo lapho kumele kuqashelwe isenzo sokuphindaphinda amakholomu ekhasini lokusebenzela eliyinhloko. Kulokhu, ungakwazi ukuhlehlisa isenzo ngokusebenzisa inhlanganisela yokhiye "CTRL + Z" noma uchofoze isithonjana sokuhlehlisa ngaphezu kwebha yamathuluzi eyinhloko.

Ukukhiqizwa kabusha kwamafomula

Kaningi lapho usebenza ku-Excel kunezimo lapho kudingekile ukuphindaphinda ifomula eyodwa ngesikhathi esisodwa kumakholomu amaningana ukuze uthole umphumela odingekayo kumaseli aseduze. Ungakwenza ngokwakho. Nokho, le ndlela izothatha isikhathi esiningi kakhulu. Kunezindlela ezimbili zokwenza inqubo ngokuzenzakalelayo. Ngegundane:

1. Khetha iseli eliphezulu kakhulu kuthebula lapho ifomula ikhona (usebenzisa i-LMB).
2. Hambisa ikhesa ekhoneni elikude kwesokudla seseli ukuze ubonise isiphambano esimnyama.
3. Chofoza i-LMB kusithonjana esivelayo, hudula igundane uye phansi enanini elidingekayo lamaseli.

Ngemva kwalokho, kumaseli akhethiwe, imiphumela izovela ngokuvumelana nefomula esethelwe iseli lokuqala.

Kubalulekile! Ukukhiqizwa kabusha kwefomula noma umsebenzi othile kukholamu yonke ngegundane kungenzeka kuphela uma wonke amaseli angezansi egcwalisiwe. Uma elinye lamaseli lingenalo ulwazi ngaphakathi, ukubala kuzophela kulo.

Uma ikholomu iqukethe amakhulu kuya ezinkulungwaneni zamaseli, futhi amanye angenalutho, ungenza inqubo yokubala ngokuzenzakalelayo. Ukuze wenze lokhu, udinga ukwenza izenzo eziningana:

1. Maka iseli yokuqala yekholomu ngokucindezela i-LMB.
2. Skrola isondo liye ekugcineni kwekholomu ekhasini.
3. Thola iseli lokugcina, ubambe ukhiye "Shift", chofoza leli seli.

Ububanzi obudingekayo buzogqanyiswa.

Hlunga idatha ngamakholomu nemigqa

Kaningi kunezimo lapho, ngemva kokugcwalisa ngokuzenzakalela ishidi lokusebenzela ngedatha, lisatshalaliswa ngokungahleliwe. Ukuze kube lula ukuthi umsebenzisi asebenze esikhathini esizayo, kuyadingeka ukuhlela idatha ngemigqa namakholomu. Kulokhu, njengomsabalalisi, ungasetha inani ngefonti, ukwehla noma ukukhuphuka, ngombala, ngama-alfabhethi, noma uhlanganise le mingcele enye kwenye. Inqubo yokuhlunga idatha usebenzisa amathuluzi e-Excel akhelwe ngaphakathi:

1. Chofoza kwesokudla noma yikuphi ekhasini lokusebenza.
2. Kumenyu yokuqukethwe evelayo, khetha inketho - "Hlunga".
3. Ngokuphikisana nepharamitha ekhethiwe, izinketho ezimbalwa zokuhlunga idatha zizovela.

Enye indlela yokukhetha inketho yokuhlunga ulwazi ngokusebenzisa ibha yamathuluzi eyinhloko. Kuyo udinga ukuthola ithebhu "Idatha", ngaphansi kwayo khetha into ethi "Hlunga". Inqubo yokuhlunga ithebula ngekholomu eyodwa:

1. Okokuqala, udinga ukukhetha ububanzi bedatha kukholomu eyodwa.
2. Isithonjana sizovela kubha yomsebenzi ngokukhethwa kwezinketho zokuhlunga ulwazi. Ngemva kokuchofoza kuyo, kuzovuleka uhlu lwezinketho zokuhlunga okungenzeka.

Uma amakholomu amaningana ekhasini akhethiwe ekuqaleni, ngemva kokuchofoza isithonjana sokuhlunga kubha yomsebenzi, iwindi elinezilungiselelo zalesi senzo lizovuleka. Kusuka kuzinketho ezihlongozwayo, kufanele ukhethe inketho "yokwandisa ngokuzenzakalelayo ububanzi obukhethiwe". Uma ungakwenzi lokhu, idatha ekukholomu yokuqala izohlungwa, kodwa ukwakheka okuphelele kwetafula kuzophulwa. Inqubo yokuhlunga umugqa:

1. Ewindini lezilungiselelo zokuhlunga, yiya kuthebhu ethi “Amapharamitha”.
2. Ewindini elivulayo, khetha inketho ethi "Range Columns".
3. Ukuze ulondoloze izilungiselelo, chofoza inkinobho ethi "KULUNGILE".

Amapharamitha asethwe ekuqaleni kuzilungiselelo zokuhlunga awavumeli ukusatshalaliswa okungahleliwe kwedatha kulo lonke ishidi lokusebenzela. Ukuze wenze lokhu, udinga ukusebenzisa umsebenzi we-RAND.

Isiphetho

Inqubo yokuphindaphinda amakholomu ngemigqa icacile, yingakho kungeyena wonke umsebenzisi owaziyo ukuthi isetshenziswa kanjani. Nokho, ngemva kokufunda imiyalelo engenhla, lokhu kungenziwa ngokushesha okukhulu. Ngaphezu kwalokhu, kunconywa ukuba uzijwayeze ukukhiqizwa kabusha kwemisebenzi namafomula, ngenxa yalokho kuzokwazi ukulondoloza isikhathi esiningi ngesikhathi sokubala okuhlukahlukene kumabanga amakhulu amaseli.