Ungahlunga kanjani ngedethi ku-Excel

Amathebula adalwe ku-Microsoft Office Excel angahlungwa ngosuku. Ngokusetha isihlungi esifanele, umsebenzisi uzokwazi ukubona izinsuku azidingayo, futhi uhlu ngokwalo luzoncishiswa. Lesi sihloko sizodingida indlela yokusetha isihlungi ngedethi ku-Excel usebenzisa amathuluzi akhelwe ohlelweni.

Usifaka kanjani isihlungi ngedethi ohlwini lwethebula

Kunezindlela eziningi ezijwayelekile zokufeza umsebenzi, ngayinye enama-nuances ayo. Ukuze uthole ukuqonda okuphelele kwesihloko, kuyadingeka ukuchaza indlela ngayinye ngokwehlukana.

Indlela 1. Ukusebenzisa inketho ethi "Hlunga".

Indlela elula yokuhlunga idatha yethebula ku-Excel, okusho i-algorithm elandelayo yezenzo:

1. Dala ithebula elidinga ukuhlungwa ngedethi. La malungu afanayo kufanele aqukathe izinsuku ezithile zenyanga.

2. Khetha ithebula elihlanganisiwe elinenkinobho yegundane engakwesokunxele.
3. Iya kuthebhu ethi “Ekhaya” kubha yamathuluzi ephezulu yemenyu enkulu ye-Excel.
4. Chofoza inkinobho ethi "Hlunga" kuphaneli yezinketho ezivelayo. Futhi kulesi sigaba kunomsebenzi othi “Hlunga”, oshintsha ukuhleleka kokuboniswa kwemigqa noma amakholomu kuthebula lomthombo, ukuwahlela ngepharamitha ethile.

5. Ngemva kokwenza ukukhohlisa okudlule, isihlungi sizosetshenziswa etafuleni, okungukuthi imicibisholo emincane izovela emagameni amakholomu ahleliwe, ngokuchofoza lapho ongavula khona izinketho zokuhlunga. Lapha udinga ukuchofoza kunoma yimuphi umcibisholo.

6. Kumenyu yokuqukethwe evulayo, thola ingxenye ethi “Indawo yosesho” bese ukhetha inyanga okuzokwenziwa ngayo ukuhlunga. Yilezo zinyanga kuphela ezikuhlu lwangempela lwethebula eziboniswa lapha. Umsebenzisi udinga ukuthikha ibhokisi eliseduze nenyanga ehambisanayo bese uchofoza okuthi “KULUNGILE” ezansi ewindini. Kungenzeka ukukhetha izinketho eziningana ngesikhathi esisodwa.

7. Hlola umphumela. Ithebula lizoqukatha kuphela ulwazi lwezinyanga ezikhethwe umsebenzisi efasiteleni lokuhlunga. Ngokuvumelana nalokho, idatha engafuneki izonyamalala.

Nakani! Kumenyu yembondela yesihlungi, ungakwazi ukuhlunga idatha ngonyaka.

Indlela 2. Ukusebenzisa inketho ethi "Hlunga ngedethi".

Lona umsebenzi okhethekile okuvumela ukuthi uhlunge ngokushesha ulwazi ohlwini lwetafula ngamadethi. Ukuze uyisebenzise, ​​udinga ukulandela izinyathelo ezimbalwa:

1. Faka isihlungi etafuleni lokuqala ngendlela efanayo.
2. Ewindini lokuhlunga, thola umugqa "Hlunga ngedethi" bese usebenzisa inkinobho yegundane kwesokunxele ukuze uchofoze umcibisholo otholakala kwesokudla sawo.
3. Imenyu yokudonsela phansi izovuleka. Nazi izinketho zokuhlunga idatha ngedethi.

4. Isibonelo, chofoza inkinobho ethi "Phakathi ...".
5. Iwindi Lokuhlunga Okuzenzakalelayo Lizovuleka. Lapha, emgqeni wokuqala, kufanele ucacise idethi yokuqala, futhi emgqeni wesibili, usuku lokugcina.

6. Hlola umphumela. Amanani kuphela phakathi kwamadethi ashiwo azohlala kuthebula.

Indlela yesi-3: Ukuhlunga okwenziwa ngesandla

Le ndlela ilula ukuyisebenzisa, kodwa ithatha isikhathi esiningi kumsebenzisi, ikakhulukazi uma kufanele usebenze ngamatafula amakhulu. Ukuze usethe isihlungi mathupha, kufanele:

1. Kuhlu lwangempela lwethebula, thola amadethi umsebenzisi angawadingi.
2. Khetha imigqa etholiwe ngenkinobho yegundane engakwesokunxele.
3. Cindezela inkinobho ethi “Backspace” kukhibhodi yekhompyutha ukuze ususe amanani akhethiwe.

Ulwazi Olwengeziwe! Ku-Microsoft Office Excel, ungakhetha imigqa eminingana ohlwini lwethebula ngesikhathi esifanayo ukuze uyisuse ngokushesha ukuze wonge isikhathi somsebenzisi.

Indlela 4. Ukusebenzisa isihlungi esithuthukisiwe ngedethi

Ngenhla, kucatshangelwe indlela yokuhlunga amanani ohlwini lwethebula olususelwe kunketho ethi “Phakathi…”. Ukuze kudalulwe ngokugcwele isihloko, kubalulekile ukuxoxa ngezinketho ezimbalwa zesihlungi esithuthukisiwe. Akulungile ukucabangela zonke izinhlobo zesihlungi ngaphakathi kohlaka lwalesi sihloko. Ukuze usebenzise isihlungi esisodwa noma esinye ngosuku etafuleni, kufanele:

1. Faka isihlungi etafuleni ngethebhu ethi “Ekhaya”. Indlela yokwenza lokhu ichazwe ngenhla.
2. Nweba uhlu lokudonsela phansi esihlokweni sanoma iyiphi ikholomu kuthebula bese uchofoza i-LMB kulayini othi “Hlunga ngedethi”.
3. Cacisa noma yiziphi izinketho. Isibonelo, chofoza umugqa "Namuhla".

4. Ulwazi ohlwini luzohlungwa ngedethi eshiwo. Labo. idatha kuphela enedethi yanamuhla ezohlala kuthebula. Lapho usetha isihlungi esinjalo, i-Excel izoqondiswa idethi ebekwe kukhompuyutha.
5. Ngokukhetha inketho ethi “Okwengeziwe…”, umsebenzisi kuzodingeka afake inombolo ethile. Ngemva kwalokho, uhlu lwethebula luzoqukatha amadethi amakhulu kunalawo ashiwo. Wonke amanye amanani azosuswa.

Kubalulekile! Ezinye izinketho zokuhlunga ezithuthukisiwe zisetshenziswa ngokufanayo.

Ungahlehlisa kanjani isihlungi ku-Excel

Uma umsebenzisi ecacise ngephutha isihlungi ngedethi, bese ukuze usikhansele, uzodinga ukwenza lezi zinyathelo ezilandelayo:

1. Khetha i-LMB ipuleti okufakwa kulo ukuhlunga.
2. Iya engxenyeni ethi "Ekhaya" bese uchofoza inkinobho ethi "Hlunga". Imenyu yokudonsela phansi izovuleka.
3. Kumenyu yokuqukethwe, chofoza inkinobho ethi "Sula". Ngemva kokwenza lesi senzo, ukuhlunga kuzokhanselwa futhi uhlu lwethebula luzobuyela esimweni salo sangempela.

Nakani! Ungakwazi ukuhlehlisa isenzo sangaphambili usebenzisa izinkinobho "Ctrl + Z".

Isiphetho

Ngakho-ke, isihlungi ngosuku ku-Microsoft Office Excel sikuvumela ukuthi ususe ngokushesha izinsuku ezingadingekile zenyanga etafuleni. Izindlela zokuhlunga eziyinhloko zichazwe ngenhla. Ukuze uqonde isihloko, udinga ukuwafunda ngokucophelela.