Nemo bayanai tare da Ayyukan Excel ta ROW da COLUMN

Ana iya amfani da aikin ROW zuwa:

• mayar da lambar don jere na ƙirar salula
• mayar da lambar jere don tantanin halitta inda aikin yake a cikin takardun aiki
• idan aka yi amfani dashi a cikin tsari mai tsafta, aikin zai dawo jerin lambobin da ke gano lambobi na duk layuka inda aikin yake

Za'a iya amfani da aikin COLUMN zuwa:

• mayar da lambar lambar don tantanin halitta inda aikin yake a cikin takardun aiki
• mayar da lambar don shafi na wanda aka ba da tantanin halitta

A cikin takardar aikin Excel,

• layuka suna ƙidaya zuwa ƙasa tare da jere 1 kasancewa jere na farko;
• ginshiƙai ana ƙidaya hagu zuwa dama tare da shafi A kasancewa na farko shafi.

Sabili da haka, aikin ROW zai dawo lambar 1 don jeri na farko da 1,048,576 don jere na ƙarshe na takardun aiki .

01 na 02

Ayyukan ROW da COLUMN da Magana

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Haɗin aikin aikin ROW shine:

= ROW (Magana)

Haɗin aikin aikin COLUMN shine:

= COLUMN (Magana)

Nassin - (na zaɓi) tantanin halitta ko kewayon kwayoyin da kake so ka dawo da jere ko lambar haruffa.

Idan an tsayar da hujja ta tunani,

• aikin ROW ya dawo da jere lamba na tantancewar tantanin halitta inda aikin yake - jere biyu a sama;
• aikin COLUMN ya dawo lambar mahaɗin tantanin tantanin halitta inda aka samo aikin - jere uku a sama.

Idan an shigar da raƙuman tantanin salula don maganganun da aka ba da shawara, aikin zai dawo da jere ko lambar mahaɗin tantanin halitta ta farko a cikin tarin da aka bawa - layuka shida da bakwai a sama.

02 na 02

Misalan Yin amfani da Ayyuka na RELI da na COLUMN na Excel

Misali na farko - jere biyu a sama - ya fita da maimaita shawara kuma ya sake dawo da lambar jeri bisa ga aikin aiki a cikin takardun aiki.

Misali na biyu - jere uku a sama - dawo da harafin shafi na tantanin tantanin halitta (F4) wanda aka shigar a matsayin shaida na nunawa don aikin.

Kamar yadda mafi yawan ayyuka na Excel, aikin za a iya danna kai tsaye cikin tantanin halitta mai aiki - misalin daya - ko shigar da amfani da akwatin maganganun - misalin biyu.

Misali na 1 - Gyara Magana da Magana tare da aikin ROW

1. Danna kan tantanin halitta B2 don sa shi tantanin halitta;
2. Rubuta nau'i = ROW () cikin tantanin halitta
3. Latsa maɓallin shigarwa a kan keyboard don kammala aikin;
4. Lambar "2" ya kamata ya bayyana a cell B2 tun lokacin aikin yana samuwa a jere na biyu na takardun aiki;
5. Idan ka danna kan tantanin halitta B2 cikakke aikin = ROW () ya bayyana a cikin maɓallin tsari a sama da takardun aiki.

Misali 2 - Amfani da Magana da Magana tare da aikin COLUMN

1. Danna kan B5 na b5 don sanya shi tantanin halitta;
2. Danna maɓallin Formulas na shafin ribbon ;
3. Zabi Binciken da Magana daga ribbon don bude jerin jerin ayyuka
4. Danna Kungiyar COLUMN a cikin jerin don kawo akwatin maganganu na aikin;
5. A cikin akwatin maganganu, danna kan layi na layi;
6. Danna kan salula F4 a cikin takardar aiki don shigar da tantanin halitta a cikin akwatin maganganu;
7. Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki;
8. Lambar "6" ya kamata ya bayyana a cell B5 tun lokacin da cell F4 ke samuwa a cikin sashin na shida - shafi na F - na takardar aiki;
9. Lokacin da ka danna kan tantanin B5 da cikakke aikin = COLUMN (F4) ya bayyana a cikin wannan tsari a sama da takardun aiki.