Thola bese Ufaka esikhundleni ku-Excel

Thola bese Ufaka Faka esikhundleni ku-Excel iyithuluzi elinamandla futhi elisebenziseka kalula elikuvumela ukuthi uthole, futhi, uma kunesidingo, ufake kabusha imininingwane eshidini lokusebenzela. Njengengxenye yalesi sifundo, uzofunda ukuthi ungasesha kanjani endaweni enikeziwe yedokhumenti ye-Excel, futhi uguqule imininingwane etholakele ibe ivelu oyifunayo.

Lapho usebenza ngenani elikhulu ledatha ku-Excel, kwesinye isikhathi kuba nzima ukuthola noma yiluphi ulwazi oluthile. Futhi, njengomthetho, ukusesha okunjalo kuthatha isikhathi eside kakhulu. I-Excel inikeza ithuluzi elihle lokusesha. Ungathola kalula noma yiluphi ulwazi oludingayo encwadini yokusebenzela ye-Excel usebenzisa umyalo othi Thola, okuvumela futhi ukuthi uguqule idatha usebenzisa ithuluzi elithi Thola bese Ufaka esikhundleni.

Ukuthola Idatha Kumaseli e-Excel

Esibonelweni sethu, sizosebenzisa umyalo Thola ukuthola igama olifunayo ohlwini olude lwabasebenzi.

Uma ukhetha iseli elilodwa ngaphambi kokusebenzisa umyalo othi Thola, i-Excel izosesha lonke ishidi lokusebenza. Futhi uma ububanzi bamaseli, khona-ke kuphela ngaphakathi kwalobu bubanzi

  1. Kuthebhu ethi Ikhaya, sebenzisa umyalo othi Thola bese Khetha, bese ukhetha Thola ohlwini lokudonsela phansi.
  2. Ibhokisi lengxoxo elithi Thola futhi Umiselele liyavela. Faka idatha ezoseshwa. Esibonelweni sethu, sizofaka igama lesisebenzi.
  3. Chofoza okuthi Thola Okulandelayo. Uma idatha ikhona eshidini, izogqanyiswa.Thola bese Ufaka esikhundleni ku-Excel
  4. Uma uchofoza inkinobho ethi Thola Okulandelayo futhi, uzobona inketho yokusesha elandelayo. Ungaphinda ukhethe okuthi Thola Konke ukuze ubone zonke izinketho ezikutholele zona i-Excel.Thola bese Ufaka esikhundleni ku-Excel
  5. Uma usuqedile ukusesha, sebenzisa inkinobho ethi Vala ukuze uphume ebhokisini lengxoxo ethi Thola futhi Umiselele.Thola bese Ufaka esikhundleni ku-Excel

Ungafinyelela umyalo othi Thola ngesinqamuleli sekhibhodi u-Ctrl+F.

Ukuze ubone izinketho ezengeziwe zokuthola futhi Umiselele, chofoza inkinobho ethi Izinketho ebhokisini lengxoxo elithi Thola futhi Umiselele.

Thola bese Ufaka esikhundleni ku-Excel

Ukushintsha okuqukethwe kweseli ku-Excel

Kunezikhathi lapho kwenziwa iphutha eliphindaphindwayo kuyo yonke incwadi yokusebenzela ye-Excel. Isibonelo, igama lomunye alipelwanga kahle, noma igama elithile noma umusho udinga ukushintshwa ube omunye. Ungasebenzisa ithuluzi elithi Thola futhi Umiselele ukuze wenze izilungiso ngokushesha. Esibonelweni sethu, sizosebenzisa umyalo othi Faka esikhundleni ukulungisa uhlu lwamakheli e-imeyili.

  1. Kuthebhu ethi Ikhaya, chofoza okuthi Thola bese Ukhetha, bese ukhetha Faka esikhundleni ohlwini lokudonsela phansi.Thola bese Ufaka esikhundleni ku-Excel
  2. Ibhokisi lengxoxo elithi Thola futhi Umiselele liyavela. Faka umbhalo owufunayo kunkambu ethi Thola.
  3. Thayipha umbhalo ofuna ukufaka kuwo esikhundleni sombhalo otholiwe kokuthi Faka esikhundleni ngebhokisi. Bese uchofoza okuthi Thola Okulandelayo.Thola bese Ufaka esikhundleni ku-Excel
  4. Uma inani litholwa, iseli eliqukethe lizogqanyiswa.
  5. Bheka umbhalo bese uqinisekisa ukuthi uyavuma ukuwushintsha.
  6. Uma uvuma, bese ukhetha enye yezinketho zokumiselela:
    • Faka esikhundleni: Ilungisa inani elilodwa ngesikhathi.
    • Faka esikhundleni Konke: Ilungisa zonke izinhlobo zombhalo oseshiwe encwadini yokusebenzela. Esibonelweni sethu, sizosebenzisa le nketho ukuze songe isikhathi.

    Thola bese Ufaka esikhundleni ku-Excel

  7. Ibhokisi lengxoxo lizovela eliqinisekisa inani lokushintshwa okufanele kwenziwe. Chofoza okuthi KULUNGILE ukuze uqhubeke.Thola bese Ufaka esikhundleni ku-Excel
  8. Okuqukethwe kwamaseli kuzoshintshwa.Thola bese Ufaka esikhundleni ku-Excel
  9. Uma usuqedile, chofoza okuthi Vala ukuze uphume ebhokisini lengxoxo elithi Thola futhi Umiselele.Thola bese Ufaka esikhundleni ku-Excel

shiya impendulo