Ungakususa kanjani ukufometha etafuleni ku-Excel?

I-Echo Dot Smart Somlomo

Izinhlelo zakamuva ze-Microsoft Excel zinikeza amathuluzi amangalisayo nasheshayo, njengokufometha okuzenzakalelayo okuthuthuke kakhulu kwamatafula. Kulungile, kodwa ngiqaphele ngosuku lokugcina ukuthi akunakwenzeka ukuhlanganisa ububanzi bamaseli, isibonelo, lapho uguqula ithebula.

Futhi lapho, phof! ...ayikho indlela yokususa lokho kufometha okubi kakhulu 😕 ...Kukhona i-[CTRL+Z]…kodwa kungazelelwe konke ukuhlela okuphakathi kuyalahleka nakho.

Eqinisweni, yebo, kungenzeka. Kodwa hhayi ngempela deductible.

Ukususa kanjani ukufometha kuthebula le-Excel

Ungakususa kanjani ukufometha etafuleni ku-Excel?

Ukuze ubuyele ekuqaleni, ifomethi yethebula yenziwa kusukela kuthebhu yokuqala:

  • khetha amaseli etafula lakho
  • chofoza uhla “Ukufometha Okunemibandela"> “Ukufometha Kwethebula”. Okufanele ukwenze ukuchofoza umbala okhethiwe:

Umphumela wobuhle, nethuba lokuhlela ngamakholomu, ama-subtotals, njll.

Ukususa le logic yokufometha kungasho ukuthi sithole inkinobho ethi "Susa Ukufometha" noma "Khipha Isitayela". Yebo ikhona! Kodwa hhayi deductible kakhulu:

  • chofoza iseli yetafula
  • Chofoza kuthebhu ethi “Indalo,” ngaphansi kokuthi “Amathuluzi Ethebula” avele phezulu kwesokudla
  • Chofoza "Izitayela Ezisheshayo"
  • bese ekugcineni uchofoza okuthi "Susa" ezansi kwemenyu eyayinesayithi.

Kodwa nakhu. Isitayela sisusiwe, kodwa ukufometha kwethebula kusekhona! Kwezinye izinkulumo, ayikabi khona indlela yokuhlanganisa amaseli, isibonelo :)

Futhi yilapho iqhinga lingena khona (TADAAA 8)!):

  • Phinda izinyathelo zokuqala ezi-2 ngenhla ukuze ufike "Kumathuluzi Okudala" ethebula lakho
  • Futhi lapho (bekufanele ngabe uyazi…), chofoza okuthi “Guqulela Ububanzi”

Futhi kukhona isimangaliso! Uthola ithebula lokuqala (elinemibala emihle njenge-plus uma ungazange usisuse isitayela ngaphambilini).

Tommy Banks
Sizojabula ukuzwa lokho okucabangayo

shiya impendulo

I-TechnoBreak | Izipesheli nezibuyekezo
Logo
Nika amandla ukubhaliswa kuzilungiselelo - jikelele
Inqola yokuthenga