Pezani Dongosolo ndi Excel ROW ndi COLUMN Ntchito

Ntchito LOOW ingagwiritsidwe ntchito:

• bweretsani chiwerengero cha mndandanda wa selo yopatsidwa selo
• bweretsani chiwerengero cha mzere kwa selo kumene ntchitoyo ili mu tsamba la ntchito
• pamene agwiritsidwa ntchito mu ndondomeko yambiri, ntchitoyo idzabweretsa manambala angapo omwe akudziwika kuti ndi nambala ya mizere yonse yomwe ntchitoyo ili

Ntchito ya COLUMN ingagwiritsidwe ntchito:

• bweretsani chiwerengero cha gawo la selo kumene ntchitoyo ili pa tsamba la ntchito
• bweretsani chiwerengero cha mzere wa selo lopatsidwa selo

Mu tsamba la Excel,

• Mizere yayambira pamwamba mpaka pansi ndi mzere 1 kukhala mzere woyamba;
• zipilala zikuwerengedwa kumanzere kupita kumanja ndi mzere A kukhala koyamba yoyamba.

Choncho, ntchito yaikulu idzabwezeretsa nambala 1 ku mzere woyamba ndi 1,048,576 pamzere womaliza wa tsamba .

01 a 02

Ntchito yowonjezera ndi COLUMN Ntchito Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabaki, ndi zifukwa .

Chidule cha ntchito ya ROW ndi:

= MALO (Otchulidwa)

Chidule cha ntchito ya COLUMN ndi:

= COLUMN (Kutchula)

Lembani - (mungasankhe) selo kapena maselo osiyanasiyana omwe mukufuna kubweretsera chiwerengero cha mzere kapena kalata.

Ngati ndemanga yowonjezera yasiya,

• Ntchito Yowonjezera imabwereranso mzere wa selo la malo omwe ntchitoyi ilipo - mzere wa pamwamba;
• ntchito ya COLUMN imabweretsanso chiwerengero cha selo yomwe ntchitoyo ilipo - mzere wachitatu pamwambapa.

Ngati mafotokozedwe ambiri a selo amalowetsedwa pa ndondomeko ya Reference , ntchito imabwerera mzere kapena chiwerengero cha chigawo cha selo yoyamba mu mzere wa magawo asanu ndi limodzi ndi asanu ndi awiri pamwambapa.

02 a 02

Zitsanzo Zogwiritsira Ntchito ROW Excel ndi Ntchito COLUMN

Chitsanzo choyamba - mzere wachiwiri pamwambapa - asiya ndemanga yowonjezera ndikubwezeretsanso nambala ya mzere malinga ndi malo ogwira ntchito.

Chitsanzo chachiwiri - mzere wachitatu pamwambapa - kubwezeretsa kalata ya selo ya foni (F4) inalowa monga ndemanga ya Bukuli .

Monga momwe ntchito zambiri za Excel zimakhalira, ntchitoyi imatha kufotokozedwa mwachindunji mu selo yogwira ntchito - chitsanzo chimodzi - kapena kulowa mkati pogwiritsa ntchito bokosi lazokambirana - chitsanzo chachiwiri.

Chitsanzo 1 - Kuthetsa Mndandanda Wotsutsa ndi Ntchito YONSE

1. Dinani pa selo B2 kuti mupange selo yogwira ntchito;
2. Lembani fomu = ROW () mu selo
3. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo;
4. Chiwerengero "2" chiyenera kuoneka mu selo B2 chifukwa ntchitoyi ili pamzere wachiwiri wa worksheet;
5. Mukasindikiza pa selo B2 ntchito yeniyeni = ROW () ikuwoneka pazenera yapamwamba pamwamba pa tsamba.

Chitsanzo chachiwiri - Kugwiritsa ntchito ndemanga yotsutsa ndi ntchito COLUMN

1. Dinani pa selo B5 kuti mupange selo yogwira ntchito;
2. Dinani pa Fomu tab ya menyu yowonongeka;
3. Sankhani Kutsegula ndi Kutchulidwa kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani pa COLUMN mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo ;
5. Mu bokosi la bokosi, dinani pa Tsamba lofotokozera;
6. Dinani pa selo F4 papepala kuti mulowetse selolo mu bokosi la dialog;
7. Dinani OK kuti mutsirize ntchitoyi ndi kubwerera ku tsamba la ntchito;
8. Chiwerengero "6" chiyenera kuoneka mu selo B5 chifukwa selo F4 ili m'mbali yachisanu ndi chimodzi - ndime F - ya worksheet;
9. Mukasinthitsa pa selo B5 ntchito yonse = COLUMN (F4) ikuwoneka mu barra yazenera pamwamba pa tsamba.