Lapho wenza imisebenzi ku-Excel, kungadingeka ukuthi ususe amaseli angenalutho. Imvamisa into engadingekile futhi ikhulisa kuphela inani ledatha eliphelele kunomsebenzisi odidekile. Sichaza izindlela ngangokunokwenzeka ngokushesha ususe izinto ezingenalutho.
Susa ama-algorithms
Okokuqala, udinga ukuthola, futhi kungenzeka ngempela ukususa amaseli angenalutho ekhasini elithile noma etafuleni? Le nqubo iholela ekuchithweni kwedatha, futhi lokhu akuvumelekile ngaso sonke isikhathi. Ngamafuphi, izinto zingasuswa kuphela ezimweni ezimbili:- Uma intambo (ikholomu) ingenalutho ngokuphelele (ematafuleni);
- Uma amaseli engxenyeni nekholamu axhumekile kahle (ezinhlwini).
Uma kunamaseli ambalwa angenalutho, angasuswa ngokuphelele kusetshenziswa indlela ejwayelekile yokususa incwadi. Kepha, uma kunenani elikhulu lezinto ezingenalutho, khona-ke kulokhu, le nqubo kumele isebenze.
Indlela 1: Ukukhetha kwamaqembu amaseli
Indlela elula yokususa izinto ezingenamsebenzi ukusebenzisa ithuluzi lokuhlukaniswa kwamaqembu amaseli.
- Sigqamisa ububanzi ephepheni lapho sizokwenza khona ukusebenza kosesho futhi sisuse izinto ezingenalutho. Chofoza inkinobho yokusebenza kukhibhodi F5.
- Kwethulwa iwindi elincane, elibizwa ngokuthi "ukuguqulwa". Sichofoza kukho inkinobho ethi "Hightlight ...".
- Iwindi elilandelayo livula - "Ukwabiwa kwamaqembu amaseli". Faka inkinobho yokushintshela esimweni esithi "Amaseli Angenalutho" kuyo. Yenza ngokuchofoza inkinobho ethi "KULUNGILE".
- Njengoba ubona, zonke izinto ezingenalutho zebanga elicacisiwe ziqokonyisiwe. Chofoza kunoma iyiphi yazo inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe esebenzisa imenyu yomongo, chofoza ku "Delete ..." into.
- Kuvulwa iwindi elincane lapho udinga ukukhetha ukuthi yini ngempela okufanele uyisuse. Shiya izilungiselelo ezizenzakalelayo - "amaseli, ngokushintshwa phezulu." Chofoza inkinobho ethi "KULUNGILE".
Ngemuva kwalokhu okukhohlisayo, zonke izinto ezingenalutho ngaphakathi kwebanga elibekiwe zizosuswa.
Indlela 2: Ukufometha okunemibandela nokuhlunga
Susa amaseli angenalutho angasetshenziswa futhi ngokusebenzisa ukufometha okunemibandela kanye nemininingwane yokuhlunga elandelayo. Le ndlela iyinkimbinkimbi ngokwedlulile okwedlule, kepha, noma kunjalo, abanye abasebenzisi bayayithanda. Ngaphezu kwalokho, kuyadingeka ukwenza ukubhuka ngokushesha ukuthi le ndlela ilungele kuphela uma amanani esekholomu efanayo futhi awunawo amafomula.
- Sigqamisa ibanga elizocubungula. Ukuba sethebhu yasekhaya, chofoza isithonjana esithi "Ukufometha Okunemibandela", okuyinto, nayo, etholakala ku-Tool Block "Styles". Iya entweni evule uhlu "Imithetho yokwabiwa kwamaseli". Uhlu lwezenzo oluvelayo, khetha isikhundla "ngaphezulu ...".
- Iwindi lokufometha elinemibandela livula. Ensimini yesobunxele faka inombolo "0". Ensimini efanele, khetha noma yimuphi umbala, kepha ungashiya izilungiselelo ezizenzakalelayo. Chofoza inkinobho ethi "KULUNGILE".
- Njengoba sibona, wonke amaseli webanga elicacisiwe lapho amanani aqokonyiswa khona ngombala okhethiwe, futhi ongenalutho wasala mhlophe. Uphinde wabela ububanzi bethu. Kuthebhu efanayo, i- "Ikhaya" Chofoza inkinobho ethi "Hort and Filter" etholakala eqenjini lokuhlela. Kumenyu evula, chofoza inkinobho ethi "Filter".
- Ngemuva kwalezi zenzo, njengoba sibona, isithonjana esifanekisela ukuhlunga savela entweni ephezulu yekholomu. Chofoza kuyo. Uhlu oluvula, luye kwinto "yohlobo lombala". Okulandelayo, eqenjini "Hlunga ngeseli yombala", khetha umbala okhethwe ngenxa yokufomatha okunemibandela.
Ungase futhi wenze okuhlukile. Chofoza isithonjana se-filtration. Kumenyu evela, susa ibhokisi lokuhlola kusuka esimweni esithi "esingenalutho". Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".
- Kunoma yikuphi kwalezo ezichazwe kukhetho lwangaphambilini, izinto ezingenalutho zizofihlwa. Sigqamisa ububanzi bamaseli asele. Kuthebhu yasekhaya, ku-Clipboard Izilungiselelo Block, yenza ngokuchofoza inkinobho ethi "Kopisha".
- Ngemuva kwalokho sigqamisa noma iyiphi indawo engenalutho ngokufanayo noma kwelinye ishidi. Yenza inkinobho yegundane kwesokudla kwesokudla. Kuhlu lwezenzo zomongo oluvela kumapharamitha wokufaka, khetha into "yenani".
- Njengoba ukwazi ukubona, ukufaka idatha kusebenze ngaphandle kokulondolozwa kokufomatha. Manje usungasusa ibanga eliphambili, bese ufaka eyodwa endaweni yayo esiyitholile ngesikhathi senqubo echazwe ngenhla, futhi ungaqhubeka nokusebenza nedatha endaweni entsha. Konke kuya ngemisebenzi ethile kanye nezinto eziza kuqala kumsebenzisi.
Isifundo: Ukufomatha okunemibandela ku-Excel
Isifundo: Ukuhlunga nokuhlunga idatha ukuze udlule
Indlela 3: Ukusetshenziswa kwefomula eyinkimbinkimbi
Ngaphezu kwalokho, kungenzeka ukuthi ususe amaseli angenalutho kusuka ku-array ngokusebenzisa ifomula eyinkimbinkimbi equkethe imisebenzi eminingana.
- Okokuqala, kuzodingeka sinikeze igama uhla olungaphansi koguquko. Sigqamisa le ndawo, sichofoza ngokuchofoza kwesokudla. Kumenyu eyenziwe yasebenza, khetha i- "Nikeza Igama ..." Into.
- Kuvulwa iwindi lokunikezwa igama. Ensimini ethi "Igama" sinikeza noma yiliphi igama elifanele. Isimo esiyinhloko - akufanele kube yizikhala. Isibonelo, sabela igama elithi "C_Pust". Akusekho zinguquko kulelo windi akudingi. Chofoza inkinobho ethi "KULUNGILE".
- Sigqamisa noma yikuphi ephepheni ngqo ububanzi obufanayo bamaseli angenalutho. Ngokufanayo, ngokuchofoza inkinobho yegundane kwesokudla futhi, ngokubiza imenyu yokuqukethwe, dlula kwi- "Abcese Igama ..." Into.
- Efasiteleni elivulayo, njengasesikhathini esedlule, nika noma yiliphi igama lale ndawo. Sinqume ukuyinikeza igama elithi "lingenalutho".
- Sigqamisa ngokuchofoza okokuqala kwenkinobho yegundane kwesobunxele, iseli lokuqala lobubanzi obunemibandela "obungenalutho" (ungaphumelela ngokuhlukile). Faka ifomula elilandelayo kulo:
= Uma (i-string () - Intambo (i-imeyili) +1> I-Essay (nge_posts) -Tetetons (nge-DVSSL (ikheli (elincane (elincanyana (nge-string (nge Nge_posts)); umugqa () - I-String (i-imeyili) +1); ikholomu (nge_plus); 4)))
Njengoba leli yifomula elifanayo, kuyadingeka ukucindezela ukhiye we-Ctrl + Shift + Enter ukususa ukubalwa esikrinini, esikhundleni sokucindezela okujwayelekile kwenkinobho ye-Enter.
- Kepha, njengoba sibona, sekugcwaliswe iseli elilodwa kuphela. Ukuze ugcwalise futhi uphumule, udinga ukukopisha ifomula yengxenye esele yebanga. Lokhu kungenziwa kusetshenziswa umaki wokugcwalisa. Faka isikhombisi engela elingaphansi kwesokudla selili eliqukethe umsebenzi ophelele. Isikhombisi kufanele siguqule sibe yisiphambano. Chofoza inkinobho yegundane kwesobunxele bese uyidonsa phansi kuze kube sekupheleni kwebhendi "ye-imeyili".
- Njengoba ubona, ngemuva kwalesi senzo, sinebanga lapho amaseli agcwalisiwe atholakala khona ngokulandelana. Kepha ngeke sikwazi ukwenza izenzo ezahlukahlukene ngale mininingwane, njengoba zihlotshaniswa nefomula ye-ARAY. Sikwabela lonke uhla lwe- "imeyili". Chofoza inkinobho ethi "Kopisha", okuthunyelwa kuthebhu "Yasekhaya" ku-Toolbar "yokushintshana kwe-Buffer".
- Ngemuva kwalokho, sabela uhlu lokuqala lwedatha. Chofoza inkinobho yegundane kwesokudla. Kuluhlu oluvula eqenjini le-Insert Parameters, chofoza isithonjana esithi "Inani".
- Ngemuva kwalezi zenzo, imininingwane izofakwa endaweni yokuqala yendawo yayo ngobubanzi obuqinile ngaphandle kwamaseli angenalutho. Uma ufisa, uhlu oluqukethe ifomula manje lungasuswa.
Isifundo: Ungawanikeza kanjani igama leseli ukuze udlule
Kunezindlela eziningana zokususa izinto ezingenamsebenzi ku-Microsoft Excel. Inketho ngokukhishwa kwamaqembu e-cell kuyinto elula futhi esheshayo. Kepha kunezimo ezihlukile. Ngakho-ke, njengezindlela ezingezekile, ungasebenzisa izinketho ngokuhlunga nokusetshenziswa kwefomula eyinkimbinkimbi.