Shandisa sarudzo paste Special (Special Namira) > Shandura (Transpose) muExcel kushandura mitsara kuita makoramu kana makoramu kuita mitsetse. Unogonawo kushandisa basa SHANDISA (TRANSP).
Namira Special > Transpose
Kuti utore data, ita zvinotevera:
- Sarudza renji A1:C1.
- Tinya kurudyi wodzvanya mufananidzo (Kopi).
- Simbisa sero E2.
- Kurudyi tinya pairi wobva wasarudza paste Special (Special insert).
- Bvumira sarudzo Shandura (Transpose).
- dzvanya OK.
basa TRANSP
Kushandisa basa SHANDISA (TRANSP), ita zvinotevera:
- Kutanga, sarudza rudzi rutsva rwemasero.
- kupinda
= TRANSPOSE (
= ТРАНСП (
- Sarudza renji A1:C1 wovhara bhuraketi.
- Pedzisa kuisa formula nekudzvanya Ctrl + Shift + Pinda.
Cherechedza: Iyo fomula bar inoratidza kuti iyi imhando yefomula nekuti yakavharirwa mune dzakamonana braces {}. Kuti ubvise fomura iyi, sarudza huwandu E2:E4 wobva wadzvanya kiyi Kudzima.