Kidokezo: Lugha zingine ni Google-Ilitafsiriwa. Unaweza kutembelea English toleo la kiungo hiki.
Ingia
x
or
x
x
Daftari
x

or

Jinsi ya kupata safu ya safu au safu ya kiini cha sasa katika Excel?

Je, umewahi kujaribu kupata safu ya mstari au safu ya kiini cha sasa katika Excel kama chini ya skrini iliyoonyeshwa? Hapa, mimi kuanzisha baadhi ya formula kupata haraka safu barua au safu ya barua ya kiini hai.

Pata barua ya safu ya safu ya safu ya sasa


Pata barua ya safu ya safu ya safu ya sasa


Pata barua ya safu ya seli ya sasa

Nakili mojawapo ya fomu zifuatazo, funga kwenye kiini kilichofanya kazi, na ubofye kitufe cha Ingiza ili kupata barua ya jamaa.

= CHAR (ROW () + 64)

= KUSA (ADDRESS (1, ROW (), 2), 1 + (ROW ()> 26))

fanya barua ya safu ya safu ya 1

Pata barua ya safu ya seli ya sasa

Nakili mojawapo ya fomu zifuatazo, funga kwenye kiini kilichofanya kazi, na ubofye kitufe cha Ingiza ili kupata barua ya jamaa.

= CHAR (COLUMN () + 64)

= KUSA (ADDRESS (1, COLUMN (), 2), 1 + (COLUMN ()> 26))

fanya barua ya safu ya safu ya 2


Labda unavutiwa na hili:

Transpose Rangewazo nzuri2

Kutools kwa Excel's Transpose Range kazi inaweza kubadilisha safu / safu kwa haraka, na kinyume chake.
doc1


Zilizopendekeza Vifaa vya Uzalishaji

Tabia ya Ofisi

nyota ya dhahabu1 Kuleta tabo za Handy kwa Excel na programu nyingine za Ofisi, kama Chrome, Firefox na Internet Explorer mpya.

Kutools kwa Excel

nyota ya dhahabu1 Kushangaza! Ongeza uzalishaji wako katika dakika ya 5. Hauna haja ujuzi wowote maalum, ila saa mbili kila siku!

nyota ya dhahabu1 Features mpya ya 300 kwa Excel, Fanya Excel Rahisi Rahisi na Nguvu:

  • Unganisha Kiini / Rangi / nguzo bila kupoteza Data.
  • Kuchanganya na Kuunganisha Karatasi nyingi na Vitabu vya Kazi.
  • Linganisha Mipangilio, Nakili Ranges nyingi, Badilisha Nakala hadi Tarehe, Kitengo na Ubadilishaji wa Fedha.
  • Hesabu na Rangi, Vipindi vya Paging, Chagua cha Juu na cha Filter Super,
  • Chagua zaidi / Ingiza / Futa / Nakala / Fomu / Kiungo / Maoni / Vitabu vya Kazi / Vifungu vya Kazi ...

Screen shot ya Kutools kwa Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Y. · 11 months ago
    This only works from A->Z, when you go with two caracters, it stops working :(
    • To post as a guest, your comment is unpublished.
      Scott · 7 months ago
      Ugh. I just figured that out as well.

      Any idea how to fix for Column AA and onward?
      • To post as a guest, your comment is unpublished.
        George · 6 months ago
        =LOWER(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")) - small letters

        or

        =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") - caps