Sinthani njira yomwe deta yakhalira pa tsamba lanu
Zomwe zimagwira ntchito ku Excel ndi njira imodzi yosinthira momwe deta yakhalira kapena yowongoka pa tsamba. Ntchitoyi ikuwombera deta yomwe ili m'mizere kuzitsulo kapena kuchokera pazitsulo mpaka mizere. Ntchitoyi ingagwiritsidwe ntchito kutsegula mzere umodzi kapena deta ya deta kapena mzere wambiri kapena mndandanda wambiri .
01 a 02
ZINTHU ZOYENERA KUTSATIRA Msonkhano wa Syntax ndi Maganizo
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha TRANSPOSE ntchito ndi:
{= TRANSPOSE (Mzere)}Mndandanda ndi maselo ambirimbiri omwe ayenera kuponyedwa kuchokera mzere kukhala mndandanda kapena kuchokera pa khola kupita mzere.
- Kukula kwa zolemba zoyambirira ndi zatsopano ziyenera kufanana. Ngati mndandanda wapachiyambi uli ndi maselo asanu a deta m'ndandanda, mndandanda watsopano uyenera kukhala ndi maselo asanu a deta mzere.
- Ngati mndandanda wa mndandanda wambiri umasindikizidwa, mzere woyamba wa mzere umakhala mzere woyamba wa mndandanda watsopano, mzere wachiwiri wa mzere umakhala mzere wachiwiri watsopano, ndi zina zotero. Zomwezo zimachitika ngati mndandanda wa mndandanda wambiri umasinthidwa.
CSE Mpangidwe
Mitsempha yowongoka {} yozungulira ntchitoyo ikusonyeza kuti ndi njira yowonjezera . Mndandanda wamtunduwu umapangidwira makina a Ctrl , Shift , ndi Enter mu khibodi panthawi imodzimodziyo polowa mndandanda.
Njira yowonjezera iyenera kugwiritsidwa ntchito chifukwa ntchito YOPHUNZITSIRA imayenera kuikidwa m'maselo osiyanasiyana panthawi imodzimodzi kuti deta ipambane mofulumira.
Chifukwa mitundu yowonjezera imapangidwa pogwiritsa ntchito makiyi a Ctrl , Shift , ndi Enter , nthawi zambiri amatchedwa ma CSE ma formula.
02 a 02
Kutumizira Mizere kwa Ma Columns Chitsanzo
Chitsanzo ichi chimaphatikizapo momwe mungalowerere ndondomeko ya TRANSPOSE yomwe ili mu selo C1 mpaka G1 ya chithunzi chomwe chili ndi nkhaniyi. Miyendo yomweyo imagwiritsidwanso ntchito polowera njira yachiwiri ya TRANSPOSE yomwe ili m'maselo E7 mpaka G9.
Kulowa Ntchito YOTSATIRA
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yonse: = TRANSPOSE (A1: A5) mu maselo C1: G1
- Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito TRANSPOSE ntchito dialog box
Ngakhale kuti n'zotheka kulembetsa ntchito yonseyo pamanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo chifukwa zimasamala kuti alowe m'ma syntax monga mabakiteriya ndi ogawanikana pakati pa zifukwa.
Ziribe kanthu njira yomwe imagwiritsiridwa ntchito kulowetsa ndondomekoyi, sitepe yotsiriza - ya kuyisandutsa iyo ndondomeko yambiri - iyenera kuchitidwa pamanja ndi makina a Ctrl , Shift , ndi Enter .
Kutsegula BUKHU LOTENGA LOGWIRITSA
Kulowa ntchito YOTSATIRA mu maselo C1 mpaka G1 pogwiritsa ntchito bokosi la zokambirana:
- Onetsetsani maselo C1 mpaka G1 mu tsamba la ntchito;
- Dinani pa Fomu tab ya riboni;
- Dinani pazithunzi za Lookup ndi Reference kuti mutsegule ntchito yolemba pansi;
- Dinani pa TRANSPOSE mndandanda kuti mutsegule dialog box.
Kulowetsani Mzere Wotsutsana ndi Kupanga Mzere Wopangira
- Onetsetsani maselo A1 mpaka A5 pa tsamba kuti mulowetse mndandanda uwu ngati mtsutso wa Array .
- Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
- Koperani ndi kumasula fungulo lolowamo mu khibhodi kuti mulowetse ntchito YOTSATIRA ngati njira yowonjezera mu maselo asanu.
Deta m'maselo A1 mpaka A5 iyenera kuoneka m'maselo C1 mpaka G1.
Mukamalemba pa maselo onse a C1 mpaka G1, ntchito yonse {= TRANSPOSE (A1: A5)} imapezeka muzenera zamatabwa pamwamba pa tsamba.