Yi amfani da zaɓi manna Musamman (Manna na musamman)> Canza (Transpose) a cikin Excel don canza layuka zuwa ginshiƙai ko ginshiƙai zuwa layuka. Hakanan zaka iya amfani da aikin SAUKI (TRANSP).
Manna na Musamman> Mai da
Don fassara bayanai, yi waɗannan:
- Zaɓi kewayo A1: c1.
- Dama danna kuma danna Copy (Kwafi).
- Hana tantanin halitta E2.
- Dama danna shi sannan ka zaba manna Musamman (Sashe na musamman).
- Kunna zaɓi Canza (Mai fassara).
- latsa OK.
aikin TRANSP
Don amfani da aikin SAUKI (TRANSP), yi kamar haka:
- Na farko, zaɓi sabon kewayon sel.
- Shigar da
= TRANSPOSE (
= ТРАНСП (
- Zaɓi kewayo A1: c1 kuma rufe sashin.
- Kammala shigar da dabara ta latsa Ctrl + Shigar + Shigar.
lura: Mashigin dabara yana nuna cewa wannan tsari ne na tsararru saboda an lullube shi a cikin takalmin gyaran kafa mai lanƙwasa {}. Don cire wannan tsarin tsararrun, zaɓi kewayon E2: ku 4 kuma danna maɓallin share.