Ungeza kanjani imigqa eminingi ngesikhathi esisodwa ku-excel

Lapho usebenza namatafula ku-Microsoft Office Excel, ngokuvamile kudingekile ukufaka umugqa noma imigqa eminingana phakathi kohlu lwetafula phakathi kwezinto eziseduze ukuze wengeze ulwazi oludingekayo kumsebenzisi kuzo, ngaleyo ndlela wengeze ipuleti. Indlela yokwengeza imigqa ku-Excel kuzoxoxwa ngayo kulesi sihloko.

Ungeza kanjani umugqa owodwa ngesikhathi ku-Excel

Ukwandisa inani lemigqa kuthebula eselidaliwe kakade, isibonelo, phakathi kwalo, udinga ukwenza izinyathelo ezimbalwa ezilula ze-algorithm:

1. Sebenzisa inkinobho yegundane kwesokunxele ukuze ukhethe iseli eduze kwalo ofuna ukwengeza uhla olusha lwezakhi.

2. Chofoza kwesokudla endaweni egqanyisiwe.
3. Ewindini lohlobo lokuqukethwe, chofoza inketho ethi "Faka ...".

4. Imenyu encane ethi "Engeza amaseli" izovuleka, lapho udinga ukucacisa inketho oyifunayo. Kulesi simo, umsebenzisi kufanele abeke inkinobho yokuguqula endaweni ethi "String", bese uchofoza okuthi "KULUNGILE".

5. Hlola umphumela. Umugqa omusha kufanele wengezwe esikhaleni esabiwe kuthebula lokuqala. Ngaphezu kwalokho, okwagqama esigabeni sokuqala, kuzoba ngaphansi komugqa ongenalutho.

Nakani! Ngokufanayo, ungangeza inombolo enkulu yemigqa, isikhathi ngasinye ubiza imenyu yokuqukethwe bese ukhetha inketho efanele ohlwini lwamanani ethulwe.

Uyengeza kanjani imigqa eminingi kusipredishithi se-excel ngesikhathi esisodwa

I-Microsoft Office Excel inenketho ekhethekile eyakhelwe ngaphakathi ongakwazi ukubhekana nayo nomsebenzi ngesikhathi esifushane kakhulu. Kunconywa ukuthi ulandele imiyalo, engafani neze nesigaba esedlule:

1. Kuhlelo lwedatha lwangempela, udinga ukukhetha imigqa eminingi njengoba udinga ukuyengeza. Labo. ungakhetha amaseli asevele agcwalisiwe, akuthinti lutho.

2. Ngendlela efanayo, chofoza endaweni ekhethiwe ngenkinobho yegundane kwesokudla bese ewindini lohlobo lomongo, chofoza inketho ethi "Namathisela...".
3. Kumenyu elandelayo, khetha inketho ethi "String" bese uchofoza okuthi "KULUNGILE" ukuze uqinisekise isenzo.
4. Qinisekisa ukuthi inombolo edingekayo yemigqa yengezwe ohlwini lwethebula. Kulesi simo, amaseli akhethwe ngaphambilini ngeke asuswe, azoba ngaphansi kwemigqa engenalutho eyengeziwe.

Ungayikhipha kanjani imigqa engenalutho efakwe ku-Excel

Uma umsebenzisi ebeke ngephutha izinto ezingadingekile etafuleni, angakwazi ukuzisusa ngokushesha. Kunezindlela ezimbili eziyinhloko zokufeza umsebenzi. Kusazoxoxwa ngakho.

Kubalulekile! Ungakwazi ukususa noma iyiphi i-elementi kusipredishithi se-MS Excel. Isibonelo, ikholomu, umugqa noma iseli ehlukile.

Indlela 1. Ukukhipha izinto ezingeziwe ngemenyu yokuqukethwe

Le ndlela ilula ukuyisebenzisa futhi idinga ukuthi umsebenzisi alandele i-algorithm yezenzo ezilandelayo:

1. Khetha ububanzi bemigqa eyengeziwe ngenkinobho yegundane kwesokunxele.
2. Chofoza kwesokudla noma yikuphi endaweni ekhethiwe.
3. Ewindini lohlobo lokuqukethwe, chofoza igama elithi "Susa ...".

4. Hlola umphumela. Imigqa engenalutho kufanele ikhishwe, futhi uhlu lwethebula luzobuyela esimweni salo sangaphambilini. Ngokufanayo, ungakwazi ukususa amakholomu angadingekile etafuleni.

Indlela yesi-2: Hlehlisa isenzo sangaphambilini

Le ndlela ibalulekile uma umsebenzisi esusa imigqa ngokushesha ngemva kokuyengeza ohlwini lwethebula, ngaphandle kwalokho izenzo zangaphambilini nazo zizosuswa, futhi ngemva kwalokho kuzodingeka zenziwe futhi. I-Microsoft Office Excel inenkinobho ekhethekile ekuvumela ukuthi uhlehlise ngokushesha isinyathelo sangaphambilini. Ukuze uthole futhi wenze lo msebenzi usebenze, udinga ukuqhubeka kanje:

1. Susa ukukhetha zonke izici zeshidi ngokuchofoza i-LMB kunoma iyiphi indawo yamahhala.
2. Ekhoneni eliphezulu kwesokunxele kwesikrini eduze kwenkinobho "Ifayela", thola isithonjana ngendlela yomcibisholo oya kwesokunxele bese uchofoza kuso nge-LMB. Ngemuva kwalokho, isenzo sokugcina esenziwe sizosuswa, uma besingeza imigqa, izonyamalala.

3. Chofoza inkinobho yokuhlehlisa futhi uma kudingeka ukuze ususe izenzo ezimbalwa zangaphambilini.

Ulwazi Olwengeziwe! Ungakwazi ukuhlehlisa isinyathelo sangaphambilini ku-MS Excel usebenzisa inhlanganisela ye-hotkey Ctrl + Z ngokuyicindezela kanye kanye ukusuka kukhibhodi yekhompyutha. Nokho, ngaphambi kwalokho, udinga ukushintshela kusakhiwo sesiNgisi.

Ungawengeza kanjani amakholomu amaningi ngesikhathi esisodwa ku-Excel

Ukuze usebenzise le nqubo, uzodinga ukwenza cishe izinyathelo ezifanayo njengasesikhathini sokwengeza imigqa. I-algorithm yokuxazulula inkinga ingahlukaniswa ngezigaba ezilandelayo:

1. Kuhlu lwethebula, usebenzisa inkinobho yegundane engakwesokunxele, khetha inani lamakholomu anedatha egcwele ofuna ukuyengeza.

2. Chofoza kwesokudla noma yikuphi endaweni ekhethiwe.
3. Kumenyu yokuqukethwe evelayo, chofoza i-LMB kulayini "Faka ...".
4. Ewindini lokwengeza amaseli elivulekayo, khetha inketho ethi “Ikholomu” ngokushintshashintsha, bese uchofoza okuthi “KULUNGILE”.

5. Hlola umphumela. Amakholomu angenalutho kufanele engezwe ngaphambi kwendawo ekhethiwe ohlwini lwethebula.

Nakani! Ewindini lokuqukethwe, udinga ukuchofoza inkinobho ethi "Faka ...". Kukhona futhi umugqa "Namathisela" ojwayelekile, owengeza izinhlamvu ezikopishwe ngaphambilini ukusuka ebhodini lokunamathisela kuya kuseli ekhethiwe.

Isiphetho

Ngakho, ku-Excel kulula kakhulu ukwengeza imigqa noma amakholomu amaningana etafuleni eselilungisiwe. Ukuze wenze lokhu, udinga ukusebenzisa enye yezindlela ezixoxwe ngenhla.