Tsvaga Dhiyabhorosi neExcel ROW nemabasa eCOLUMN

Basa ROW rinogona kushandiswa ku:

• dzoka nhamba yacho nemutsetse wekupiwa sero reference
• dzoka nhamba yemutsetse iyo yesero iyo basa racho riri mune pepa rekushanda
• iyo inoshandiswa mumushonga wakafanana, basa racho richadzoka nhamba dzakatevedzana dzehuwandu hunoratidza huwandu hwemitsara yose iyo basa racho riripo

Basa reCOLUMN rinogona kushandiswa ku:

• dzoka nhamba yekhoma yesereni iyo basa iri riri mune pepa rekushanda
• dzokai nhamba yekorodhe yepaini inotaridzirwa

Mune pepa re Excel worksheet,

• mitsetse yakaverengwa kumusoro kusvika pasi nemutsara 1 uri mutsara wokutanga;
• mbiru dzinotarwa kuruboshwe kuenda kurudyi nekorosi A kuva yekori yekutanga.

Nokudaro, basa ROW raizodzoka nhamba 1 yemutsara wokutanga uye 1,048,576 pamutsara wokupedzisira webhesi .

01 ye 02

Iro ROW neCOLUMN Imabasa Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa , mabheji, uye nharo .

Mutsara weROW basa ndewokuti:

= ROW (Ratidza)

Mutsara weKOLUMN basa nderokuti:

= COLUMN (Refodhi)

Tsvaga - (kusarudza) sero kana utera hwemasero maunoda kudzorera nhamba yemutsara kana tsamba.

Kana nhaurirano yekutarisa isiri iyo,

• iro ROW basa rinodzoka mutsara nhamba yesero rinoshandiswa apo basa racho riripo - mutsara maviri pamusoro;
• iyo COLUMN basa rinodzorera iyo nhamba yekoromeri yeferensi yeropa apo basa racho riripo - mutsara wechitatu pamusoro apa.

Kana ruzivo rwemaferensi ezvinyorwa rwakapinda muGwaro reReferensi, basa rinodzorera mutsara kana nhamba yekorofa yesero rekutanga mune zvakapiwa mitsara-mitsara matanhatu nevanomwe pamusoro.

02 of 02

Mienzaniso Inoshandisa Excel ROW neCOLUMN Mabasa

Muenzaniso wekutanga - mutsara maviri pamusoro - unodzokorora mutsara weReferensi uye unodzorera rutsara rune nheyo zvichienderana nenzvimbo yebasa riri papeji yebasa.

Muenzaniso wechipiri - mutsara wechitatu pamusoro - unodzorera tsamba yemutsetse yesero rinotarisa (F4) yakapinda seChirangariro yeChirangaridzo chebasa racho.

Sezvakaita mabasa akawanda eExcel, basa racho rinogona kunyorwa zvakananga mumasero anoshingaira - muenzaniso mumwe - kana kupinda mukati rebhokisi rebhokisi rebasa - muenzaniso wechipiri.

Muenzaniso 1 - Kuvhara Refer Argument neBASA ROW

1. Dzvanya pachitokisi B2 kuti uite sero rinoshanda;
2. Tora fomu = ROW () muyero
3. Dhinda pikicha inopinda mubhokisi kuti upedze basa;
4. Nhamba ye "2" inofanira kuonekwa muchitokisi B2 sezvo basa riri mumutsara wechipiri webasa rekushanda;
5. Paunenge uchinge uri pafoni B2 basa rakakwana = ROW () rinowanikwa mubhairi yepamusoro pane pepa pepaji.

Muenzaniso wechipiri - Kushandisa Reference Argument neCOLUMN Function

1. Dzvanya pane sero B5 kuti riite iro rinoshandiswa seki;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Kuona uye Kutarisa kubva kubhoni kuti uzarure basa rinoderera pasi
4. Dzvanyira paCOLUMN murugwaro kuti uburise bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, chengetera pane Referenced line;
6. Dzvanya pane seferi F4 mune pepa rekushanda kuti uise seferensi yesero mubhokisi rebhokisi;
7. Dzvanya OK kuti upedze basa uye dzokera kubheji rekushanda;
8. Nhamba "6" inofanira kuonekwa muchitokisi B5 sezvo sero F4 iri muhomwe yechitanhatu - chinyorwa F - chebasa rekushanda;
9. Paunenge uchinge uri pafoni B5 zvakakwana basa = COLUMN (F4) inowanikwa mubhadha yepamusoro pane pepa pepaji.