Ungaqhubeka kanjani etafuleni ku-Excel

Indlela yoku-1: Ithuluzi likasayizi wamathuluzi

Ithuluzi elithi "Usayizi wetafula" likuvumela ukuthi uhlele itafula eliqediwe ngokushintsha uhla lwalo ngokufaka amanani amasha. Uma ungakadaleli itafula elinjalo ongalihlela, lenze, kulandela incazelo engezansi, bese uthola ukuthi ungashintsha kanjani usayizi wayo uma udinga isidingo.

1. Ngesikhathi sokudalwa kwamaseli afakwe etafuleni eligcwele eligcwele, ungacacisa ngokushesha imigqa ngomugqa ukuze ungaqhubeki. Ukuze wenze lokhu, qokomisa wonke amaseli adingekayo ngokubamba inkinobho yegundane kwesobunxele.



2. Vula Faka ithebhu.



3. Nweba isigaba sokuqala esithi "Amatafula".



4. Kumenyu evela, khetha inketho efanelekile yokwakha itafula ngokufunda ngezici zencazelo ngayinye yonjiniyela.



5. Lapho kudala indawo yedatha kuboniswa ngokuya ngamaseli akhethiwe, ngakho-ke akudingekile ukushintsha ipharamitha.



6. Ithebula lalivele lenziwe ngomugqa wezintambo, ngakho-ke ukuqhubeka kwalo ngeke kudingeke.

Uma itafula lenziwe ngaphambili, kuzodingeka wenze okuhlukile:

1. Kuthebhu yomklami, chofoza inkinobho ethi "Usayizi wethebula".



2. Kuzovela iwindi lapho kufakwa khona ububanzi obusha ngokubalwa kwesandiso setafula, bese uqinisekisa izinguquko.



3. Buyela etafuleni futhi uqiniseke ukuthi zonke izenzo ziqediwe kahle futhi umphumela uyakufanela.

Manje, lapho nje ukunwetshwa kwetafula kuyadingeka futhi, shayela leli thuluzi bese usetha amanani amasha ukwengeza inani elidingekayo lemigqa.

Indlela 2: Amatafula wemenyu yomongo

Lapho usebenza ngetafula eliqediwe lokunwetshwa, ungasebenzisa imenyu yayo yokuqukethwe kanye nomsebenzi we- "Insert". Lokhu kuzokwengeza umugqa owodwa kuphela, kepha akukho okuzovimba imenyu ukufakwa kabusha ekwandisweni okukhulu kwetafula.

1. Chofoza enye yemigqa yetafula ngenkinobho yegundane efanele.



2. Kumenyu yokuqukethwe, khetha i-"Faka" String.



3. Intambo engenalutho izongezwa endaweni yetafula lapho kwenziwa khona i-PKM.

Indlela 3: "Cell" imenyu

Kumenyu ethi "Cell", kunesici esihlukile sokufaka izintambo ezizosiza uma indawo etafuleni selivele liphelile. Isebenza leli thuluzi ngokufana nelokuqala, kepha libizwa ngokuhlukile.

1. Kuthebhu yasekhaya, khulisa ingxenye ethi "Cell".



2. Ephaneli elivelayo, chofoza okuthi "Namathisela".



3. Khetha inketho yokufaka izintambo ekhasini noma amakholomu, kuya ngokuthi itafula liqhubeka ngaluphi uhlangothi.

Uma uvame ukuhlangana nesidingo sokwandisa amatafula, unake izinketho zabo ze- "Smart" zabo. Mayelana nokwakha izinto ezinjalo ku-Excel, funda isihloko esingezansi.

Funda kabanzi: Kusetshenziswa amatafula "smart" ku-Microsoft Excel