Momwe mungabisire zolemba zonse mu Excel nthawi imodzi

Zolemba mu Microsoft Office Excel ndi zina zowonjezera zomwe wogwiritsa ntchito amamangirira ku chinthu china chamagulu a tebulo kapena ma cell angapo. Cholemba chimakulolani kuti mulembe zambiri mu selo limodzi kuti mukumbutse zinazake. Koma nthawi zina zolemba zimafunika kubisidwa kapena kuchotsedwa. Mmene tingachitire zimenezi tidzakambirana m’nkhani ino.

Momwe mungapangire cholemba

Kuti mumvetse bwino mutuwo, choyamba muyenera kuphunzira za njira zopangira zolemba mu Microsoft Office Excel. Sikoyenera kuganizira njira zonse zomwe zili mkati mwa nkhaniyi. Chifukwa chake, kuti tisunge nthawi, timapereka algorithm yosavuta kwambiri yomaliza ntchitoyi:

1. Dinani kumanja pa selo lomwe mukufuna kulembamo.
2. Pazenera lamtundu wankhaniyo, dinani LMB pamzere "Ikani note".

3. Bokosi laling'ono lidzawonekera pafupi ndi selo, momwe mungalowetse malembawo. Apa mutha kulemba chilichonse chomwe mukufuna malinga ndi wogwiritsa ntchito.

4. Mawuwo akalembedwa, muyenera kudina pa cell iliyonse yaulere mu Excel kuti mubise menyu. Chinthu chokhala ndi cholembera chidzalembedwa ndi makona atatu ofiira pakona yakumanja. Ngati wogwiritsa ntchito asuntha cholozera cha mbewa pamwamba pa seloli, mawu omwe alembedwawo adzawululidwa.

Tcherani khutu! Momwemonso, mutha kupanga cholemba cha cell iliyonse patsamba la Excel. Chiwerengero cha zilembo zomwe zalowa pawindo sizochepa.

Monga cholembera ku selo, mutha kugwiritsa ntchito osati zolemba zokha, komanso zithunzi zosiyanasiyana, zithunzi, mawonekedwe otsitsidwa pakompyuta. Komabe, ziyenera kumangirizidwa ku chinthu china chamagulu a tebulo.

Momwe mungabisire cholemba

Mu Excel, pali njira zingapo zochitira ntchitoyi, iliyonse yomwe imayenera kuganiziridwa mwatsatanetsatane. Izi zidzakambidwanso.

Njira 1: Bisani cholemba chimodzi

Kuti muchotse kwakanthawi chizindikiro cha selo imodzi mu gulu la tebulo, muyenera kuchita izi:

1. Gwiritsani ntchito batani lakumanzere la mbewa kuti musankhe chinthu chomwe chili ndi cholemba chomwe chiyenera kukonzedwa.
2. Dinani kumanja pagawo lililonse la cell.
3. Mu menyu omwe akuwoneka, pezani mzere "Chotsani cholembera" ndikudina pamenepo.

4. Onani zotsatira. Siginecha yowonjezera iyenera kutha.
5. Ngati kuli kofunikira, pawindo lomwelo la mtundu wamtundu, dinani pamzere "Sinthani cholemba" kuti mulembenso zolemba zomwe zidalembedwa kale, konzani zolakwikazo.

Njira 2. Momwe mungachotsere cholemba m'maselo onse nthawi imodzi

Microsoft Office Excel ili ndi ntchito yochotsa nthawi imodzi ndemanga pazinthu zonse zomwe zilipo. Kuti mugwiritse ntchito mwayiwu, muyenera kuchita izi:

1. Sankhani gulu lonse la tebulo ndi batani lakumanzere.
2. Pitani ku tabu ya "Review", yomwe ili pazida zapamwamba za pulogalamuyi.
3. M'gawo lomwe limatsegulidwa, zosankha zingapo zidzawonetsedwa. Zikatero, wogwiritsa ntchito ali ndi chidwi ndi batani la "Chotsani", lomwe lili pafupi ndi mawu akuti "Pangani Chidziwitso". Pambuyo kuwonekera, siginecha adzakhala basi zichotsedwa ku maselo onse a mbale anasankha.

Zofunika! Njira yobisira ma signature owonjezera omwe takambirana pamwambapa imatengedwa kuti ndi yapadziko lonse lapansi ndipo imagwira ntchito m'mapulogalamu onse.

Njira 3: Gwiritsani ntchito menyu yankhani kuti mubise ndemanga mu Excel

Kuti muchotse zilembo pamaselo onse patebulo nthawi imodzi, mutha kugwiritsa ntchito njira ina. Zimaphatikizapo kuchita manipulations awa:

1. Malinga ndi dongosolo lofanana lomwe lakambidwa m'ndime yapitayi, sankhani magulu omwe mukufuna patebulo.
2. Dinani kumanja pagawo losankhidwa la gulu la data la tabular ndi batani lakumanja la mbewa.
3. Pazenera lomwe limawonekera, dinani LMB kamodzi pamzere wa "Delete note".

4. Onetsetsani kuti mutachita sitepe yapitayi, zolemba zamaselo onse zimachotsedwa.

Njira 4: Bwezerani zochita

Popanga zolemba zingapo zolakwika, mutha kuzibisa chimodzi ndi chimodzi, kuzichotsa pogwiritsa ntchito chida chosinthira. M'malo mwake, ntchito iyi ikuchitika motere:

1. Chotsani zosankhidwa patebulo lonse, ngati zilipo, podina LMB pagawo laulere la tsamba la Excel.
2. Pakona yakumanzere kwa pulogalamuyo, pafupi ndi mawu akuti "Fayilo", pezani batani ngati muvi kumanzere ndikudina. Zomwe zidachitika komaliza ziyenera kuthetsedwa.
3. Mofananamo, akanikizire "Lekani" batani mpaka zolemba zonse zichotsedwa.

Njirayi ili ndi vuto lalikulu. Pambuyo podina batani lomwe limaganiziridwa, zofunikira zomwe wogwiritsa ntchito adachita atapanga siginecha zidzachotsedwanso.

Mfundo zofunika! Mu Excel, monga mkonzi aliyense wa Microsoft Office, Chotsani Chotsani chitha kuchitidwa pogwiritsa ntchito njira yachidule ya kiyibodi. Kuti muchite izi, muyenera kusintha kiyibodi ya kompyuta ku masanjidwe a Chingerezi ndikugwiranso mabatani "Ctrl + Z".

Kutsiliza

Chifukwa chake, zolemba mu Microsoft Office Excel zimagwira ntchito yofunika kwambiri popanga matebulo, kuchita ntchito yowonjezerera, kukulitsa chidziwitso chofunikira mu cell. Komabe, nthawi zina amafunika kubisidwa kapena kuchotsedwa. Kuti mumvetse momwe mungachotsere siginecha ku Excel, muyenera kuwerenga mosamala njira zomwe zili pamwambapa.