Sebenzisa inketho namathisela Okukhethekile (Namathisela Okukhethekile) > Shintsha (Transpose) ku-Excel ukuguqula imigqa ibe amakholomu noma amakholomu abe imigqa. Ungasebenzisa futhi umsebenzi Dlulisa (TRANSP).
Namathisela Okukhethekile > Guqula
Ukuze udlulise idatha, yenza okulandelayo:
- Khetha ububanzi A1:C1.
- Chofoza kwesokudla bese uchofoza Kopisha (Kopisha).
- Gqamisa iseli E2.
- Chofoza kuso bese ukhetha namathisela Okukhethekile (Isifaka esikhethekile).
- Nika amandla inketho Shintsha (I-Transpose).
- Cindezela OK.
umsebenzi TRANSP
Ukusebenzisa umsebenzi Dlulisa (TRANSP), yenza okulandelayo:
- Okokuqala, khetha uhla olusha lwamaseli.
- Faka
= TRANSPOSE (
= ТРАНСП (
- Khetha ububanzi A1:C1 bese uvala ubakaki.
- Qedela ukufaka ifomula ngokucindezela Ctrl + Shift + Faka.
Qaphela: Ibha yefomula ibonisa ukuthi lena ifomula yamalungu afanayo ngoba ivalwe ngezikaki ezigoqekile {}. Ukuze ususe le fomula yamalungu afanayo, khetha ububanzi E2:E4 bese ucindezela inkinobho Susa.