- Kunezindlela ezahlukene zokuhlanza amaspredishithi, kusukela ekusebenziseni amathuluzi okukhetha akhethekile kuya ekuhlungeni idatha.
- Ikhono lokubona ngokuzenzakalelayo amaseli angenalutho livumela ukuthi kususwe imiqulu emikhulu yemigqa ngaphandle kwengozi yokwenza iphutha lomuntu.
- Ukuhlela ulwazi ngokuhlela amakholomu kwenza kube lula ukuqoqa izikhala ezingenalutho ukuze kususwe ngesandla kamuva.
Uma siqala ukusebenza ngespredishithi se-Excel, kuvamile kakhulu ukuthi isakhiwo asikaqedwa ngokuphelele ekuqaleni. Ngemva kokwenza izinguquko ezimbalwa, ukuhambisa idatha, noma ukususa okuqukethwe, kuvamile ukuthi kugcine kunemigqa engenalutho engasizi ngalutho futhi ephazamisa umbono kuphela, okwenza idokhumenti ibukeke ingahlelekile.
Ungakhathazeki, ukuhlanza ispredishithi sakho akuyona isayensi enamandla kakhulu. Nakuba kungase kubonakale sengathi i-Excel ayinayo inkinobho ethi "susa konke okungenalutho" ngomlingo, iqiniso liwukuthi kunezindlela eziningana eziphumelelayo kakhulu zokwenza ithebula lakho lihleleke kahle ngokuchofoza okumbalwa nje, kuye ngokuthi ukhetha ukufika ngqo ephuzwini noma ube nokulawula okubonakalayo okwengeziwe ngalokho okwenzayo.
Icebo elithi "Go to Special" lokususa konke ngesikhathi esisodwa
Uma unesizindalwazi esikhulu se-Excel futhi ungafuni ukwenza izinto ngendlela exakile ngokususa okufakiwe ngakunye, umsebenzi wokusesha ungumngane wakho omkhulu. Isinyathelo sokuqala ukukhetha ikholomu lapho kutholakala khona izikhala. Uma usukhethile ububanzi, iya kuthebhu ethi Ikhaya, vula imenyu ethi "Thola & Khetha", bese uchofoza inketho ethi Go To Special.
Efasiteleni elincane elivulayo, maka ibhokisi elithi Amaseli angenalutho bese uchofoza u-Kulungile. Uzobona ukuthi, njengokungathi ngomlingo, i-Excel igqamise izikhala ezingenalutho kuphela. Manje, ngaphandle kokuthinta noma yini enye ukuze ungalahlekelwa ukukhetha, buyela kuthebhu ethi Ikhaya, uvule imenyu ethi "Susa", bese ukhetha ethi Susa Imigqa Yeshidi . Uhlelo luzosusa ngokuzenzakalelayo umugqa ngamunye lapho luthola khona isikhala esingenalutho.
Ukuhlanza ngesandla nangokubona kwabaqalayo
Uma unefayela elincane noma ukhetha ukubona ngqo ukuthi yini oyisusayo ukuze ugweme amaphutha, kunezindlela ezivamile ezengeziwe. Ungachofoza ngakwesokudla nje enombolweni yomugqa ongenalutho ku-Excel (emaphethelweni kwesobunxele kwesikrini) bese ukhetha inketho yokususa. Iyindlela ehamba kancane, kodwa ephephile uma ungajwayelene nethuluzi.
Enye inketho ukukhetha noma yiliphi iseli emgqeni ofuna ukulisusa, iya kuthebhu ethi Ikhaya, thola isigaba samaseli, bese ukhetha Susa Imigqa Yeshidi . Le nqubo ilungele uma unezikhala ezimbalwa ezingenalutho ngezikhathi ezithile futhi ufuna ukuzisusa ngokushesha ngaphandle kokusetha izihlungi noma usesho oluyinkimbinkimbi.
Ukusebenzisa izihlungi ukuphatha izikhala ezingenalutho
Izihlungi ziyithuluzi elinamandla elingasetshenziswa hhayi nje kuphela ukuhlaziya idatha kodwa futhi nokuyihlanza. Ukuze uqale, khetha ububanzi etafuleni lakho bese uya kuthebhu yedatha, uchofoze inkinobho ethi Hlunga . Uzobona imicibisholo ivela ezihlokweni zakho zekholomu.
Uma uchofoza omunye waleyo micibisholo, uzobona ukuthi ungakhetha ukuthi uzobonisa ini. Uma ukhetha inketho ethi Empty kuphela , i-Excel izofihla konke okunokuqukethwe, ikushiye nemigqa engenalutho kuphela. Ngaleso sikhathi, ungazikhetha zonke (uzobona izinombolo zomugqa zivela ngombala oluhlaza okwesibhakabhaka) bese uzisusa zonke ngesikhathi esisodwa . Uma ususa isihlungi, ithebula lakho lizohlanganiswa kahle.
Ukuhlela ngokuhlela idatha
Ngezinye izikhathi, indlela elula yokuhlela isiphithiphithi iwukuhlela kabusha izinto. Uma ukhetha idatha yakho bese usebenzisa umsebenzi Wokuhlunga kuthebhu yeDatha, ungakhetha ukuhleleka kokwenyuka noma ukwehla. Ngokwenza lokhu, i-Excel izohlanganisa ngokuzenzakalelayo yonke imigqa engenalutho ekugcineni noma ekuqaleni kwethebula.
Uma zonke izikhala sezihlanganisiwe ndawonye, asikho isidingo samathuluzi ayinkimbinkimbi: mane ukhethe ibhulokhi yemigqa engenalutho ngegundane lakho, chofoza kwesokudla, bese uyisusa. Kuyindlela ewusizo kakhulu uma ungakhathali ngokuhlelwa kwasekuqaleni kokushintsha kwamarekhodi akho.
Ukwazi lezi zindlela, kungaba ngokufinyelela okusheshayo nge-Ctrl + G ukuze useshe amanani angenalutho, ukusebenzisa izihlungi ezihlakaniphile, noma ukuhlela amakholomu okulula, kuvumela noma yimuphi umsebenzisi ukuthi agcine amadokhumenti akhe echwepheshile futhi engenamaphutha esakhiwo, okwenza isikhathi sokusebenza kanye nokufunda ulwazi kube lula.
