Kusintha kwa data mu Excel

• Matani Special> Transpose
• ntchito TRANSP

Gwiritsani ntchito njirayo phala Special (Mapangidwe Apadera) > Kutsegula (Transpose) mu Excel kuti musinthe mizere kukhala mizere kapena mizere kukhala mizere. Mukhozanso kugwiritsa ntchito YENDANI (TRANSP).

Matani Special> Transpose

Kuti mutumize deta, chitani izi:

1. Sankhani osiyanasiyana A1:C1.
2. Dinani kumanja ndikudina Koperani (Koperani).
3. Onetsani selo E2.
4. Kumanja alemba pa izo ndiyeno kusankha phala Special (Kuyika kwapadera).
5. Yambitsani mwayi Kutsegula (Transpose).
6. Press OK.

ntchito TRANSP

Kuti mugwiritse ntchito YENDANI (TRANSP), chitani izi:

1. Choyamba, sankhani ma cell atsopano.
2. Lowani

   = TRANSPOSE (

   = ТРАНСП (

3. Sankhani osiyanasiyana A1:C1 ndi kutseka bulaketi.
4. Malizitsani kuyika fomula ndikukanikiza Ctrl + Shift + Lowani.

Zindikirani: Fomulayi ikuwonetsa kuti iyi ndi njira yotsatsira chifukwa imakutidwa ndi ma curly braces {}. Kuti muchotse fomula yosanja iyi, sankhani masinthidwe E2:E4 ndipo dinani batani Chotsani.