Isticmaal ikhtiyaarka paste Gaar ah (Paste gaar ah) > Isbedel (Transpose) gudaha Excel si loogu beddelo safafka tiirarka ama tiirarka safafka. Waxa kale oo aad isticmaali kartaa shaqada GUJI (TRANSP).
Ku dheji gaar ah> Transpose
Si aad xogta u gudbiso, samee waxa soo socda:
- Dooro kala duwan A1: C1.
- Midig ku dhufo oo guji Copy (Koobi).
- Muuji unug E2.
- Midig ku dhufo ka dibna dooro paste Gaar ah (Gaar gaar ah).
- Daar doorashada Isbedel (Transpose).
- Press OK.
shaqada TRANSP
Si aad u isticmaasho shaqada GUJI (TRANSP), samee waxyaabaha soo socda:
- Marka hore, dooro unugyo kala duwan oo cusub.
- Eegala
= TRANSPOSE (
= ТРАНСП (
- Dooro kala duwan A1: C1 oo xidh xidhidhka.
- Dhamays geli gelida caanaha adiga oo riixaya Ctrl + Shift + Ku qor.
Fiiro gaar ah: Bar qaacidadu waxay tusinaysaa in kani yahay qaacido habaysan sababtoo ah waxa ay ku xidhan tahay biraha curdinka ah {}. Si aad meesha uga saarto qaacidada habaynta, dooro inta u dhaxaysa E2:E4 oo taabo furaha delete.