Mmene Mungagawire Kavalo mu Excel

Gwiritsani ntchito mawonekedwe osindikizira a Excel kuti muwone makope ambiri a tsamba limodzi. Kupukuta chinsaluchi kumagawaniza tsamba lomwe liripo pakali pano ndi / kapena kumbali ziwiri kapena zinayi zomwe zikukulolani kuti muone zofanana kapena zosiyana pa tsambali.

Kupukuta chinsalu ndi njira yowonjezerapo kuti muzisunga malemba kapena zolemba pazenera pamene mukupukuta. Kuphatikizanso, zowonongeka zingagwiritsidwe ntchito poyerekeza mizere iwiri kapena zigawo za deta zomwe zili mbali zosiyanasiyana za worksheet.

Kupeza Zowonongeka

1. Dinani pa tsamba labuboni .
2. Dinani pa chithunzi chogawidwa kuti mugawike chinsalu muzitsulo zinayi.

Zindikirani: Bokosi Lagawanika Lilibenso

Bokosi logawidwa, njira yachiwiri komanso yotchuka kwambiri yogawanika pulogalamuyi mu Excel, inachotsedwa ndi Microsoft kuyambira ndi Excel 2013.

Kwa omwe amagwiritsa ntchito Excel 2010 kapena 2007, malangizo ogwiritsira ntchito bokosi logawidwa angathe kupezeka pansipa.

Patulirani Pulogalamuyo Muzigawo ziwiri kapena Zinayi

Mu chitsanzo ichi, tidzang'amba sewero la Excel muzitsulo zinayi pogwiritsa ntchito chithunzi chogawidwa chomwe chili pa tsamba la View of Ribbon.

Njirayi ikugwira ntchito powonjezerapo mipiringidzo yowonongeka ndi yowongoka ku tsamba.

Patsamba lirilonse liri ndi pepala lonse lolembapo ndipo mipiringidzoyi ingagwiritsidwe ntchito payekha kapena palimodzi kuti ikuloleni kuti muwone mizere yosiyanasiyana ndi ndondomeko ya deta nthawi yomweyo.

Chitsanzo: Kupukuta Khungu Pakati Pazomwe Momwemo ndi Pansi

Masitepe omwe ali m'munsimu akuthandizani momwe mungagawire mawonekedwe a Excel onse pang'onopang'ono ndi phokoso pogwiritsa ntchito gawo lagawa.

Kuwonjezera Deta

Ngakhale kuti deta sichiyenera kupezeka pazithunzi zogawidwa kuti zigwire ntchito, zimakhala zosavuta kudziwa momwe mbaliyo imagwirira ntchito ngati pepala lokhala ndi deta likugwiritsidwa ntchito.

1. Tsegulani pepala lokhala ndi deta yolingalira bwino kapena kuwonjezera mizere yambiri ya deta - monga deta lowonedwa mu chithunzi pamwambapa - ku tsamba lokumbukira.
2. Kumbukirani kuti mungagwiritse ntchito chida chodzaza kuti mudzadziwe tsiku la sabata ndi mndandanda wa mitu yoyenera monga Sample1, Sample2 ndi zina.

Kupukuta Khunguli Pachinayi

1. Dinani pa tsamba labuboni.
2. Dinani pa chithunzi chogawidwa kuti mutsegule mbali yowonekera.
3. Zonse ziwiri zozembera ndi zowonongeka ziyenera kuoneka pakati pa tsamba.
4. Pazigawo zinayi zomwe zimapangidwa ndi magawo ogawidwa ayenera kukhala kopitiliza ntchito.
5. Payenera kukhala ndi mipiringidzo iwiri yowongoka kumbali yakumanja ya chinsalu ndi mipiringidzo iwiri yopingasa pansi pazenera.
6. Gwiritsani ntchito mipukutu ya mpukutu kuti muziyendayenda mu quadrant iliyonse.
7. Kukonzekera mipiringidzo yogawanika powakweza pa iwo ndi kuwakokera iwo ndi mbewa.

Kupukuta Khungu Pachiwiri

Kuti muchepetse chiwerengero cha zojambula ziwiri, kwezani imodzi ya mipiringidzo iwiri pamwamba kapena kumanja kwa chinsalu.

Mwachitsanzo, kuti pulojekiti igawanike pang'onopang'ono, gwedeza mpiringidzo wozembera kumbali yakumanja kapena kumanzere kwa tsambalo, kusiya kabulo kokha kogawanika.

Kuchotsa Split Mawindo

Kuchotsa zowonongeka zonse:

• Dinani pa View> Patulirani kuti mutsegule pulojekiti yogawanika;

kapena

• Kokani mipiringidzo yonse yogawanika pambali pa chinsalu; ndi zitsulo zonsezo mu malo awa, chithunzi chogawanika pa riboni chatsekedwa.

Gwitsani Pulogalamu Yoyenera ndi Bokosi la Split

Kupukuta Khungu ndi Bokosi la Split

Monga tanena kale, bokosi logawidwa linachotsedwa ku Excel kuyambira ku Excel 2013.

Chitsanzo chogwiritsira ntchito bokosi logawidwa chikuphatikizidwa m'munsimu kwa omwe amagwiritsa ntchito Excel 2010 kapena 2007 omwe akufuna kugwiritsa ntchito gawoli.

Chitsanzo: Kugawa Zithunzi ndi Bokosi Lagawanika

Monga momwe tingawonere pa chithunzi pamwambapa, tidzasintha mawonekedwe a Excel pambali pogwiritsa ntchito bokosi logawanika lomwe lili pamwamba pa scrollbar.

Bokosi logawanika lili pansi pazenera la Excel, pakati pa mipukutu yowongoka ndi yopingasa.

Pogwiritsa ntchito bokosi losagawanika kusiyana ndi njira yogawanika yomwe ili pansi pa Tabu Yakuwonetserani imakulolani kugawanika pulojekiti mu njira imodzi yokha - yomwe ndi zomwe ambiri ogwiritsa ntchito akufuna.

Kuwonjezera Deta

Ngakhale kuti deta sichiyenera kupezeka pazithunzi zogawidwa kuti zigwire ntchito, zimakhala zosavuta kudziwa momwe mbaliyo imagwirira ntchito ngati pepala lokhala ndi deta likugwiritsidwa ntchito.

1. Tsegulani pepala lokhala ndi deta yolingalira bwino kapena kuwonjezera mizere yambiri ya deta - monga deta lowonedwa pa chithunzi pamwambapa - ku tsamba
2. Kumbukirani kuti mungagwiritse ntchito chida chodzaza kuti mudzadziwe tsiku la sabata ndi mndandanda wa mitu yoyenera monga Sample1, Sample2, ndi zina.

Kupukuta Khungu Pachilendo

1. Ikani pointeru ya mbewa pa bokosi logawidwa pamwamba pa barolo lopukuta ofunikira monga momwe tawonetsera pa chithunzi pamwambapa.
2. Mthunzi wa mbewa udzasintha kuvivi lakuda wakuda ngati mutadutsa bokosi logawidwa.
3. Pamene pointer ya mouse imasintha, dinani ndikugwiritsira ntchito batani lamanzere .
4. Mzere wakuda wosakanikirana uyenera kuwonekera pamwamba pa mzera umodzi wa tsamba.
5. Kokani chikhomo cha mouse pamtunda.
6. Mdima wamdima wosakanikirana uyenera kutsata ndondomeko ya mbewa.
7. Pamene pointer ya mbewa ili pansi pa mndandanda wa zigawo za mndandanda muzitsulo la worksheet kutulutsa batani lamanzere.
8. Bhala logawanika yopingasa liyenera kuonekera pa tsamba limene ntchitoyi imasulidwa.
9. Pamwamba ndi pansi pa bala logawanika ayenera kukhala makope awiri a worksheet.
10. Payenera kukhalapo mipiringidzo iwiri yowongoka kumbali yakumanja ya skrini.
11. Gwiritsani ntchito mipukutu iwiriyi kuti muyike deta kuti zigawo za pamutu ziwonekere pamwamba pa barani yogawanika ndi zina zonse pansipa.
12. Udindo wa bwalo logawanika ukhoza kusinthidwa nthawi zonse ngati pakufunikira.

Kuchotsa Split Mawindo

Muli ndi njira ziwiri zomwe mungachotsere zojambulazo:

1. Dinani pa bokosi logawidwa kumanja kwa dzanja la chinsalu ndikubwezeretsanso pamwamba pa tsamba.
2. Dinani pawona> Gulani chidindo kuti muwononge mbali yowonekera pazithunzi.