Uma uvule i-Excel futhi kungazelelwe uthole ukuthi kunezinombolo ezihlokweni zekholomu esikhundleni sezinhlamvu ezivamile, ungadikibali futhi ufunde lesi sihloko kuze kube sekupheleni! Kulesi sifundo, uzofunda ukuthi ungashintsha kanjani izinombolo zibe izinhlamvu kumakholomu, futhi ujwayelane nezitayela zokuxhumanisa ku-Microsoft Excel.
Siyini isitayela sesixhumanisi?
Ishidi ngalinye le-Excel lakhiwe imigqa namakholomu. Ezimweni eziningi, amakholomu achazwa ngezinhlamvu (A, B, C) futhi imigqa isho izinombolo (1, 2, 3). Ku-Excel ibizwa ngokuthi isixhumanisi isitayela A1. Kodwa-ke, abanye bakhetha ukusebenzisa isitayela esihlukile, lapho amakholomu abuye afakwe izinombolo. Kubizwa Isitayela sesixhumanisi se-R1C1.
Isitayela sesixhumanisi se-R1C1 singaba usizo kwezinye izimo, kodwa njengoba umkhuba ubonisa, lokhu kuyivelakancane. Kukhona neqembu labasebenzisi abathanda ukusebenza ngale fomethi yesixhumanisi, nokho, abasebona abasanda kuhlanganyela. Ezimweni eziningi, uzosebenza ngesitayela sokuxhumanisa se-A1, esifakwe ku-Microsoft Excel ngokuzenzakalelayo.
Lesi sifundo kanye nazo zonke izifundo ezikule sayithi zisebenzisa isitayela sokuxhumanisa esingu-A1. Uma okwamanje usebenzisa isitayela sesixhumanisi se-R1C1, udinga ukusivala.
Nika amandla/khubaza isitayela sesixhumanisi se-R1C1
- Chofoza Ifayela, Ukuthuthela ku ukubuka ngemuva kwesiteji.
- Cindezela Amapharamitha.
- Ebhokisini lengxoxo elivelayo Izinketho ze-Excel Khetha isigaba formula. Thikha ibhokisi Isitayela sesixhumanisi se-R1C1 bese ucindezela OK. I-Excel izoshintshela kusitayela sokuxhumanisa i-R1C1.
Njengoba ungase uqagele, ukuze ubuyele kusitayela sesixhumanisi se-A1, kwanele ukususa ukumaka leli bhokisi.