Nigute ongeraho selile kuri excel. Inzira 3 zo kongeramo selile kumeza ya Exel

Urashobora kuvuga ufite ikizere ko abakoresha bose bazi kongeramo selile nshya mumeza ya Excel, ariko ntabwo abantu bose bazi ko ibintu byose bizewe byiki gikorwa. Muri rusange, inzira 3 zitandukanye zirazwi ukoresheje ibyo bishoboka gukora selile. Akenshi uburyo bwo gukemura ibibazo biterwa nuburyo bwakoreshejwe. Suzuma ku buryo burambuye, ubifashijwemo nuburyo bushoboka bwo kongeramo selile kumeza ya Exel.

Ongeraho selile kumeza

Umubare munini wabakoresha bemeza ko mugihe cyongeyeho selile, kwiyongera kwabo, kuva ikintu gishya kigaragara. Ariko, ibi ntabwo bihuye nukuri, kuko umubare wabo wose uzakomeza kuba umwe. Mubyukuri, ni ihererekanya yikintu kuva kumpera yimbonerahamwe ahantu hasabwa hamwe no gukuraho amakuru ya selile yimutse. Urebye ibi, bigomba kwitondera mugihe bimuka, kubera ko bishoboka gutakaza amakuru amwe.

Uburyo 1: Gukoresha Ibikubiyemo Byungirabuzimafatizo

Uburyo burimo gusuzumwa bukoreshwa inshuro kurenza abandi, nkuko bigaragara ko byoroshye gukoreshwa. Kugirango wongere selile nkubu buryo, ugomba gukurikiza algorithm ikurikira yibikorwa:

1. Dushyira imbeba yerekana ahantu runaka yinyandiko ukeneye kongeramo ikintu. Nyuma yo guhamagara ibikubiyemo byatoranijwe ukanze PCM no kurutonde rwa pop-up ya formategeko, hitamo "kanda ...".

Selile yinjiza binyuze muri menu

1. Monitor izamuka hejuru yidirishya. Noneho ugomba gushyira ikimenyetso hafi ya "selile". Hariho uburyo 2 bwo gushiramo - hamwe na shift iburyo cyangwa hepfo. Ugomba guhitamo amahitamo asabwa murubanza runaka hanyuma ukande OK.
2. Nyuma yibyo, urashobora kubona ko ikintu gishya kizagaragara aho kuba intangiriro, hejuru hamwe nabandi.

Uburyo bumwe birashoboka kongeramo selile nyinshi:

1. Umubare wifuzwa wingirabuzimafatizo. Ibikubiyemo byitwa gukanda PCM kumurongo wagenwe hanyuma uhitemo "Paste ...".

Shyiramo selile nyinshi zinyuze muri menu

1. Muburyo bushoboka, hitamo imwe isabwa hanyuma ukande "OK".
2. Ingirabuzimafatizo nshya zizagaragara aho kurangizwa, yimukiye iburyo hamwe nabandi.

Uburyo 2: Gukoresha igikoresho kidasanzwe muri menu nkuru

1. Nko mu rubanza rwashize, ni mu ntangiriro imbeba yerekana aho hazashyirwaho selile yinyongera. Ibikurikira, muri menu, hitamo tab yo murugo, nyuma yo gufungura igice "selile" aho ukande "shyiramo".

Shyiramo selile ukoresheje menu nkuru

1. Mu gace kagaragaye ko hazahita hishurirwa selile. Ariko hamwe nuburyo busa, kwinjiza guhindura hasi gusa, ni ukuvuga, shyiramo selile hamwe nuruhande rwiburyo bwuburyo burimo gusuzumwa ntabwo buzagerwaho.

Na genalogiya nuburyo bwa mbere hari uburyo bwo kongeramo selile nyinshi:

1. Hitamo umubare wifuzwa wa selile mumurongo (utambitse). Ibikurikira, kanda kurinditse "Shyiramo".

Shyiramo selile nyinshi zinyuze muri menu nkuru

1. Nyuma yibyo, selile zinyongera zongeweho kwimura ibintu byeguriwe hamwe nabandi.

Ibikurikira, tekereza uko bigenda iyo uhisemo kutagira umurongo hamwe na selile, ariko inkingi:

1. Birakenewe kwerekana selile yumurongo uhagaze hanyuma ukande "Shyiramo" Inyandiko muri tab nkuru.
2. Mubihe nkibi, selile zizongerwa kumugaragaro iburyo bwurutonde nibintu byambere bivuye kuri yo.

Birakwiye kandi gushimangira uburyo bwo kongeramo selile zitandukanye, zirimo umubare wibintu bihagaritse kandi bitambitse:

1. Nyuma yo gutoranya urwego rusabwa, ibikorwa bimenyerewe bikorwa, ni ukuvuga muri tab "murugo", kanda ahanditse "Shyiramo".
2. Noneho urashobora kubona ko ibintu byongeweho bimuwe.

Mugihe cyongeyeho intera ya selile, isobanura imirongo yumurongo ninkingi irimo:

• Iyo hari urukurikirane rushingiye ku rutonde rumwe kuruta gutambuka, hanyuma selile zinyongera zizamurwa mugihe wongeyeho.
• Iyo hari imirongo itambitse itambitse murwego rwo guhagarikira, hanyuma selile zizamwimurwa iburyo iyo wongeyeho.

Mugihe ukeneye kumenya mbere uburyo selile yinjijwe, igomba gukorwa nkibi:

1. Hano hari ahantu selile (cyangwa nyinshi) izinjizwa. Noneho ugomba guhitamo igice "selile" hanyuma ukande kumashusho ya mpandeshatu yahinduwe kuruhande "shyiramo". Muri pop-up menu, kanda kuri "Shyiramo selile ...".
2. Ibikurikira bigaragara idirishya rifite ibipimo. Noneho ukeneye guhitamo amahitamo akwiye hanyuma ukande "OK".

Uburyo 3: Shyira selile hakoreshejwe urufunguzo rushyushye

Abakoresha bakomeye ba gahunda zitandukanye bakunda inzira, bakoresheje urufunguzo rugenewe izo ntego. Excel nanone ifite umubare wingenzi wimiterere ikwemerera gukora umubare munini wibikorwa cyangwa gukoresha ibikoresho bitandukanye. Uru rutonde rurimo guhuza urufunguzo rwo gushiramo selile.

1. Ubwa mbere birakenewe kujya aho hateganijwe selile ateganijwe (intera). Ibikurikira, "ctrl + shift + =" buto ihita ikanda.

Shyiramo selile hamwe nurufunguzo rushyushye

1. Idirishya rimenyerewe rigaragara hamwe no gushyiramo amahitamo. Ibikurikira, ugomba guhitamo inzira wifuza. Nyuma yibyo, bizasigara gusa gukanda "ok" kugirango ugaragare a selile.

Umwanzuro

Ingingo yasesenguye uburyo bwose bwo kwinjizamo selile kumeza ya Excel. Buri rutonde rumeze nkabandi muburyo bwo gufata kandi ibisubizo byagezweho, ariko ni ubuhe buryo bwo gukoresha bugomba gufatwa icyemezo cyo guhitamo kuva mubihe. Uburyo bworoshye cyane nimwe gitanga gukoresha imfunguzo zigamije gushyiramo kwinjiza, ariko mubyukuri, abakoresha benshi bakunze gukoresha ibikubiyemo.

Ubutumwa uburyo bwo kongeramo selile kuri excel. Uburyo 3 bwo kongera selile kumeza ya Excel yagaragaye mbere kugirango akore amakuru yamakuru.