Ungawengeza kanjani umugqa omusha ku-Excel

Lapho usebenza namathebula ku-Excel, akuvamile ukuthi udinge ukwengeza imigqa emisha. Lo msebenzi ulula, kodwa usabangela ubunzima kwabanye abasebenzisi. Okulandelayo, sizohlaziya lo msebenzi, kanye nawo wonke ama-nuances angabangela lobu bunzima.

Ungawufaka kanjani umugqa omusha

Kufanele kushiwo ngaso leso sikhathi ukuthi inqubo yokwengeza umugqa omusha ku-Excel icishe ifane kuzo zonke izinguqulo, nakuba kungase kube khona umehluko omncane.

1. Okokuqala, vula/dala ithebula, khetha noma iyiphi iseli kumugqa ongenhla esifuna ukuyifaka umugqa omusha. Sichofoza kwesokudla kule seli bese kumenyu yokudonsela phansi chofoza umyalo "Faka ...". Futhi, kulo msebenzi, ungasebenzisa okhiye abashisayo u-Ctrl kanye no-"+" (ukucindezela kanyekanye).
2. Ngemva kwalokho, kuzovuleka ibhokisi lengxoxo lapho ongakhetha khona ukufaka iseli, umugqa noma ikholomu. Khetha Faka Umugqa bese uchofoza okuthi KULUNGILE.
3. Konke sekwenziwe, umugqa omusha wengeziwe. Futhi, qaphela, lapho ungeza umugqa omusha uthatha umugqa ophezulu zonke izinketho zokufometha.

Qaphela: Kukhona enye indlela yokwengeza umugqa omusha. Sichofoza kwesokudla inombolo yomugqa ngenhla esifuna ukufaka umugqa omusha bese sikhetha into ethi "Faka" kumenyu evelayo.

Ungawufaka kanjani umugqa omusha ekugcineni kwetafula

Kwesinye isikhathi kuba nesidingo sokwengeza umugqa omusha ekugcineni kwetafula. Futhi uma uyengeza ngendlela echazwe ngenhla, ngeke iwele etafuleni ngokwalo, kodwa izoba ngaphandle kohlaka lwayo.

1. Okokuqala, sikhetha wonke umugqa wokugcina wetafula ngokuchofoza inkinobho yegundane kwesokunxele enombolweni yayo. Bese uhambisa ikhesa ekhoneni elingezansi kwesokudla lomugqa ize iguqule umumo wayo ibe “isiphambano”.
2. Ubambe "isiphambano" ngenkinobho yegundane engakwesokunxele, idonsele phansi ngenombolo yemigqa esifuna ukuyengeza, bese ukhulula inkinobho.
3. Njengoba sibona, yonke imigqa emisha igcwaliswa ngokuzenzakalela ngedatha evela kuseli eliyimpinda futhi ukufometha kulondoloziwe. Ukuze usule idatha egcwaliswe ngokuzenzakalela, khetha imigqa emisha, bese ucindezela inkinobho ethi "Susa". Ungakwazi futhi ukuchofoza kwesokudla kumaseli akhethiwe bese ukhetha okuthi “Sula okuqukethwe” kumenyu evulayo.
4. Manje wonke amaseli asuka emigqeni emisha akanalutho, futhi singakwazi ukwengeza idatha entsha kuwo.

Qaphela: Le ndlela ifaneleka kuphela uma umugqa ongezansi ungasetshenziswa njengomugqa othi “Ingqikithi” futhi ungafingqanga wonke angaphambilini.

Indlela yokudala itafula elihlakaniphile

Ukuze kube lula ukusebenza ku-Excel, ungasebenzisa ngokushesha amatafula "ahlakaniphile". Leli thebula linwebeka kalula, ngakho-ke akufanele ukhathazeke uma ungazange ungeze ngokushesha inombolo edingekayo yemigqa. Futhi, lapho welula, amafomula asefakiwe kakade "awa" etafuleni.

1. Sikhetha indawo yamaseli okufanele afakwe kuthebula elithi “smart”. Okulandelayo, yiya kuthebhu ethi “Ekhaya” bese uchofoza okuthi “Fometha Njengethebula”. Sizonikezwa izinketho eziningi zokuklama. Ungakhetha noma iyiphi oyithandayo, ngoba ekusebenzeni okungokoqobo konke kuyafana.
2. Ngemva kokukhetha isitayela, iwindi elinezixhumanisi zobubanzi obukhethwe ngaphambilini lizovuleka phambi kwethu. Uma kusifanele, futhi singafuni ukwenza izinguquko kukho, chofoza inkinobho ethi "KULUNGILE". Futhi, kufanelekile ukushiya ibhokisi lokuhlola elithi "Ithebula elinezihloko", uma kunjalo.
3. Ithebula lethu "elihlakaniphile" lilungele umsebenzi owengeziwe ngalo.

Ungawufaka kanjani umugqa omusha kuthebula elihlakaniphile

Ukuze udale iyunithi yezinhlamvu entsha, ungasebenzisa izindlela esezichazwe ngenhla.

1. Kwanele ukuchofoza kwesokudla kunoma iyiphi iseli, khetha "Faka" bese - into "Imigqa yethebula ngenhla".
2. Futhi, umugqa ungangezwa kusetshenziswa okhiye abashisayo u-Ctrl kanye no-“+”, ukuze ungachithi isikhathi ezintweni ezengeziwe kumenyu.

Ungawufaka kanjani umugqa omusha ekugcineni kwetafula elihlakaniphile

Kunezindlela ezintathu zokwengeza umugqa omusha ekugcineni kwetafula elihlakaniphile.

1. Sihudula ikhona elingezansi kwesokudla setafula, futhi lizokwelula ngokuzenzakalelayo (imigqa eminingi njengoba siyidinga).Kulokhu, amaseli amasha ngeke agcwaliswe ngokuzenzakalela ngedatha yasekuqaleni (ngaphandle kwamafomula). Ngakho-ke, asikho isidingo sokususa okuqukethwe kwabo, okulula kakhulu.

   

2. Ungavele uqale ukufaka idatha kumugqa ngokushesha ngezansi kwetafula, futhi izoba yingxenye yethebula lethu "elihlakaniphile".
3. Kuseli elingezansi kwesokudla sethebula, vele ucindezele inkinobho ethi “Tab” kukhibhodi yakho.Umugqa omusha uzokwengezwa ngokuzenzakalelayo, kucatshangelwa zonke izinketho zokufometha kwethebula.

   

Isiphetho

Ngakho-ke, kunezindlela ezimbalwa zokwengeza imigqa emisha ku-Microsoft Excel. Kodwa ukuze ususe izinkinga eziningi ezingenzeka kusukela ekuqaleni, kungcono ukusebenzisa ngokushesha ifomethi yetafula "ehlakaniphile", evumela ukuthi usebenze nedatha ngokunethezeka okukhulu.