Ukususa njani ukufomatha kwitafile kwi-Excel?

I-Echo Dot Smart Somlomo

Iintlelo zamva nje zeMicrosoft Excel zibonelela ngezixhobo ezimangalisayo nezikhawulezayo, ezinje ngefomathi ephucukileyo yokufomatha iitafile. Kulungile, kodwa ndiqaphele usuku lokugqibela ukuba akunakwenzeka ukudibanisa uluhlu lweeseli, umzekelo, xa uguqula itafile.

Kwaye apho, phof! …akukho ndlela yokulususa olo lungiselelo lubi 😕 …Kukho ngokuqinisekileyo [CTRL+Z]…kodwa ngequbuliso lonke uhlele oluphakathi luyalahleka nalo.

Enyanisweni, ewe, kunokwenzeka. Kodwa hayi ngokwenene deductible.

Ukususa njani ukufomatha kwitafile kwi-Excel

Ukususa njani ukufomatha kwitafile kwi-Excel?

Ukubuyela ekuqaleni, ifomathi yetafile iqhutywa ukusuka kwithebhu yokuqala:

  • khetha iiseli zetafile yakho
  • cofa kuluhlu "UkuFomatha okuMiqathango"> "UkuFomatha kweTheyibhile". Okufuneka ukwenze kukucofa umbala okhethiweyo:

Isiphumo sobuhle, kunye nethuba lokuququzelela ngamakholomu, iitotali ezincinci, njl.

Ukususa le ngqiqo yokufomatha kuya kuyalela ukuba sithenge iqhosha elithi "Susa ukuFomatha" okanye "Susa isimbo". Ewe ikhona! Kodwa ayincitshiswa kakhulu:

  • cofa kwiseli yetafile
  • Cofa kwithebhu ethi "Creation", phantsi kwe "Table Tools" evele phezulu ekunene
  • Cofa ku-"Izimbo eziKhawuleza"
  • kwaye ekugqibeleni, nqakraza ku «Cima» ezantsi kwimenyu enendawo.

Kodwa nantsi. Isitayile sisusiwe, kodwa ukufomatha kwetafile kusekho! Kwezinye iintetho, akukabikho ndlela yokudibanisa iiseli, umzekelo :)

Kwaye kulapho iqhinga lingena khona (TADAAA 8)!):

  • Phinda amanyathelo ama-2 okuqala ngasentla ukuya "kwiZixhobo zokuDala" kwitafile yakho
  • Kwaye apho (kufanele ukuba uyazi…), cofa ku “Guqulela kwiRange”

Kwaye nanko ummangaliso! Ufumana itafile yokuqala (enemibala emihle njenge-plus ukuba awusisusanga isimbo ngaphambili).

Tommy Banks
Siya kuvuya ukuva ukuba ucinga ntoni

Shiya iMpendulo

TechnoBreak | Unikezelo kunye noPhononongo
Akukho mlinganiselo
Yenza ubhaliso kuseto-ngokubanzi
Isikhoji sokuthenga