Thola idatha nge-ROW ye-Excel nemisebenzi ye-COLUMN

Umsebenzi we-ROW ungasetshenziswa uku:

• buyisela inombolo ngomugqa wereferensi yeseli enikeziwe
• buyisela inombolo yomugqa weseli lapho umsebenzi ukhona ekhasini lokusebenzela
• uma isetshenziswe kwifomula yamakheli, umsebenzi uzobuyela uchungechunge lwezinombolo ezikhomba izinombolo zazo zonke imigqa lapho umsebenzi ukhona khona

Umsebenzi we-COLUMN ungasetshenziswa uku:

• buyisela inombolo yekholomu yeseli lapho umsebenzi ukhona ekhasini lokusebenzela
• buyisela inombolo yekholomu yesithenjwa sefoni esinikeziwe

Ekhasini lokusebenzela lase-Excel,

• imigqa ibalwe phezulu kuya phansi nelayini 1 ibe irowu lokuqala;
• amakholomu abalwa ngakwesokunxele kuya kwesokudla ngekholomu A kuba ikholomu yokuqala.

Ngakho-ke, umsebenzi we-ROW wawuzobuyela inombolo engu- 1 emgqeni wokuqala no- 1,048,576 ngomugqa wokugcina wephepha lokusebenzela .

01 ngo-02

I-ROW ne-COLUMN Imisebenzi ye-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi , amabakaki, nokuphikisana .

I-syntax yomsebenzi we-ROW yile:

= ROW (Ukubhekisela)

I-syntax yomsebenzi we-COLUMN yilezi:

= COLUMN (Ukubhekisela)

Izikhombo - (ngokuzikhethela) iseli noma ububanzi bamaseli ofuna ukubuyisela inombolo yomugqa noma ikholomu.

Uma ngabe impikiswano yokubhekisela ishiyiwe,

• umsebenzi we-ROW ubuyisela inamba yomugqa wereferensi yeseli lapho umsebenzi ukhona - irowu ezimbili ngenhla;
• umsebenzi we-COLUMN ubuyisela inombolo yekholomu yereferensi yeseli lapho umsebenzi ukhona - irowu ezintathu ngenhla.

Uma ububanzi bezinkomba ezifakiwe zingena kwi- Arguments yokubhekisela , umsebenzi ubuyisela inombolo yomugqa noma ikholomu yeselula yokuqala kubanga elinikeziwe - imigqa ayisithupha nesikhombisa ngaphezulu.

02 ka 02

Izibonelo Ukusebenzisa i-Excel ROW nemisebenzi ye-COLUMN

Isibonelo sokuqala - irowu ezimbili ngenhla - ushiya impikiswano yokubhekisela futhi ubuyisa inombolo yomugqa ngokususelwa endaweni yomsebenzi ekhasini lokusebenzela.

Isibonelo sesibili - umugqa amathathu ngenhla - ubuyisa incwadi yekholomu yesithenjwa seseli (F4) efakwe njenge-argument yokubhekisela yomsebenzi.

Njengemisebenzi eminingi ye-Excel, lo msebenzi ungasethwa ngqo esitokisini esisebenzayo - isibonelo esisodwa - noma ufakwe usebenzisa ibhokisi lengxoxo lomsebenzi - isibonelo ezimbili.

Isibonelo 1 - Ukuyeka ukuphikisana kokubhekisela nomsebenzi we-ROW

1. Chofoza kuseli B2 ukuze wenze iseli elisebenzayo;
2. Thayipha ifomu = ROW () esitokisini
3. Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi;
4. Inombolo "2" kufanele ibonakale esitokisini B2 ngoba umsebenzi ukhona emgqeni wesibili wephepha lokusebenzela;
5. Uma uchofoza ku-cell B2 umsebenzi ophelele = ROW () uvela kubha yefomula ngaphezulu kwephepha lokusebenzela.

Isibonelo sesi-2 - Ukusebenzisa ukuphikisana kokubhekisana nomsebenzi we-COLUMN

1. Chofoza kuseli B5 ukwenza kube iseli esebenzayo;
2. Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
3. Khetha Ukubheka kanye neNkhombandlela kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza
4. Chofoza ku- COLUMN ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lengxoxo, chofoza kulayini lokubhekisela;
6. Chofoza ku-cell F4 ekhasini lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo;
7. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela;
8. Inombolo "6" kufanele ivele esitokisini B5 kusukela iseli F4 itholakala kukholomu lesithupha - ikholomu F - yephepha lokusebenzela;
9. Uma uchofoza ku-cell B5 umsebenzi ophelele = COLUMN (F4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.