Lapho usebenza namatafula, ngokuvamile kuyadingeka ukubala amakholomu. Vele, lokhu kungenziwa ngesandla, ngokushayela inombolo ngenombolo ngayinye kukholomu. Uma itafula linamakholomu amaningi, kuzothatha isikhathi eside. I-Excel inamathuluzi akhethekile akwenza ukuba ushiye izinombolo ngokushesha. Ake sibheke ukuthi basebenza kanjani.
Izindlela Zokubala
Kunezindlela eziningi ongakhetha kuzo zokufaka amakholomu okuzenzakalelayo ku-Excel. Ezinye zazo zilula futhi ziyaqondakala, ezinye kunzima kakhulu ukuzibona. Masihlale kulowo nalowo wabo ukuze siphethe ukuthi iyiphi indlela ongayisebenzisa ekhiqiza kakhulu esimweni esithile.
Indlela yoku-1: gcwalisa umaki
Indlela ethandwa kakhulu yokuthola amakholomu ngokuzenzakalelayo ngokusebenzisa umaka wokugcwalisa.
- Sivula itafula. Faka umugqa kuwo, lapho kuzobekwa khona izinombolo zekholomu. Ukuze wenze lokhu, khetha noma isiphi iseli emugqeni ozoba ngaphansi kwenombolo ngokushesha, uchofoza ngakwesokudla, bese udonsela imenyu yokuqukethwe. Kulolu hlu, khetha "Namathisela ...".
- Kuvulwa iwindi lokufakwa okuncane. Guqula switch ibe isikhundla "Faka umugqa". Chofoza inkinobho "Kulungile".
- Faka inombolo esitokisini sokuqala somugqa ongeziwe "1". Ngemuva kwalokho hambisa isikhombisi ekhoneni elingezansi kwesokudla sale seli. Isikhombisi siphenduka isiphambano. Ibizwa ngokuthi umaki wokugcwalisa. Ngasikhathi sinye, bamba phansi inkinobho yesinxele nokhiye Ctrl kwikhibhodi. Donsela umaki wokugcwalisa ngakwesokudla ekugcineni kwetafula.
- Njengoba ukwazi ukubona, umugqa esiwudingayo ugcwele izinombolo ngokulandelana. Okusho ukuthi, ukufakwa kwamakholomu kwenziwa.
Ungase futhi wenze okunye. Gcwalisa amaseli amabili okuqala emugqeni ongeziwe ngezinombolo "1" futhi "2". Khetha womabili amaseli. Setha isikhombisi ekhoneni elingezansi kwesokudla kwesokudla sazo. Inkinobho yegundane icindezelwe, donsela umaki wokugcwalisa ekugcineni kwetafula, kepha kulokhu kube Ctrl asikho isidingo sokucindezela. Umphumela uzofana.
Yize inguqulo yokuqala yale ndlela ibonakala ilula, kepha noma kunjalo, abasebenzisi abaningi bakhetha ukusebenzisa owesibili.
Kukhona enye inketho yokusebenzisa umaka wokugcwalisa.
- Esitokisini sokuqala sibhala inombolo "1". Usebenzisa umaki, kopisha okuqukethwe kwesokudla. Kulokhu, phinda futhi inkinobho Ctrl asikho isidingo sokushaya.
- Ngemuva kokuthi ikhophi yenziwe, sibona ukuthi umugqa wonke ugcwele inombolo "1". Kepha sidinga ukufakwa izinombolo ngokulandelana. Sichofoza isithonjana esivele eduze kweseli lokugcina eligcwele. Uhlu lwezenzo luyavela. Setha ukushintshela esikhundleni Gcwalisa.
Ngemuva kwalokho, wonke amaseli ebanga elikhethiwe azogcwaliswa ngezinombolo ngokulandelana.
Isifundo: Ungayenza kanjani ngokuzenzakalela i-Excel
Indlela yesi-2: ukufakwa izinombolo kusetshenziswa inkinobho ethi "Gcwalisa" iribhoni
Enye indlela yokuthola amakholomu eMicrosoft Excel ukusebenzisa inkinobho Gcwalisa ekhasethini.
- Ngemuva kokuba umugqa wengeziwe ukufaka izinombolo, sifaka inombolo kuseli yokuqala "1". Khetha wonke umugqa wethebula. Ukuba kuthebhu ethi "Ikhaya", kubhagi chofoza inkinobho Gcwalisaetholakala kwibhulokhi yamathuluzi "Ukuhlela". Imenyu eyehlayo iyavela. Kuyo, khetha into "Ukuqhubeka ...".
- Iwindi lezilungiselelo zokuqhubekela phambili liyavula. Wonke amapharamitha lapho kufanele asevele amisiwe ngokuzenzakalelayo njengoba sidinga. Noma kunjalo, ngeke kube yinto engenamsoco ukubheka isimo sabo. Ebhlokini "Indawo" switch kufanele isethwe kuyo Umugqa ngomugqa. Ipharamitha "Thayipha" kumele kukhethwe "I-Arithmetic". Ukutholwa kwesinyathelo okuzenzakalelayo kumele kukhutshazwe. Lokho wukuthi, akudingekile ukuthi kube nophawu lokuhlola eduze kwegama lepharamitha elihambisanayo. Ensimini "Isinyathelo" hlola ukuthi inombolo iyini "1". Insimu "Umkhawulo wenani" kumele kungabi nalutho. Uma noma iyiphi ipharamitha ingahambisani nezikhundla ezivezwe ngenhla, lungiselela njengoba kunconyiwe. Ngemuva kokuthi uqinisekise ukuthi wonke amapharamitha agcwaliswe kahle, chofoza inkinobho "Kulungile".
Ngemuva kwalokhu, amakholomu etafula azobalwa ngokulandelana.
Awungeke ukhethe ngisho nomugqa wonke, kodwa mane ubeke idijithi esitokisini sokuqala "1". Bese ushayela iwindi lezilungiselelo zokuthuthuka ngendlela efanayo njengoba kuchazwe ngenhla. Wonke amapharamitha kufanele ahambisane nalawo esikhulume ngawo ngaphambili, ngaphandle kwenkundla "Umkhawulo wenani". Kufanele ibeke inani lamakholomu etafuleni. Bese uchofoza inkinobho "Kulungile".
Ukugcwaliswa kuzokwenziwa. Inketho yamuva ilungele amatafula anenombolo enkulu kakhulu yamakholomu, ngoba lapho uyisebenzisa, awudingi ukudonsela ikhesa noma kuphi.
Indlela 3: Umsebenzi we-ColUMN
Ungafaka nezinombolo kwikholamu usebenzisa umsebenzi okhethekile, othiwa IKHODI.
- Khetha iseli lapho inani kufanele libe khona "1" izinombolo zekholomu. Chofoza inkinobho "Faka umsebenzi"ibekwe kwesokunxele sebha lefomula.
- Iyavula Isici Wizard. Uqukethe uhlu lwemisebenzi ehlukahlukene ye-Excel. Sifuna igama AMA-STOLBETS, ikhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyavula. Ensimini Xhumanisa Kufanele ucacise ngesixhumanisi kunoma yisiphi iseli kukholamu lokuqala leshidi. Ngalesi sikhathi, kubaluleke kakhulu ukunaka, ikakhulukazi uma ikholomu yokuqala yetafula ingeyona ikholamu lokuqala lephepha. Ikheli lokuxhumanisa lingafakwa ngesandla. Kepha kulula kakhulu ukwenza lokhu ngokusetha isikhombisi enkundleni Xhumanisa, bese uqhafaza kuseli elifunayo. Njengoba ubona, ngemuva kwalokho, izixhumanisi zayo ziboniswa emkhakheni. Chofoza inkinobho "Kulungile".
- Ngemuva kwalezi zenzo, inombolo ivela esitokisini esikhethiwe "1". Ukuze sifake wonke amakholomu, simi ekhoneni lakhona elingaphansi kwesokudla bese sibiza umaki wokugcwalisa. Njengasezikhathini ezedlule, donsela ngakwesokudla ekugcineni kwetafula. Bamba ukhiye Ctrl asikho isidingo, vele uchofoze inkinobho yegundane elifanele.
Ngemuva kokuphothula zonke lezi zinyathelo ezingenhla, wonke amakholomu etafula azobalwa ngokulandelana.
Isifundo: Umsebenzi Wizard e-Excel
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokubala amakholomu ku-Excel. Okuthandwa kakhulu yilokhu ukusetshenziswa kwesikhombi sokugcwalisa. Amatafula amaningi kakhulu anengqondo ukusebenzisa inkinobho Gcwalisa ngokushintshela kuzilungiselelo zokuthuthuka. Le ndlela ayihlanganisi ukukhohlisa isikhombisi kuyo yonke indiza eshidi. Ngaphezu kwalokho, kukhona umsebenzi okhethekile. IKHODI. Kodwa ngenxa yobunzima bokusebenzisa nobuqili, le ndlela ayithandwa kakhulu phakathi kwabasebenzisi abathuthukile. Yebo, futhi le nqubo ithatha isikhathi esithe xaxa kunokusebenzisa okujwayelekile komaka wokugcwalisa.
