Ungawangeza kanjani amaseli ku-Excel. Izindlela ezi-3 zokwengeza amaseli kusipredishithi se-Excel

Kuphephile ukusho ukuthi bonke abasebenzisi bayazi ukuthi bangeza kanjani iseli elisha kuthebula le-Excel, kodwa akubona bonke abazaziyo zonke izinketho ezivumelekile zokwenza lo msebenzi. Sekukonke, izindlela ezi-3 ezihlukene ziyaziwa, zisebenzisa ukuthi kungenzeka yini ukufaka iseli. Ngokuvamile isivinini sokuxazulula izinkinga sincike endleleni esetshenzisiwe. Ake sicabangele ngokuningiliziwe ngosizo lokuthi yiziphi izindlela ongangeza ngazo amaseli kuthebula le-Excel.

Yengeza amaseli kuthebula

Inani elikhulu labasebenzisi likholelwa ukuthi ngenkathi wengeza amaseli, inani lawo eliphelele liyanda njengoba isici esisha sivela. Nokho, lokhu akulona iqiniso, ngoba inani labo eliphelele lizohlala lifana. Eqinisweni, lokhu ukudluliselwa kwesici ukusuka ekugcineni kwetafula ukuya endaweni edingekayo ngokukhishwa kwedatha yeseli elihanjisiwe. Ngenxa yalokhu, umuntu kufanele aqaphele lapho ethutha, ngoba kungenzeka ukulahlekelwa ulwazi oluthile.

Indlela 1: Ukusebenzisa Imenyu Yokuqukethwe Kwamaseli

Indlela ecatshangelwayo isetshenziswa kaningi kunezinye, njengoba ithathwa njengelula ukuyisebenzisa. Ukwengeza amaseli ngendlela efanayo, kufanele ulandele i-algorithm elandelayo yezenzo:

1. Sibeka i-mouse pointer engxenyeni ethile yedokhumenti lapho ufuna ukwengeza khona i-elementi. Ngemuva kwalokho, sibiza imenyu yokuqukethwe yento ekhethiwe ngokucindezela i-RMB bese ukhetha "Faka ..." ohlwini lwe-pop-up lwemiyalo.

1. Iwindi elinezinketho lizovela kusiqapha. Manje kufanele uhlole ibhokisi eliseduze nombhalo othi “Amaseli”. Kunezindlela ezi-2 zokufaka - ngokushintsha kwesokudla noma phansi. Khetha inketho edingekayo esimweni sakho esithile bese uchofoza OK.
2. Ngemuva kwalokho, ungabona ukuthi kuzovela i-elementi entsha esikhundleni seyokuqala, ihanjiswe phansi kanye nezinye.

Kungenzeka ukwengeza amaseli amaningi ngendlela efanayo:

1. Inombolo efunekayo yamaseli ikhethiwe. Imenyu yokuqukethwe ibizwa ngokuchofoza kwesokudla ebangeni elishiwo bese ukhetha "Faka ...".

2. Ngokukhethwa kukho okungenzeka, khetha okufunayo bese uchofoza "Kulungile".
3. Amaseli amasha azovela esikhundleni salawo amakiwe, ahanjiswe kwesokudla kanye namanye.

Indlela yesi-2: Ukusebenzisa Ithuluzi Elikhethekile Kumenyu Eyinhloko

1. Njengasendabeni yangaphambilini, kufanele uqale ubeke isikhombi segundane endaweni lapho kuzokwakhiwa khona iseli eyengeziwe. Okulandelayo, kumenyu, udinga ukukhetha ithebhu ethi "Ikhaya", emva kwalokho udinga ukuvula isigaba "Amaseli", lapho uchofoza umbhalo othi "Faka".

2. Iseli yengezwa ngokushesha endaweni ephawuliwe. Kodwa ngale ndlela yokufaka, ukushintshwa kwenzeka kuphela phansi, okungukuthi, ngeke kwenzeke ukufaka iseli ngokushintshwa ngakwesokudla ngendlela okukhulunywa ngayo.

Ngokufanisa nendlela yokuqala, kunenketho yokwengeza amaseli amaningi:

1. Khetha inombolo oyifunayo yamaseli emugqeni (ngokuvundlile). Okulandelayo, chofoza umbhalo othi "Faka".

2. Ngemva kwalokho, amaseli engeziwe azokwengezwa nezinto ezikhethiwe zihanjiswe phansi kanye nezinye.

Okulandelayo, cabanga ukuthi kwenzekani uma ungakhethi irowu enamaseli, kodwa ikholomu:

1. Kuyadingeka ukukhetha amaseli omugqa oqondile bese uchofoza umbhalo othi "Faka" kuthebhu eyinhloko.
2. Esimeni esinjalo, amaseli azokwengezwa ngokushintshela kwesokudla sebanga elimakiwe kanye nama-elementi abekade kwesokudla kwawo.

Kuyafaneleka futhi ukugxila endleleni yokwengeza uhla lwamaseli olufaka uchungechunge lwezinto eziqondile nezivundlile:

1. Ngemuva kokukhetha ibanga elidingekayo, kwenziwa izenzo ezijwayelekile, okungukuthi, kuthebhu ethi "Ekhaya", udinga ukuchofoza kumbhalo othi "Faka".
2. Manje ungabona ukuthi izakhi ezingeziwe zehliselwa phansi.

Uma ungeza ububanzi bamaseli, inani lemigqa namakholomu eliwaqukethe lidlala indima ebalulekile:

• Uma ububanzi bunemigqa eqonde phezulu kunemigqa evundlile, amaseli engeziwe azohanjiswa phansi uma engezwa.
• Uma ububanzi bunemigqa evundlile eminingi kunemigqa eqondile, amaseli azohanjiswa kwesokudla uma engezwa.

Uma udinga ukuchaza kusengaphambili ukuthi iseli lifakwa kanjani, kufanele kwenziwe kanje:

1. Indawo lapho iseli (noma eminingana) izofakwa khona igqanyisiwe. Bese udinga ukukhetha ingxenye ethi "Amaseli" bese uchofoza isithonjana sikanxantathu ohlanekezelwe eduze kokuthi "Namathisela". Kumenyu ye-pop-up, chofoza okuthi "Faka amaseli ...".
2. Okulandelayo, iwindi elinezinketho liyavela. Manje udinga ukukhetha inketho efanele bese uchofoza "OK".

Indlela yesi-3: Namathisela Amaseli Usebenzisa Okhiye Abashisayo

Abasebenzisi abathuthuke kakhulu bezinhlelo ezihlukahlukene balungiselela inqubo ngokusebenzisa izinhlanganisela eziyinhloko ezidizayinelwe le njongo. В I-Excel futhi inezinombolo zezinqamuleli zekhibhodi ezikuvumela ukuthi wenze imisebenzi eminingi noma usebenzise amathuluzi ahlukahlukene. Lolu hlu luhlanganisa nesinqamuleli sekhibhodi sokufaka amaseli engeziwe.

1. Okokuqala udinga ukuya endaweni lapho uhlela ukufaka iseli (ububanzi). Okulandelayo, cindezela ngokushesha izinkinobho "Ctrl + Shift + =".

2. Iwindi elijwayelekile liyavela elinezinketho zokunamathisela. Okulandelayo, udinga ukukhetha inketho oyifunayo. Ngemuva kwalokho, kusala kuphela ukuchofoza okuthi "KULUNGILE" ukuze kuvele amaseli engeziwe.

Isiphetho

Isihloko saxoxa ngazo zonke izinhlobo zezindlela zokufaka amaseli engeziwe kusipredishithi se-Excel. Ngayinye yalezi zifana nezinye mayelana nendlela yokuqaliswa kanye nomphumela ozuziwe, kodwa yiziphi izindlela okufanele zisetshenziswe okufanele zinqunywe ngokusekelwe ezimweni. Indlela elula kakhulu yileyo ehlanganisa ukusebenzisa isinqamuleli sekhibhodi esihloselwe ukufakwa, nokho, empeleni, abasebenzisi abaningi bavame ukusebenzisa imenyu yokuqukethwe.