Nigute ushobora gukora urupapuro rwumutungo

Anonim

Urupapuro rw'umurimo muri Microsoft Excel

Iyo icapiro inyandiko nziza, ibintu akenshi nibihe mugihe imbonerahamwe idahuye nurupapuro rusanzwe. Kubwibyo, ibintu byose birenze uyu mupaka, icapiro ricapiro kumpapuro zinyongera. Ariko, akenshi, iki kibazo gishobora gukosorwa muguhindura gusa icyerekezo cyinyandiko hamwe nigitabo, cyashyizwe mubisanzwe, ku nyamaswa. Reka tubimenye uko twabikora twifashishije inzira zitandukanye muri Excele.

Isomo: Nigute Gukora Icyerekezo nyaburanga muri Microsoft Ijambo

Hindura inyandiko

Muri porogaramu ya Excel, hari uburyo bubiri bwo kwerekeza impapuro mugihe icapiro: igitabo na nyaburanga. Iya mbere ifite agaciro kabisanzwe. Ni ukuvuga, niba utarakoze mamipuline hamwe niyi miterere mubyangombwa, noneho iyo icapiro rizajya mu cyerekezo cyigitabo. Itandukaniro nyamukuru riri hagati yubwoko bubiri bwibiryo ni uko munsi yigitabo icyerekezo uburebure bwurupapuro ari ubugari bwurupapuro, kandi hamwe nubutaka - kubinyuranye.

Mubyukuri, Mechanism yuburyo bwo guhindura page hamwe nigitabo cyitondewe mubice muri gahunda ya Excel nicyo cyonyine, ariko birashobora gutangira ukoresheje bumwe muburyo butandukanye. Muri icyo gihe, buri rupapuro rwumuntu ku giti cye rushobora gukoreshwa umwanya warwo. Mugihe kimwe, murupapuro rumwe, iyi parameter yahinduwe kubintu byihariye (impapuro).

Mbere ya byose, birakenewe kumenya niba guhindura inyandiko namba. Muri izo ntego, urashobora gukoresha kureba mbere. Kugirango ukore ibi, guhindukirira "dosiye", kwimukira mugice cya "icapiro". Mu ruhande rw'ibumoso rw'idirishya hari umurima wa mbere wo kwerekana inyandiko, nkuko bizasa mu icapiro. Niba mu ndege itambitse igabanijwemo impapuro nyinshi, noneho bivuze ko ameza adahuye nurupapuro.

Reba muri Microsoft Excel

Niba, nyuma yubu buryo, tuzasubira kuri tab "urugo", noneho tuzareba umurongo wamaguru. Mugihe iyo ihagaritse ihagaritse ameza kuruhande, iki nikimenyetso cyinyongera kivuga ko iyo ari icapiro, inkingi zose kurupapuro rumwe ntizishobora gushyirwa.

Urutonde rwimpapuro zo gutandukana muri Microsoft Excel

Bitewe nibi bihe, nibyiza guhindura icyerekezo cyinyandiko ku nyamaswa.

Uburyo 1: Igenamiterere

Akenshi, abakoresha bifashishwa ibikoresho biherereye muburyo bwanditse.

  1. Jya kuri tab ya "muri Excel 2007, aho, ugomba gukanda kuri logo office ofroce office mugice cyo hejuru cyibumoso cyidirishya).
  2. Jya kuri File tab muri Microsoft Excel

  3. Kwimukira mu gice cya "icapiro".
  4. Kashe muri Microsoft Excel

  5. Gufungura bimaze kumenyera ahantu hateganijwe. Ariko iki gihe ntabwo bizadushishikaza. Muri "SETUP" guhagarika buto ya "igitabo cyerekezo".
  6. Jya kuri Igenamiterere ryerekanwe muri Microsoft Excel

  7. Kuva kurutonde rwamanutse, hitamo ikintu "icyerekezo cyintambwe".
  8. Gushoboza icyerekezo nyaburanga muri Microsoft Excel

  9. Nyuma yibyo, icyerekezo cyimpapuro zifatika zifatika zizahindurwa ahantu nyaburanga, ishobora kugaragara mumwanya wanditse.

Icyerekezo cyahinduwe mubutaka muri Microsoft Excel

Uburyo 2: Urupapuro Markup Tab

Hariho uburyo bworoshye bwo guhindura icyerekezo cyurupapuro. Irashobora gukorerwa muri tab "page Mariko".

  1. Jya kuri tab "page". Kanda kuri buto "Icyerekezo", gishyirwa murubuga rwa "page Page". Kuva kurutonde rwamanutse, hitamo ikintu "hafi".
  2. Guhindura icyerekezo nyaburanga muri Microsoft Excel

  3. Nyuma yibyo, icyerekezo cyurupapuro kiriho kizasimburwa ahantu nyaburanga.

Icyerekezo cyahinduwe ahantu nyaburanga muri Microsoft Excel

Uburyo 3: Guhindura icyerekezo cyamabati menshi icyarimwe

Mugihe ukoresheje uburyo bwasobanuwe haruguru, icyerekezo cyerekanwe cyerekanwe gusa kurupapuro rwubu. Muri icyo gihe, hari amahirwe yo gukoresha iyi parameter kubintu byinshi bisa icyarimwe.

  1. Niba impapuro ushaka gukurikiza ibikorwa byamatsinda biherereye kuruhande, hanyuma ushireho buto ya shift kuri clavier kandi utabikuyeho, kanda kuri label ya mbere iherereye igice cyumwanya. Noneho kanda kuri label yanyuma. Rero, urwego rwose ruzagaragazwa.

    Guhitamo Urupapuro Muri Microsoft Excel

    Niba ukeneye guhinduranya page kumabati menshi, shortcuts zidaherereye kuruhande, noneho algorithm yibikorwa iratandukanye gato. Kanda buto ya CTRL kuri clavier hanyuma ukande kuri buri shortcut, ukeneye gukora ibikorwa ibumoso. Rero, ibintu bikenewe bizagaragazwa.

  2. Guhitamo impapuro kugiti cye muri Microsoft Excel

  3. Nyuma yo gutoranya, tumaze kumenyera. Jya kuri tab "page". Twahagaritse buto kuri kaseti "icyerekezo", iherereye muri "page igenamiterere". Kuva kurutonde rwamanutse, hitamo ikintu "hafi".

Gushoboza icyerekezo nyaburanga kugirango itsinda ryimpapuro za Microsoft Excel

Nyuma yibyo, impapuro zose zatoranijwe zizagira icyerekezo cyavuzwe haruguru.

Nkuko mubibona, hariho inzira nyinshi zo guhindura icyerekezo cyigitabo ku nyamaswa. Uburyo bubiri bwa mbere bwasobanuwe natwe burakoreshwa kugirango uhindure ibipimo byurupapuro. Byongeye kandi, hari ubundi buryo bugufasha gukora impinduka kumabati menshi icyarimwe.

Soma byinshi