Uma usebenzisa ama-spreadsheets e-Excel, ngezinye izikhathi kudingekile ukuvimbela ukuhlelwa kweseli. Lokhu kuyiqiniso ikakhulukazi emigqeni equkethe amafomula, noma okubhekiswe amanye amaseli. Ngempela, izinguquko ezingalungile ezenziwe kubo zingabhubhisa sonke isakhiwo sokubala. Kubalulekile ukuvikela idatha ematafuleni abalulekile ikakhulukazi kukhompyutha efinyeleleka kwabanye ngaphandle kwakho. Izenzo ezinzima zomuntu ongaphandle zingabhubhisa zonke izithelo zomsebenzi wakho uma idatha ethile ingavikelwe kahle. Ake sibheke ukuthi lokhu kungenziwa kanjani.
Nika amandla ukuvimbela iseli
Ku-Excel, akukho thuluzi elikhethekile elenzelwe ukuvimbela amaseli ngabanye, kodwa le nqubo ingafezwa ngokuvikela lonke ishidi.
Indlela 1: Nika amandla ukukhiya kuthebhu ethi "Ifayela"
Ukuze uvikele iseli noma uhla, kufanele wenze izenzo ezichazwe ngezansi.
- Khetha lonke ishidi ngokuchofoza etsheni elitholakala emkhakheni wezinkampani zokuxhumanisa ze-Excel. Chofoza inkinobho yesokudla yegundane. Emenyu yomongo ebonakalayo, iya ku- "Fometha amaseli ...".
- Iwindi lokushintsha ifomethi yamaseli azovuleka. Chofoza ithebhu "Isivikelo". Susa ukukhetha "Iseli elivikelwe". Chofoza inkinobho "Kulungile".
- Qinisekisa ububanzi ofuna ukuvimbela. Iya ewindini futhi "Fometha amaseli ...".
- Kuthebhu "Isivikelo" hlola ibhokisi "Iseli elivikelwe". Chofoza inkinobho "Kulungile".
Kodwa iqiniso liwukuthi ngemuva kwalokhu ububanzi bungakavikelwa. Kuyoba njalo kuphela uma sivula ukuvikelwa kwephepha. Kodwa ngesikhathi esifanayo, ngeke kwenzeke ukuthi ushintshe kuphela lawo maseli lapho sibheka khona amabhokisi okuhlola esiqeshini esilandelayo, nalabo okukhishwa khona ama-checkmark azohlala ehleliwe.
- Iya kuthebhu "Ifayela".
- Esigabeni "Imininingwane" chofoza inkinobho "Vikela incwadi". Ohlu oluvela, khetha into "Vikela ishidi lamanje".
- Izilungiselelo zokuvikela ishidi zivuliwe. Kumelwe kube khona uphawu lokuhlola eduze kwepharamitha "Vikela ishidi nokuqukethwe kwamaseli avikelwe". Uma ufisa, ungabeka ukuvimbela kwezenzo ezithile ngokushintsha izilungiselelo kumingcele engezansi. Kodwa, ezimweni eziningi, izilungiselelo ezizenzakalelayo, ukuhlangabezana nezidingo zabasebenzisi ukukhiya amabanga. Ensimini "Iphasiwedi yokukhubaza ukuvikelwa kweshidi" Kumele ufake noma yiliphi igama elingukhiye elizosetshenziselwa ukufinyelela izici zokuhlela. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".
- Enye iwindi ivula lapho iphasiwedi kufanele iphindwe khona. Lokhu kwenziwa ukuze uma umsebenzisi angena kuqala iphasiwedi engafanele, ngeke akwazi ukuvimbela kuze kube phakade ukufinyelela kokuhlela. Ngemuva kokungena ukhiye udinga ukuchofoza "Kulungile". Uma amaphasiwedi efana, ilokhi izoqedwa. Uma zingavumelani, kuzodingeka uphinde ufake.
Manje lezo zigaba esizikhethile ngaphambilini futhi kuzilungiselelo zokufometha zibeka ukuvikelwa kwazo ngeke zifinyeleleke ekuhleleni. Kwezinye izindawo, ungenza noma yiziphi izenzo bese ulondoloza imiphumela.
Indlela 2: Vumela ukukhiya ngokusebenzisa ithebhu yokubuyekeza
Kukhona enye indlela yokuvimbela ibanga kusuka ekuguqulweni okungadingeki. Noma kunjalo, le nketho ihluke kunendlela eyedlule kuphela ngoba yenziwa kwenye ithebhu.
- Sisusa futhi sisa amabhokisi wokuhlola eduze kwiparameter ye "Ivikeli evikelwe" efasiteleni lesifomethi lamabhande afanayo ngokufanayo ngendlela esenze ngayo endleleni yangaphambilini.
- Yiya kuthebhu "Ukubukeza". Chofoza inkinobho ethi "Vikela Ishidi". Le nkinobho itholakala ebhokisini lamathuluzi elithi "Izinguquko".
- Ngemuva kwalokho, iwindi lesistimu yokuvikela ishidi elivulekile livuleka, njengokuqala okuhlukile. Zonke izenzo ezengeziwe zifana ngokuphelele.
Isifundo: Indlela yokufaka iphasiwedi kufayela le-Excel
Vula ibanga
Uma uchofoza kunoma iyiphi indawo ebangeni elivaliwe noma uma uzama ukushintsha okuqukethwe kwalo, kuzovela umlayezo othi iseli livikelwe kusuka ekushintsheni. Uma wazi iphasiwedi futhi ngokucophelela ufuna ukuhlela idatha, kuzodingeka uthathe izinyathelo zokuvula ilokhi.
- Iya kuthebhu "Ukubukeza".
- On tape eqenjini lamathuluzi "Izinguquko" chofoza inkinobho "Susa ukuvikelwa kushidi".
- Iwindi livela lapho kufanele ufake iphasiwedi ebekiwe ngaphambilini. Emva kokungena udinga ukuchofoza inkinobho "Kulungile".
Emva kwalezi zenzo, ukuvikelwa kuzo zonke amaseli kuzosuswa.
Njengoba ungabona, naphezu kokuthi i-Excel ayinalo ithuluzi enembile yokuvikela iseli ethize, hhayi lonke ishidi noma incwadi, le nqubo ingenziwa ngamanye ama-manipulations engeziwe ngokushintsha ukufometha.
