Nigute Gukosora Umutwe muri Excel

Anonim

Umutwe wo gushiraho Microsoft Excel

Ku mpamvu zimwe, abakoresha bakeneye igikombe cyimbonerahamwe burigihe imbere, nubwo urupapuro rwampaye. Byongeye kandi, ni ngombwa kenshi, mugihe ucapira inyandiko kumubiri (impapuro), umutwe wameza ryerekanwe kuri buri rupapuro rwacapwe. Reka tumenye uburyo ushobora gukosora umutwe muri poro Microsoft Express.

Gukubita umutwe mumurongo wambere

Niba igishushanyo mbonera kiri kumurongo wo hejuru, kandi ntigitwara kumurongo umwe, noneho gukosorwa nikikorwa cyibanze. Niba imwe cyangwa nyinshi zidafite ubusa ziri hejuru yumutwe, bazakenera gukurwaho kugirango bakoreshe iyi nshingano.

Kugirango ugire umutekano, mugihe muri "Reba" ya porogaramu ya Excel, kanda ahanditse "umutekano. Akabuto kari kuri kaseti muri "idirishya" ryibikoresho. Byongeye, kurutonde rufungura, hitamo "Umurongo wo hejuru".

Gufunga umurongo wo hejuru muri Microsoft Excel

Nyuma yibyo, umutwe uri hejuru kumurongo wo hejuru uzakosorwa, uhora uri mumupaka wa ecran.

Umugozi wo hejuru ushyizwe muri Microsoft Excel

Gukosora akarere

Mugihe iyo ari yo yose, umukoresha adashaka gukuraho selile zihari hejuru yumutwe, cyangwa niba igizwe numurongo urenze umwe, ubwo buryo bwavuzwe haruguru bwo guhuriza hamwe ntibizakwira. Tugomba gukoresha amahitamo hamwe no gufunga akarere, ariko, ntabwo bigoye cyane nuburyo bwa mbere.

Mbere ya byose, twimukira kuri tab "kureba". Nyuma yibyo, kanda kuri selile yibumoso munsi yumutwe. Ibikurikira, dukora gukanda kuri buto "funga agace", byari bimaze kuvugwa haruguru. Noneho, muri menu igezweho, ongera uhitemo ikintu hamwe nizina rimwe - "funga agace".

Gufunga agace muri Microsoft Excel

Nyuma yibi bikorwa, umutwe wimbonerahamwe uzandikwa kurupapuro rwubu.

Agace karashingiwe muri Microsoft Excel

Kuraho gukubita umutwe

Urwego rwibanze rwimbonera rwameza yumutwe karashyirwaho, kugirango tubyiboneye, hariho inzira imwe gusa. Na none, dutanga gukanda kuri buto kuri kaseti "funga agace", ariko iki gihe duhitamo umwanya "kugirango dukureho gushimangira uturere".

Kuraho Guhuza Agace muri Microsoft Excel

Nyuma yibi, umutwe wubatswe uzagenda, kandi iyo uzungurutse urupapuro, ntizagaragara.

Umutwe usenywa muri Microsoft Excel

Gutwika umutwe

Hariho imanza mugihe ucapishije inyandiko isabwa ko umutwe uhari kuri buri rupapuro rwacapwe. Birumvikana, urashobora kwicogora "kumena" ameza, no ahantu wifuza kwinjira mumutwe. Ariko, iyi nzira irashobora guhunga umwanya munini, kandi, byongeye, impinduka nkizo zishobora gusenya ubusugire bwameza, nuburyo bwo kubara. Hariho inzira yoroshye cyane kandi ifite umutekano kumeza ameza hamwe nizina kuri buri page.

Mbere ya byose, twimukira muri tab "page". Turashaka "igenamiterere ryibabi". Mu mfuruka yo hepfo ibumoso hari igishushanyo muburyo bwa oblique umwambi. Kanda kuri iki gishushanyo.

Hindura urupapuro rwabigenewe muri Microsoft Excel

Idirishya rifungura hamwe nurupapuro. Twimukira ku kantu "urupapuro". Mu murima hafi yanditse "Icapa kuri buri paji ukoresheje imirongo" Ugomba kwerekana imirongo yumurongo izina riherereye. Mubisanzwe, kubakoresha utiteguye, ibi ntabwo byoroshye. Noneho, kanda kuri buto yashyizwe iburyo bwimiterere yinjira.

Urupapuro rwa parastere muri Microsoft Excel

Idirishya hamwe na page Ibipimo birabujijwe. Muri icyo gihe, urupapuro rukora ameza aherereye. Hitamo gusa umurongo (cyangwa imirongo myinshi) kugirango izina rishyireho. Nkuko mubibona, ihuriro ryinjiye mu idirishya ryihariye. Kanda kuri buto iherereye iburyo bwiyi idirishya.

Umutwe wo gutoranya muri Microsoft Excel

Idirishya rifungura hamwe nurupapuro. Twagiye gusa gukanda kuri buto "OK" iherereye mu mfuruka yiburyo.

Kuzigama page igenamiterere muri Microsoft Excel

Ibikorwa byose bikenewe byakozwe, ariko ntuzabona impinduka zose. Kugirango ugenzure niba izina ryameza ryacapwe kuri buri rupapuro, jya kuri tab ya "dosiye" ya porogaramu ya Excel. Ibikurikira, jya kuri "icapiro".

Inzibacyuho Kureba Imbonerahamwe muri Microsoft Excel

Kuruhande rwiburyo bwidirishya ryafunguye ahantu hateganijwe inyandiko yacapwe. Kuramo hasi, kandi urebe neza ko iyo ucapishe, umutwe wakomye uzerekanwa kuri buri rupapuro.

Imbonerahamwe yo kureba muri Microsoft Excel

Nkuko mubibona, hari inzira eshatu zo gukosora umutwe kumeza ya Microsoft Excel. Babiri muri bo bagenewe gushimangira kumeza mumeza, iyo bakorana ninyandiko. Uburyo bwa gatatu bukoreshwa mugusohora umutwe kuri buri rupapuro rwinyandiko yacapwe. Ni ngombwa kwibuka ko bishoboka gukosora umutwe binyuze mugukosora umurongo gusa niba iherereye kuri umwe, hamwe numurongo wo hejuru wurupapuro. Mubinyuranye, ugomba gukoresha uburyo bwo gutunganya ibintu.

Soma byinshi