Nigute Gusiba Imbonerahamwe Muri Excel

Uburyo 1: Urufunguzo rushyushye

Tangira Dutangwa muburyo bworoshye busobanura gukoresha Del Hotkey (Gusiba) kugirango usibe vuba ibikubiye mu bwoko ubwo aribwo bwose. Uzakenera gusa kwerekana ingendo ubwazo kugirango ugaragare kugirango uhindure ingingo zo guhindura, hanyuma ukande kuri uru rufunguzo urebe uko ikintu kizasibwa kumeza.

Niba ukanze uru rufunguzo inshuro nyinshi, urashobora kandi kwibasirwa nibindi bintu byameza, witondere rero kandi ntuzibagirwe ko hari urufunguzo rutandukanye rwa CTRL + z zihagarika ibikorwa byanyuma.

Uburyo 2: Gukata igikoresho

Muri Excel hari igikoresho cyitwa "gukata", mwizina ryayo ushobora guhita umva ko yashizweho kugirango ikureho ibintu bitari ngombwa. Yitwa uburyo bubiri butandukanye, nuburyo bwose bwo gusukura ameza muri gahunda isa nkiyi:

1. Shyira ahagaragara igishushanyo hanyuma ukande kuri buri kibanza hamwe na buto yimbeba iburyo kugirango wita ibivugwamo.



2. Hitamo "gukata".



3. Ibirimo byose bizahita bisukurwa.



4. Byongeye kandi, urashobora gukoresha "kuvunja" kuri tab "urugo", aho hari igishushanyo hamwe na kasi. Ntukagirire "

Uburyo 3: Imikorere "Birasobanutse"

Hafi yimikorere imwe ikora imikorere "isobanutse", ariko ubushobozi bwayo bushoboka ni ubwinshi. Kuri twe, bizatwara kimwe mubikorwa byayo kugirango usukure igishushanyo cyose.

1. Shyira ahagaragara igishushanyo no hejuru ya "urugo" binyuze muri tab yo guhindura.



2. Kwagura menu "isobanutse".



3. Kanda ku kintu cya mbere "Sobanura byose".



4. Garuka kumeza kandi urebe neza ko gahunda itagigaragara.

Soma ibisobanuro birambuye hamwe na "Soure" ikora, niba mugihe kizaza wifuza ko byoroshye gusiba ibiri mumeza, imiterere nibindi bintu.

Uburyo 4: Gusiba ibikubiye mu mbonerahamwe

Rimwe na rimwe, umukoresha asabwa kudakuraho burundu igishushanyo, ahubwo ni ibintu byihariye, kurugero, izina, axis cyangwa imwe mumakuru. Muri iki gihe, ihame ryibikorwa ntabwo rihindura byinshi kandi inzira ubwayo ntabwo ihinduka ingorabahizi.

1. Nyuma yinzibacyuho gukora hamwe na gahunda, hitamo ikintu wifuza kugirango uhindure igaragara kuruhande. Koresha urufunguzo rwa Del kugirango ukure vuba.



2. Ibirimo bizahita bisukurwa, bishobora kugaragara mumashusho akurikira.



3. Ubundi buryo - kora iburyo kanda kuri element hamwe nimbeba hanyuma uhitemo gusiba ikintu muri menu. Ibi biganisha ku bikorwa bimwe.

Niba ari ngombwa gusiba imbonerahamwe cyangwa ibiyirimo byatewe nuburyo butari bwo kugirango dukore indi ngingo, turagugira inama yo gusoma indi mabwiriza kurubuga rwacu, bizafasha kumenya uburyo bwiza bwibishushanyo muri Excel.

Reba kandi: Imbonerahamwe ya Microsoft Excel