Nigute washyiramo inkingi muri excel

Gukora muri Microsoft Excel, icyambere cyibanze nukwiga gushyiramo imirongo ninkingi mumeza. Hatariho ubuhanga, ntibishoboka rwose gukorana namakuru ya pular. Reka dukemure uburyo bwo kongeramo inkingi muri Excele.

Isomo: Nigute Wongeyeho inkingi mumeza yijambo rya Microsoft

Shyiramo inkingi

Muri Excel, hariho inzira nyinshi zo gushyiramo inkingi kurupapuro. Benshi muribo baroroshye, ariko umukoresha wa Novice ntashobora guhita akora ibintu byose. Mubyongeyeho, hari uburyo bwo guhita yongeramo imirongo iburyo bwameza.

Uburyo 1: Shyiramo binyuze muri panel ihuriweho

Imwe munzira zoroshye zo kwinjiza nigikorwa binyuze muri horizontal excel ihuza akanama.

1. Kanda muri Horizontal Coorntate ya Horizontal hamwe namazina yinkingi ukurikije umurenge, ibumoso ukeneye kwinjiza inkingi. Muri iki kibazo, inkingi yagenewe rwose. Kanda buto yimbeba iburyo. Muri menu igaragara, hitamo ikintu "cyanditse".



2. Nyuma yibyo, inkingi nshya ihita yongewe ibumoso bwatoranijwe.

Uburyo 2: Ongeraho Akagari hirya no muri menu

Urashobora gukora iki gikorwa kandi muburyo butandukanye, aribyo binyuze muri menu ya selire.

1. Kanda kuri selile iyo ari yo yose iherereye mu nkingi iburyo bwinkingi iteganijwe kongeramo. Kanda kuri iyi ngingo buto yimbeba. Muri ibikubiyemo bigaragara, hitamo "paste ...".



2. Iki gihe cyongeyeho ntabwo gihita. Idirishya rito rifungura, aho ushaka kwerekana ko umukoresha agiye gushyiramo:
   • Inkingi;
   • Umurongo;
   • Selile hamwe no kwimuka;
   • Selile hamwe na shift iburyo.

   Twongeye gutondekanya guhinduranya "inkingi" hanyuma ukande kuri buto "OK".



3. Nyuma yibi bikorwa, inkingi izongerwaho.

Uburyo 3: buto kuri lente

Kwinjiza inkingi birashobora gukorwa ukoresheje buto idasanzwe kuri kaseti.

1. Hitamo Akagari ibumoso bwateganijwe kongeramo inkingi. Kuba muri tab "urugo", kanda kumashusho muburyo bwa mpandeshatu yahinduwe, iherereye hafi ya buto ya "Paste" muri "Akagari" ibikoresho bya kaseti kuri kaseti. Muri menu ifungura, hitamo "shyiramo inkingi kurupapuro".



2. Nyuma yibyo, inkingi izongerwaho ibumoso bwikintu cyatoranijwe.

Uburyo 4: Gukoresha urufunguzo rushyushye

Kandi, inkingi nshya irashobora kongerwaho hamwe nurufunguzo rushyushye. Kandi hariho uburyo bubiri bwo kongeramo

1. Umwe muribo arasa nuburyo bwa mbere bwo kwinjiza. Ugomba gukanda ku murenge kuri Panel ya Horizontal ya Horizontal iherereye ku burenganzira bw'imirimo igenewe gushiramo no guhamagara Ctrl ++ urufunguzo.



2. Kugirango ukoreshe amahitamo ya kabiri, ugomba gukoresha gukanda kuri selile iyo ari yo yose mu nkingi kugeza iburyo bwimirimo yo kwinjiza. Noneho hamagara kuri ctrl ++ clavier. Nyuma yibyo, hanyuma idirishya rito uhitamo ubwoko bwo kwinjiza ubwoko, bwasobanuwe muburyo bwa kabiri bwo gukora igikorwa. Ibindi bikorwa neza ni bimwe: Hitamo ingingo "inkingi" hanyuma ukande kuri buto "OK".

Isomo: Urufunguzo rushyushye muri Excele

Uburyo 5: Shyiramo inkingi nyinshi

Niba ushaka guhita wandike inkingi nyinshi, noneho muri Excele ntabwo ari ngombwa gukora igikorwa cyihariye kuri buri kintu, kubera ko ubu buryo bushobora guhuzwa mubikorwa bimwe.

1. Ugomba kubanza guhitamo selile nyinshi muri horizontal cyangwa imirenge kuri panel ihuriweho, ninkingi zingahe zigomba kongerwaho.



2. Noneho shyira kimwe mubikorwa binyuze muri menu cyangwa hamwe nurufunguzo rushyushye rwasobanuwe muburyo bwambere. Umubare uhuye ninkingi zizongerwa ibumoso bwatoranijwe.

Uburyo 6: Ongeraho inkingi kumpera yameza

Uburyo bwose bwavuzwe haruguru bukwiriye kongeramo abavuga mu ntangiriro no hagati yimeza. Barashobora kandi gukoreshwa mugushiramo inkingi kumpera yameza, ariko muriki kibazo ugomba gukoresha neza. Ariko hariho uburyo bwo kongeramo inkingi kumpera yimeza kugirango bihita bigaragazwa na gahunda kubice byayo. Kugira ngo ukore ibi, ugomba gukora ameza yitwa ameza.

1. Turagaragaza urutonde dushaka guhindukirira ameza "yubwenge".



2. Kuba muri tab ya Murugo, kanda kuri "imiterere nkimeza", iherereye muri "Style" ibikoresho bya "Styles" kuri kaseti. Kurutonde ruhagaritswe, hitamo imwe murutonde runini rwibishushanyo mbonera byimiterere yubushishozi bwawe.



3. Nyuma yibyo, idirishya rifungura, ryerekana guhuza agace katoranijwe. Niba wabonye ikintu kibi, noneho urashobora guhindura hano. Ikintu nyamukuru nuko ukeneye gukora kuri iyi ntambwe nukugenzura niba agasanduku kashyizwe hafi y "ameza akoresheje imitwe". Niba ameza yawe afite ingofero (kandi mubihe byinshi ni ibishoboka byose), ariko nta kimenyetso cyiki kintu, ugomba rero kuyishiraho. Niba igenamiterere ryose ryashyizweho neza, hanyuma ukande kuri buto "OK".



4. Nyuma yibi bikorwa, urutonde rwabigenewe rwahinduwe nkimeza.



5. Noneho kugirango ushoboze inkingi nshya muri iyi mbonerahamwe, birahagije kugirango wuzuze selile iyo ari yo yose iburyo bwayo. Inkingi aho iyi selile iherereye izahita iba ibyuma.

Nkuko mubibona, hariho inzira zitari nke zo kongeramo inkingi nshya kurupapuro rwaba excel haba hagati yimeza no mugihe ntarengwa. Kugirango wongere kubintu byoroshye kandi byoroshye, nibyiza kurema imbonerahamwe ya "Smart". Muri iki kibazo, mugihe wongeyeho amakuru kurwego rwimeza, bizahita bishyirwa muri yo nkinkingi nshya.