Sebelisa khetho peista Special (Peista e Khethehileng) > Fetola (Transpose) ho Excel ho fetolela mela ho likholomo kapa likholomo ho mela. U ka boela ua sebelisa tshebetso Phetolelo (TRANSP).
Beha e khethehileng > Transpose
Ho fetisetsa data, etsa se latelang:
- Khetha sebaka A1:C1.
- Tobetsa ka ho le letona ebe o tobetsa khopi (Kopitsa).
- Totobatsa sele E2.
- Tobetsa ho eona ka ho le letona ebe u khetha peista Special (Kenyelletso e khethehileng).
- Etsa khetho Fetola (Transpose).
- Press OK.
tshebetso TRANSP
Ho sebelisa ts'ebetso Phetolelo (TRANSP), etsa tse latelang:
- Ntlha ea pele, khetha mefuta e mecha ea lisele.
- Kenya
= TRANSPOSE (
= ТРАНСП (
- Khetha sebaka A1:C1 ebe o koala bracket.
- Qetella ho kenya foromo ka ho tobetsa Ctrl + Shift + Kena.
Hlokomela: Formula bar e bonts'a hore ena ke foromo ea mefuta-futa hobane e kentsoe ka har'a li-curly braces {}. Ho tlosa foromo ena ea sehlopha, khetha mofuta oa sebaka E2:E4 ebe o tobetsa konopo hlakola.