Nigute ushobora kuvana kurutonde rwamanutse muri excel

Uburyo 1: Siba buto muri menu

Kugirango ukureho urutonde rwamanutse muri Excel, urashobora gukora udahinduye kuri menu ikwiye kugenzurwa nibintu bisa. Umuhamagaro ubereye gusukura igikoresho bikozwe binyuze muri menu, akenshi bisaba igihe gito kuruta ihame risanzwe ryo gukuraho.

1. Ubwa mbere, shakisha urutonde rwamanutse mumeza, ukabigaragaza, hanyuma ukande iburyo-ukande.



2. Muri menu, shakisha ikintu "Gusiba" hanyuma ubikore.



3. Idirishya risanzwe ryo gukuraho Akagari rizagaragara, aho ryerekana imwe mu mahitamo ya mbere, abonye ikimenyetso cyacyo.



4. Nyuma yo gukora idirishya ryibikorwa, idirishya rifunga byikora, kandi urashobora kumenyera ibisubizo, menya neza ko kubura menu yamanutse.

Niba mu buryo butunguranye byagaragaye ko itasibwe ko urutonde cyangwa iki gikorwa kigomba guhagarikwa kubwizindi mpamvu, bahita bakanda urufunguzo rwa Ctrl + z kandi Urutonde ruzongera kugaragara muri selile imwe muburyo bwabanje.

Uburyo 2: Sobanura buto yose kurutonde rwo gucunga urutonde

Ubwo buryo bwinshi butajyanye nurutonde rwo gucunga urutonde muri Excel kandi yemerera gukuraho urutonde rwamanutse, oya, bityo tuzimukira muri menu ya "Data" kandi tuzasesengura buto ya mbere yitwa "Kuraho byose".

1. Hitamo urutonde-hasi hanyuma ufungure tab.



2. Kanda kuri buto ya "Data Kugenzura" kugirango ufungure menu yamanutse.



3. Yongera gukanda ku ngingo hamwe nizina rimwe.



4. Mugihe kitarenze isegonda, idirishya rikenewe rizagaragara, aho hepfo ibumoso, kanda kuri buto "Sobanura" byose bimaze kuvugwa.



5. Akagari kazaba imiterere isanzwe, ushobora kwemeza neza, ugaruka kumeza. Hazabaho imwe gusa mumazina yurutonde rwa kera, utazagorana.

Uburyo 3: Guhindura amakuru yamakuru

Biracyashikarije gusenya uburyo bwa nyuma, bwiruka mu idirishya rimwe "Reba indangagaciro". Bisobanura guhindura ubwoko bwamakuru ya selile nta biresumba neza. Iyi nzira irakorwa mu bwigenge, kubera ko amakuru yamakuru muriki kibazo adahari.

1. Kanda kuri buto ya "Data Kugenzura" kugirango ujye kuri menu imwe.



2. Kwagura urutonde rwamakuru ahamanuka kugirango ushire ahandi.



3. Menya "agaciro kwose" kugirango usubize selire muri leta yumwimerere.



4. Funga idirishya, subira kumeza hanyuma ukureho agaciro gasigaye ukizwa muri kasho, aho inzira yamanuka ishobora gufatwa nkuzuye.