Lapho usebenza namatafula, kuvame ukudingeka ukubala amakholomu. Yiqiniso, lokhu kungenziwa ngesandla, ngokufaka ngokwehlukana inombolo yekholomu ngayinye kusuka kwikhibhodi. Uma kunamakholomu amaningi etafuleni, kuzothatha isikhathi esiningi. Ku-Excel kunamathuluzi akhethekile avumela ukubhala ngokushesha. Ake sibone ukuthi basebenza kanjani.
Izindlela Zokubala
Kunamanani amaningi okukhethwa kukho ikholomu othomathikhi ku-Excel. Ezinye zazo zilula futhi zicacile, ezinye kunzima ukuziqonda. Ake sibheke ngamunye wabo ngokuningiliziwe ukuze siphethe ukuthi iyiphi inketho yokusebenzisa ngokuthe xaxa kwimeko ethile.
Indlela 1: Gcwalisa uMakaki
Indlela evelele kakhulu yokubhala ngokuzenzakalelayo amakholomu, yiqiniso, ukusetshenziswa komaka wokugcwalisa.
- Vula ithebula. Engeza umugqa kuwo, lapho ukubalwa kwamakholomu kuzobekwa khona. Ukwenza lokhu, khetha noma yiliphi iseli lomugqa ozoba ngokushesha ngaphansi kwenombolo, chofoza ngakwesokudla, ngaleyo ndlela ubiza imenyu yesimo. Kulolu hlu, khetha into "Namathisela ...".
- Iwindi lokufaka elincane livula. Hambisa inkinobho ukuma "Engeza umugqa". Sicindezela inkinobho "Kulungile".
- Beka inombolo esitokisini sokuqala komugqa ongezeziwe "1". Bese uhambisa isikhombisi ekona elingezansi kwesokudla sale seli. I-cursor iyaphenduka ibe isiphambano. Ibizwa ngokuthi uphawu lokugcwalisa. Ngesikhathi esifanayo ubambe inkinobho yesinxele yesinxele neskhiye Ctrl kwikhibhodi. Hudula isibambo sokugcwalisa ngakwesokudla kuze kube sekupheleni kwethebula.
- Njengoba ubona, umugqa osudinga ugcwele izinombolo ngokulandelana. Okusho ukuthi, amakholomu abalwa.
Ungenza futhi okuhlukile. Gcwalisa amaseli amabili okuqala emgqeni ongeziwe ngezinombolo. "1" futhi "2". Khetha kokubili amaseli. Setha isikhombisi ekhoneni elingezansi elingakwesokudla ngakwesokudla. Ngenkinobho yegundane egcinwe phansi, sidonsela isibambo sokugcwalisa ekupheleni kwetafula, kodwa manje kulesihluthulelo Ctrl Asikho isidingo sokucindezela. Umphumela uzoba okufanayo.
Nakuba inguqulo yokuqala yale ndlela ibonakala ibe lula, kodwa, noma kunjalo, abasebenzisi abaningi bakhetha ukusebenzisa lesibili.
Kukhona enye inketho yokusebenzisa ithokheni yokugcwalisa.
- Esitokisini sokuqala, bhala inombolo "1". Ukusebenzisa ikhophi yomaka ikhophi kokuqukethwe ngakwesokudla. Ngesikhathi esifanayo futhi inkinobho Ctrl Asikho isidingo sokuphoqa.
- Ngemuva kokuthi ikhophi iphelile, sibona ukuthi yonke umugqa ugcwele inombolo "1". Kodwa sidinga ukubalwa ngokulandelana. Chofoza kusithonjana esibonakala eduze kweseli esanda kugcwaliswa. Uhla lwezenzo luvela. Sifaka inkinobho endaweni "Gcwalisa".
Ngemva kwalokho, wonke amaseli ebangeni elikhethiwe azogcwaliswa ngezinombolo ngokulandelana.
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Indlela yesi-2: Ukubala nenki "Gcwalisa" ku-ribbon
Enye indlela yokubala amakholomu ku-Microsoft Excel kuhilela ukusebenzisa inkinobho "Gcwalisa" kwi-tape.
- Ngemuva komugqa wengezwa ukubala izinkomba, faka inombolo esitokisini sokuqala "1". Khetha yonke umugqa wetafula. Ngenkathi kuthebhu "Ekhaya", chofoza inkinobho ebhethini. "Gcwalisa"esitholakala kwibhulogi yamathuluzi Ukuhlela. Imenyu yokudonsa ibonakala. Kulo, khetha into "Ukuqhubeka ...".
- Iwindi yokuhlela iwindi ivula. Yonke imingcele lapho kumele isilungiselelwe ngokuzenzakalelayo njengoba sidinga. Kodwa-ke, ngeke kube okungenakuqhathanisa ukuhlola isimo sabo. Ku-block "Indawo" inkinobho kufanele isethwe ukuze ibeke isikhundla "Emigqa". Kupharamitha "Thayipha" inani kufanele likhethwe "I-Arithmetic". Ukutholwa kwe-pitch okuzenzakalelayo kufanele kukhutshaziwe. Okungukuthi, akudingekile ukuthi uphawu lubekwe eduze kwegama lepharamitha elihambelanayo. Ensimini "Isinyathelo" hlola ukuthi inombolo "1". Inkambu "Inani elilinganiselwe" kumele ibe yize. Uma ngabe i-parameter ayihambisani nezikhundla ezizwakala ngenhla, yenza isimiso ngokuvumelana nezincomo. Ngemuva kokuthi uqinisekise ukuthi yonke imingcele igcwaliswe kahle, chofoza inkinobho. "Kulungile".
Ukulandela lokhu, amakholomu wetafula azobalwa ngokulandelana.
Awukwazi ngisho nokukhetha wonke umugqa, kodwa maneka kalula inombolo esitokisini sokuqala "1". Bese ushayele iwindi lezilungiselelo zokuqhubeka ngendlela efanayo njengoba kuchaziwe ngenhla. Yonke imingcele kufanele ifane nalabo esiwakhulume ngaphambili, ngaphandle kwenkambu "Inani elilinganiselwe". Kufanele ifake inani lamakholomu etafuleni. Bese uchofoza inkinobho "Kulungile".
Ukugcwalisa kuzokwenziwa. Okukhethwa kukho kokugcina kuhle kumathebula anenani elikhulu kakhulu lamakholomu, kusukela lapho usebenzisa, isikhombisi asidingeki sidonse noma kuphi.
Indlela 3: Umsebenzi we-COLUMN
Ungabala futhi amakholomu usebenzisa umsebenzi okhethekile, obizwa ngokuthi COLUMN.
- Khetha iseli lapho inombolo kufanele khona "1" ku-ikholomu yokubala. Chofoza inkinobho "Faka umsebenzi"kufakwe ngakwesokunxele kwe-bar yefomula.
- Ivula Umsebenzi weWebhu. Iqukethe uhlu lwemisebenzi ehlukahlukene ye-Excel. Sibheka igama "STOLBETS"ukhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano yokusebenza ivula. Ensimini "Xhumanisa" Kufanele unikeze isixhumanisi kunoma yisiphi iseli ekholomu yokuqala leshidi. Kuleli qophelo, kubaluleke kakhulu ukulalela, ikakhulukazi uma ikholomu yokuqala yetafula akuyona ikholomu yokuqala yeshidi. Ikheli lesixhumanisi singangena ngesandla. Kodwa kulula kakhulu ukwenza lokhu ngokubeka isikhombisi ensimini. "Xhumanisa"bese uchofoza iseli elifunayo. Njengoba ungabona, emva kwalokho, izixhumanisi zayo zikhonjiswa ensimini. Sicindezela inkinobho "Kulungile".
- Ngemuva kwalezi zenzo, inombolo ivela kuseli elikhethiwe. "1". Ukuze sibhale wonke amakholomu, sisekhoneni layo elingakwesokudla bese ushayele uphawu lokugcwalisa. Njengoba nje ezikhathini zangaphambilini, sidonsela ngakwesokudla ngasekupheleni kwetafula. Cindezela ukhiye Ctrl Asikho isidingo, chofoza nje inkinobho yegundane kwesokudla.
Ngemva kokwenza konke okushiwo ngenhla, wonke amakholomu wetafula azobalwa ngokulandelana.
Isifundo: I-Excel Function Wizard
Njengoba ubona, ukubalwa kwamakholomu ku-Excel kungenzeka ngezindlela eziningana. Okuthandwa kakhulu yilezi ukusetshenziswa komaka wokugcwalisa. Emathebula amaningi kakhulu, kunengqondo ukusebenzisa inkinobho. "Gcwalisa" ngokushintshwa kwezilungiselelo zokuqhubeka. Le ndlela ayifaki ukuphatha i-cursor kuyo yonke indiza yeshidi. Ngaphezu kwalokho, kukhona umsebenzi okhethekile COLUMN. Kodwa ngenxa yinkimbinkimbi yokusebenzisa nokuhlakanipha, le ndlela ayitholakali ngisho naphakathi kwabasebenzisi abakhulu. Yebo, futhi le nqubo ithatha isikhathi esiningi kunokusebenzisa okujwayelekile komaka wokugcwalisa.
