Ungasusa kanjani ukuhlunga ku-Excel ngemuva kokugcina

Ku-Microsoft Office Excel, ungakwazi ukuhlela okuqukethwe kwamathebula ngesibaluli esithile usebenzisa amathuluzi akhelwe ohlelweni. Lesi sihloko sizochaza izici zokukhansela ukuhlunga ngaphambi nangemuva kokulondoloza idokhumenti.

Ungahlunga kanjani ithebula ku-Excel

Ukuletha uhlu lwethebula efomini elifiselekayo lomsebenzisi, futhi ungaphinde uhlele idatha kumakholomu mathupha, kufanele wenze lokhu kukhohlisa okulandelayo:

1. Khetha lonke ithebula noma ingxenye yalo: ikholomu, umugqa, ububanzi obuthile bamaseli. Ukuze ukhethe ama-elementi epuleti, bamba phansi ukhiye wesokunxele we-manipulator bese uwuhudulela endaweni ecacisiwe.

2. Chofoza igama elithi “Ekhaya” kubha yamathuluzi ephezulu ye-Microsoft Office Excel futhi ufunde ngokucophelela ukusebenzelana kwephaneli yezinketho ezivulekayo.
3. Ekupheleni kohlu, thola ithebhu ethi “Hlunga futhi Hlunga” bese uchofoza kuyo nge-LMB. Ithebhu izovuleka njengemenyu encane.

4. Khetha eyodwa yezinketho eziphrezentwe zokuhlunga idatha kuthebula. Lapha ungakwazi ukuhlunga ngokulandelana kwezinhlamvu noma ngokulandelana.

5. Hlola umphumela. Ngemva kokucacisa enye yezinketho, ithebula noma ingxenye yalo ekhethiwe izoshintsha, idatha izohlungwa ngokuvumelana nemfanelo ethile eshiwo umsebenzisi.

Nakani! Ungaphinda ukhethe Ukuhlunga Ngokwezifiso. Kulokhu, umsebenzisi uzokwazi ukuhlunga amapharamitha wohlu lwethebula ngokulandelana okukhuphukayo, ngedethi, ngefonti, ngamakholomu amaningana, imigqa, noma ukwenza ukuhlela okunamandla.

Ungakukhansela kanjani ukuhlunga ngenkathi usebenza ngedokhumenti

Uma umsebenzisi, ngenkathi esebenza kudokhumenti ye-Excel, ahlele idatha yetafula ngephutha, bese ehlehlisa isenzo sakhe, uzodinga ukuthatha izinyathelo ezilandelayo:

1. Vala iwindi lokuhlunga.
2. Susa ukukhetha wonke amaseli ethebula. Ngale njongo, udinga ukuchofoza inkinobho yegundane kwesokunxele esikhaleni samahhala seshidi lokusebenza ngaphandle kwepuleti.
3. Chofoza uphawu "Khansela", olubukeka njengomcibisholo oya kwesokunxele futhi olutholakala eduze kwenkinobho ethi "Ifayela" ekhoneni eliphezulu kwesokunxele sesikrini.

4. Qiniseka ukuthi izenzo ezikudokhumenti zibuyela emuva ngesinyathelo esisodwa. Labo. ububanzi bamaseli kufanele bususwe. Umsebenzi wokuhlehlisa ukuvumela ukuthi ususe isenzo esenziwe ekugcineni.
5. Ungakwazi futhi ukuhlehlisa ukusebenza kokugcina ku-Microsoft Office Excel usebenzisa inhlanganisela yezinkinobho kukhibhodi yekhompyutha. Ngale njongo, umsebenzisi udinga ukushintshela esakhiweni sesiNgisi futhi ngesikhathi esifanayo abambe izinkinobho "Ctrl + Z".

Ulwazi Olwengeziwe! Umsebenzi wokuhlehlisa usebenzisa inhlanganisela ethi “Ctrl + Z” usebenza kubo bonke abahleli be-Microsoft Office, kungakhathaliseki inguqulo yabo.

Ungakukhansela kanjani ukuhlunga ngemva kokulondoloza idokhumenti ye-excel

Uma umsebenzi we-Excel ugciniwe futhi umsebenzisi evala idokhumenti, yonke idatha yebhodi lokunamathisela isuswa ngokuzenzakalelayo. Lokhu kusho ukuthi inkinobho ethi "Khansela" ngeke isebenze ngesikhathi esilandelayo lapho uvula ifayela, futhi ngeke ukwazi ukususa ukuhlunga kwetafula ngale ndlela. Kulesi simo, ochwepheshe abanolwazi batusa ukuthatha izinyathelo ezimbalwa ezilula ngokuya nge-algorithm:

1. Qalisa ifayela le-Excel, qiniseka ukuthi umsebenzi wangaphambilini ugciniwe futhi uyavezwa ephepheni lokusebenza.
2. Chofoza inkinobho yegundane kwesokudla egameni lekholomu yokuqala ngqa epuletini.
3. Ewindini lokuqukethwe, chofoza umugqa "Faka". Ngemva kwesenzo esinjalo, ikholomu eyinsiza izokwakhiwa kuthebula.
4. Kumugqa ngamunye wekholomu eyisizayo, udinga ukucacisa inombolo ye-serial yamakholomu alandelayo. Isibonelo, kusuka ku-1 kuye ku-5, kuye ngenani lamaseli.

5. Manje sidinga ukuhlunga idatha ohlwini lwethebula nganoma iyiphi indlela elula. Indlela yokwenza lokhu ichazwe ngenhla.
6. Londoloza idokhumenti bese uyivala.

7. Qalisa ifayela le-Microsoft Office Excel futhi bese uhlela ikholomu eyisizayo ngendlela ekhuphukayo ngokuyikhetha ngokuphelele bese ukhetha inketho efanelekile ohlwini olukuthebhu ethi Hlunga futhi Hlunga.
8. Ngenxa yalokho, lonke ithebula kufanele lihlungwe njengekholomu elisizayo, okungukuthi thatha ifomu langempela.
9. Manje usungakwazi ukususa ikholomu yokuqala ukuze ugweme ukudideka futhi ulondoloze idokhumenti.

Kubalulekile! Ungakwazi ukufaka inombolo yekholomu eyinsiza ngokuzenzakalelayo ngokubhala inani kuphela kuseli yayo yokuqala futhi uyinwebe ekupheleni kohlu lwethebula.

Ungakwazi futhi ukuhlela idatha kuthebula le-Excel ngokwenza izibalo ezithile, uguqule amanani kumakholomu nemigqa ephakathi kwawo. Nokho, le nqubo ithatha isikhathi esiningi kumsebenzisi. Kulula ukusebenzisa ithuluzi elakhelwe kwisofthiwe eklanyelwe ukuqedela umsebenzi. Ngaphezu kwalokho, imingcele oyifunayo ingahlelwa ngombala nosayizi weseli.

Isiphetho

Ngakho-ke, ukuhlunga ku-Microsoft Office Excel kwenziwa ngesikhathi esifushane kakhulu ngezindlela ezilula. Ukuze ukhansele lesi senzo ngemva kokulondoloza idokhumenti, uzodinga ukwakha ikholomu yokusiza eyengeziwe ohlwini lwethebula, uyifake izinombolo, bese uyihlela ngendlela ekhuphukayo. I-algorithm enemininingwane yethulwe ngenhla.