Momwe mungawonjezere mzere watsopano mu Excel

Mukamagwira ntchito ndi matebulo mu Excel, si zachilendo kuti muwonjezere mizere yatsopano. Ntchitoyi ndiyosavuta, koma imabweretsa zovuta kwa ogwiritsa ntchito ena. Kenako, tisanthula ntchitoyi, komanso ma nuances onse omwe angayambitse zovuta izi.

Momwe mungayikitsire mzere watsopano

Ziyenera kunenedwa nthawi yomweyo kuti njira yowonjezerera mzere watsopano mu Excel ndi yofanana ndi mitundu yonse, ngakhale pangakhale kusiyana pang'ono.

1. Choyamba, tsegulani/pangani tebulo, sankhani selo iliyonse pamzere pamwamba pomwe tikufuna kuyika mzere watsopano. Timadina kumanja pa cell iyi ndipo mumenyu yotsitsa dinani "Ikani ...". Komanso, pa ntchitoyi, mutha kugwiritsa ntchito makiyi otentha Ctrl ndi "+" (kukanikiza nthawi imodzi).
2. Pambuyo pake, bokosi la zokambirana lidzatsegulidwa momwe mungasankhe kuyika selo, mzere kapena mzere. Sankhani Insert Row ndikudina Chabwino.
3. Zonse zachitika, mzere watsopano wawonjezedwa. Ndipo, tcherani khutu, powonjezera mzere watsopano umatenga kuchokera pamzere wapamwamba zonse zomwe mungasankhe.

Zindikirani: Palinso njira ina yowonjezera mzere watsopano. Timadina kumanja pamzere womwe uli pamwambapa womwe tikufuna kuyika mzere watsopano ndikusankha chinthu cha "Ikani" kuchokera pamenyu yomwe ikuwoneka.

Momwe mungayikitsire mzere watsopano kumapeto kwa tebulo

Nthawi zina zimakhala zofunikira kuwonjezera mzere watsopano kumapeto kwa tebulo. Ndipo ngati muwonjezera momwe tafotokozera pamwambapa, sizidzagwera patebulo lokha, koma lidzakhala kunja kwa dongosolo lake.

1. Poyamba, timasankha mzere wonse womaliza wa tebulo podina batani lakumanzere pa nambala yake. Kenako sunthani cholozera pakona yakumanja kwa mzere mpaka atasintha mawonekedwe ake kukhala "mtanda".
2. Kugwira "mtanda" ndi batani lakumanzere, kokerani pansi ndi chiwerengero cha mizere yomwe tikufuna kuwonjezera, ndikumasula batani.
3. Monga tikuonera, mizere yatsopano yonse imadzadzidwa ndi deta yochokera ku selo yobwerezedwa ndi masanjidwe osungidwa. Kuti muchotse zomwe zadzaza zokha, sankhani mizere yatsopano, kenako dinani batani la "Delete". Mukhozanso kudina kumanja pamaselo osankhidwa ndikusankha "Chotsani zomwe zili" kuchokera pamenyu yomwe imatsegulidwa.
4. Tsopano ma cell onse ochokera m'mizere yatsopano alibe, ndipo titha kuwonjezera deta yatsopano kwa iwo.

Zindikirani: Njirayi ndi yoyenera pamene mzere wapansi sunagwiritsidwe ntchito ngati mzere wa "Total" ndipo suphatikiza zonse zam'mbuyo.

Momwe mungapangire tebulo lanzeru

Kuti mugwiritse ntchito ku Excel, mutha kugwiritsa ntchito matebulo "anzeru". Gome ili ndi losavuta kutambasula, kotero simuyenera kudandaula ngati mwadzidzidzi simunawonjezere nambala yofunikira ya mizere. Komanso, potambasula, mafomu omwe adalowetsedwa kale "sagwa" patebulo.

1. Timasankha gawo la ma cell omwe ayenera kuphatikizidwa patebulo la "smart". Kenako, kupita "Home" tabu ndi kumadula "Format monga Table". Tidzapatsidwa zosankha zambiri zamapangidwe. Mutha kusankha chilichonse chomwe mungafune, chifukwa pazochita zonse ndi zofanana.
2. Titasankha kalembedwe, zenera lomwe lili ndi ma coordinates omwe adasankhidwa kale lidzatsegulidwa patsogolo pathu. Ngati zikutikomera, ndipo sitikufuna kusintha, dinani batani "Chabwino". Komanso, ndi bwino kusiya bokosi "Table with headers", ngati zili choncho.
3. Gome lathu "lanzeru" ndi lokonzekera ntchito ina nalo.

Momwe mungayikitsire mzere watsopano mu tebulo lanzeru

Kuti mupange chingwe chatsopano, mungagwiritse ntchito njira zomwe tafotokozazi.

1. Ndikokwanira kudina kumanja pa selo iliyonse, sankhani "Ikani" ndiyeno - chinthucho "Mizere ya tebulo pamwamba".
2. Komanso, mzere ukhoza kuwonjezeredwa pogwiritsa ntchito makiyi otentha Ctrl ndi "+", kuti musataye nthawi pazinthu zowonjezera pa menyu.

Momwe mungayikitsire mzere watsopano kumapeto kwa tebulo lanzeru

Pali njira zitatu zowonjezerera mzere watsopano kumapeto kwa tebulo lanzeru.

1. Timakokera kumunsi kumanja kwa tebulo, ndipo imangotambasula (mizere yambiri momwe tingafunire).Panthawiyi, ma cell atsopano sadzadzazidwa okha ndi deta yoyambirira (kupatula ma fomula). Choncho, sitiyenera kuchotsa zomwe zili, zomwe ndi zabwino kwambiri.

   

2. Mutha kungoyamba kulowetsa deta pamzere pansi pa tebulo, ndipo ingokhala gawo la tebulo lathu la "anzeru".
3. Kuchokera pansi kumanja kwa tebulo, ingodinani batani la "Tab" pa kiyibodi yanu.Mzere watsopano udzawonjezedwa zokha, poganizira zonse zomwe mungasankhe patebulo.

   

Kutsiliza

Chifukwa chake, pali njira zingapo zowonjezerera mizere yatsopano mu Microsoft Excel. Koma kuti muchotse zovuta zambiri kuyambira pachiyambi, ndi bwino kugwiritsa ntchito mawonekedwe a tebulo "anzeru", omwe amakulolani kuti mugwiritse ntchito deta ndi chitonthozo chachikulu.