Kusintha tebulo mu Excel

Zowonadi, wogwiritsa ntchito aliyense wogwira ntchito ku Excel adakumana ndi vuto lomwe mizere ndi mizati ya tebulo iyenera kusinthidwa. Ngati tikulankhula za data yaying'ono, ndiye kuti njirayi imatha kuchitidwa pamanja, ndipo nthawi zina, pakakhala zambiri, zida zapadera zimakhala zothandiza kwambiri kapena zofunika kwambiri, zomwe mutha kutembenuza tebulo. . Tiyeni tiwone momwe zimachitikira.

Kusintha kwa tebulo

Kusintha - uku ndiko "kutumiza" kwa mizere ndi mizati ya tebulo m'malo. Opaleshoniyi ikhoza kuchitidwa m'njira zosiyanasiyana.

Njira 1: Gwiritsani Ntchito Matani Apadera

Njirayi imagwiritsidwa ntchito nthawi zambiri, ndipo izi ndi izi:

1. Sankhani tebulo mwanjira iliyonse yabwino (mwachitsanzo, pogwira batani lakumanzere kuchokera pa cell yakumanzere kupita pansi kumanja).
2. Tsopano dinani kumanja pagawo losankhidwa ndikusankha lamulo kuchokera pamenyu yankhani yomwe imatsegula. "Koperani" (kapena m'malo mwake ingokanikiza kuphatikiza Ctrl + C).
3. Papepala lomwelo kapena papepala lina, timayima mu selo, lomwe lidzakhala selo lakumanzere la tebulo losinthidwa. Timadina pomwepa, ndipo nthawi ino tikufuna lamulo mumenyu yankhani "Special Paste".
4. Pazenera lomwe limatsegulidwa, chongani bokosi pafupi ndi "Transpose" ndipo dinani OK.
5. Monga tikuonera, tebulo lotembenuzidwa likuwonekera pamalo osankhidwa, momwe mizati ya tebulo loyambirira idakhala mizere ndi mosemphanitsa. Tsopano tikhoza kuyamba kusintha maonekedwe a deta monga momwe ife tikufunira. Ngati tebulo loyambirira silikufunikanso, likhoza kuchotsedwa.

Njira 2: Gwiritsani Ntchito "TRANSPOSE".

Kuti musinthe tebulo mu Excel, mutha kugwiritsa ntchito ntchito yapadera "TRANSP".

1. Pa pepala, sankhani magulu angapo omwe ali ndi mizere yochuluka monga momwe zilili ndi mizati patebulo loyambirira, ndipo mofananamo, zomwezo zimagwiranso ntchito pamizere. Kenako dinani batani "Isert ntchito" kumanzere kwa formula bar.
2. Mu otsegula Ntchito Wizard sankhani gulu “Mndandanda wa zilembo zonse”, timapeza woyendetsa "TRANSP", ikani chizindikiro ndikudina OK.
3. Zenera la mikangano yantchito liziwoneka pazenera, pomwe muyenera kufotokozera makonzedwe a tebulo, pamaziko omwe kusinthaku kudzachitika. Mutha kuchita izi pamanja (kulowetsa kiyibodi) kapena posankha ma cell angapo papepala. Zonse zikakonzeka, dinani OK.
4. Timapeza zotsatirazi papepala, koma si zokhazo.
5. Tsopano, kuti tebulo losinthidwa liwonekere m'malo mwa cholakwika, dinani pa formula bar kuti muyambe kusintha zomwe zili mkati mwake, ikani cholozera kumapeto kwenikweni, kenako dinani batani kuphatikiza. Ctrl + Shift + Lowani.
6. Motero, tinatha kusinthira bwino tebulo loyambirira. Mu formula bar, tikuwona kuti mawuwo tsopano amapangidwa ndi ma curly braces.Zindikirani: Mosiyana ndi njira yoyamba, masanjidwe oyambira sanasungidwe pano, omwe nthawi zina amakhala abwino, chifukwa titha kukhazikitsa chilichonse kuyambira pomwe tikufuna. Komanso, apa tilibe mwayi wochotsa tebulo loyambirira, chifukwa ntchitoyi "imakoka" deta kuchokera pamenepo. Koma ubwino wosakayikitsa ndi wakuti matebulo amalumikizidwa, mwachitsanzo, kusintha kulikonse kwa deta yoyambirira kudzawonetsedwa nthawi yomweyo muzosinthidwa.

Kutsiliza

Chifukwa chake, pali njira ziwiri zomwe mungagwiritse ntchito posinthira tebulo mu Excel. Onsewa ndi osavuta kugwiritsa ntchito, ndipo kusankha kwa njira imodzi kapena ina kumadalira zolinga zina zogwirira ntchito ndi deta yoyambira ndi yolandilidwa.