Nigute ushobora gukosora inkingi nke muri excel

Ubushobozi bwo gukosora inkingi muri Excel ni ikintu cyingirakamaro muri gahunda kigufasha kurinda akarere ko kubungabunga amakuru agaragara. Nibyingenzi mugihe akazi hamwe nimbonerahamwe nini, kurugero, iyo bibaye ngombwa kugereranya. Hariho amahirwe yo gukosora inkingi yonyine cyangwa gufata iminota mike icyarimwe, icyo tuzavuga muburyo burambuye hepfo.

Nigute ushobora gukemura inkingi yambere muri Excel?

Kugirango ugire inkingi yonyine, uzakenera gukora ibi bikurikira:

1. Fungura dosiye hamwe nimeza uteganya guhindura.
2. Jya kumurongo wibikoresho mubice "Reba".
3. Shakisha mubikorwa byateganijwe "funga akarere".
4. Mu rutonde rwo guta, hitamo "umutekano winkingi ya mbere".

imwe

Nyuma y'ibikorwa byuzuye, uzabona ko umupaka wahindutse gato, wabaye umwijima kandi wijimye, bivuze ko bikosowe, kandi iyo ukinguriwe imbonerahamwe, amakuru ya mbere ntazashira kandi azashyirwa mubikorwa mubyukuri.

2.

Nigute ushobora gukosora inkingi nke muri excel?

Kugirango ukemure inkingi nyinshi icyarimwe, uzagira ibikorwa byinshi byinyongera. Ikintu nyamukuru nukwibuka ko amanota yinkingi ibaho kuva kumurongo wibumoso, guhera kuri A. Noneho ntibishoboka gukosora inkingi zitandukanye ahantu hamwe hagati yimeza. Rero, kugirango ushyire mubikorwa iyi mikorere, uzakenera gukora ibi bikurikira:

1. Dufate ko dukeneye gukosora inkingi eshatu icyarimwe (kugena A, B, c), kugirango utangire ugaragaza inkingi yose d cyangwa selire d

3.

1. Nyuma yibyo, ugomba kujya kumurongo wibikoresho hanyuma ugahitamo tab yitwa "Reba".
2. Uzakenera gukoresha amahitamo kugirango "uhambire agace".

Bane

1. Ku rutonde uzagira imirimo myinshi, muri bo bizakenerwa guhitamo "gufunga ako gace".
2. Niba ibintu byose bikozwe neza, inkingi eshatu zerekanwe zizaba igwemerwa kandi zirashobora gukoreshwa nkisoko yamakuru cyangwa kugereranya.

Nigute icyarimwe gukosora inkingi numugozi?

Hashobora kubaho ibintu nkibi ari ngombwa gukosora inkingi ako kanya hamwe numugozi wegereye kugirango ushyire mubikorwa umukoro, ugomba gukora ibi bikurikira:

1. Ubwa mbere, uzakenera gukoresha selile nkibanze. Ibisabwa nyamukuru muriki kibazo ni ko Akagari kagomba kuboneka cyane ku kwambuka umugozi n'inkingi. Ubwa mbere, ibi birashobora kumvikana, ariko urakoze kumashusho yometse urashobora guhita yumva ibintu byingenzi muriki gihe.
2. Jya kumurongo wibikoresho hanyuma ukoreshe Reba tab.
3. Ikeneye kubona ikintu "gifite umutekano" hanyuma ukande kuri buto yimbeba yibumoso.
4. Kuva kurutonde rwamanutse birahagije guhitamo amahitamo "funga agace".

bitanu

Birashoboka gukosora imbaho ​​nyinshi zihita zikoreshwa ejo hazaza. Kurugero, niba ukeneye gukosora inkingi ebyiri zambere n'imirongo ibiri, hanyuma kugirango icyerekezo gisobanutse uzakenera kwerekana selile ya C3. Niba kandi ukeneye gukosora imirongo itatu n'inkingi eshatu ako kanya, kubwibi uzakenera kwerekana selile ya D4. Niba kandi ukeneye urutonde rudasanzwe, kurugero imirongo ibiri ninkingi eshatu, noneho izafata kugirango ikureho selire ya D3 kugirango ihuze. Nyuma yo gufata bisangiye, urashobora kubona ihame ryo guhuriza hamwe no gushira amanga uyikoresha mumeza ayo ari yo yose.

6.

Nigute ushobora kuvanaho umukoro uhantu muri Excel?

Nyuma yamakuru aturuka mumikino ihamye yuzuye, ugomba gutekereza gukuraho ibicuruzwa. Cyane cyane kubibazo nkibi hariho umurimo wihariye kandi ukayikoresha, ugomba gukora ibi bikurikira:

1. Mbere ya byose, ugomba kumenya neza ko inkingi zihamye zitagikenewe kubikorwa byawe.
2. Noneho jya kumurongo wibikoresho uva hejuru hanyuma ujye kuri tab.
3. Koresha imikorere yimikorere.
4. Kuva kurutonde rwamanutse, hitamo "Kuraho Akarere ka Guhumuriza".

7.

Umwanzuro

Nkuko mubibona, koresha imikorere yimikorere ntabwo bigoye, birahagije gukoresha ibikorwa byose biboneka no gukurikiza witonze kubisaba. Iyi mikorere igomba kuba ingirakamaro kuri wewe, kubwibyo rero birakwiye kwibuka ihame ryo gukoresha.

Ubutumwa uburyo bwo gukosora inkingi nke muri Excel zagaragaye mbere kuri tekinoroji yamakuru.