Mburabuzi, Microsoft Excel ntabwo itanga umubare ugaragara. Muri icyo gihe, akenshi, cyane cyane iyo inyandiko yoherejwe gucapa, igomba kubarwa. Excel igufasha gukora ibirenge. Reka dusuzume amahitamo atandukanye nkimibare muriyi porogaramu.
Umubare muri Excel
Urupapuro rwa numero muri Excel rushobora gukoresha ibirenge. Bihishe muburyo busanzwe, buherereye ahantu hepfo kandi hejuru yurupapuro. Ibiranga ni uko inyandiko zanditse muri kano karere ziranyunyuza, ni ukuvuga, yerekanwa kumpapuro zose zinyandiko.Uburyo 1: Umubare usanzwe
Umubare usanzwe urimo kubarwa impapuro zose z'inyandiko.
- Mbere ya byose, ugomba gufungura umutwe wikirenge. Jya kuri tab "shyiramo".
- Kuri kaseti muri "Inyandiko" Ibikoresho Tukikanda kuri buto ya "Footer".
- Nyuma yibyo, excel guhinduranya muburyo bwa Markip, kandi ibirenge byerekanwe kumpapuro. Baherereye mu gace kari hejuru no hepfo. Byongeye kandi, buri kimwe muri byo kigabanyijemo ibice bitatu. Hitamo, aho umugori, kimwe no muri kiriya gice icyo aricyo, umubare uzakorwa. Mubihe byinshi, igice cyibumoso cyukuryama watoranijwe. Kanda ahabigenewe aho uteganya gushyira icyumba.
- Muri Worbactor Tab ya Block yinyongera ya "Akazi hamwe na footers" ukanze kurupapuro rwa nimero, ushyirwa kuri kaseti mu itsinda rya Togbin.
- Nkuko mubibona, tagi idasanzwe "& [urupapuro] rugaragara. Ko rero byahinduwe mumibare ikurikirana, kanda kumurima uwo ariwo wose winyandiko.
- Noneho nimero ikurikiranye yagaragaye kuri buri rupapuro rwinyandiko ya Eel Exel. Kugirango igaragare cyane kandi igaragare kumurongo rusange, irashobora guhindurwa. Kugirango ukore ibi, garagaza ibyafashwe mu kirenge hanyuma uzane indanga kuriwo. Ibikubiyemo byerekana aho ushobora gukora ibikorwa bikurikira:
- hindura ubwoko bw'imyandikire;
- kora imbere cyangwa ushize amanga;
- Guhindura;
- Hindura ibara.
Hitamo ibikorwa ushaka guhindura icyerekezo cyerekana umubare kugeza igihe kigushimishije.
Uburyo 2: Kubara byerekana umubare wuzuye wamabati
Byongeye kandi, urashobora noneho kubarirwa muri Excel, byerekana umubare wabo wose kuri buri rupapuro.
- Kora umubare werekana, nkuko bigaragara muburyo bwambere.
- Mbere ya tagi, andika ijambo "page", na nyuma yacyo twanditse ijambo "hanze".
- Shyira indanga mumurima wumurenge nyuma yijambo "Hanze". Kanda kuri buto "Umubare wimpapuro", uherereye kuri kaseti muri tab "murugo".
- Kanda ahantu hose winyandiko kugirango aho kuba tagi, indangagaciro zigaragara.
Noneho dufite amakuru atari kumurongo wubu, ariko nanone kubyerekeye umubare wabo.
Uburyo bwa 3: Umubare wurupapuro rwa kabiri
Hariho imanza inyandiko yose ikenewe kugirango ibaze, ariko itangira ahantu runaka. Reka tumenye uko twabikora.
Kugirango ushireho umubare kurupapuro rwa kabiri, kandi birakwiye, kurugero, mugihe wandika gukuramo, impapuro za siyansi, mugihe page yumutwe, mugihe page yumutwe atemerera kuba imibare, ugomba gukora ibikorwa bikurikira.
- Jya muburyo bwa footer. Ibikurikira, twimukira muri "Forewear Crubator" tab, iherereye muri "Akazi hamwe na COOST".
- Muri "ibipimo" ibikoresho kuri kaseti, shyira ahagaragara igenamiterere "footer yihariye kurupapuro rwa mbere".
- Twashizeho umubare ukoresheje buto "Urupapuro Umubare", nkuko bimaze kugaragara hejuru, ariko ubikore kurupapuro urwo arirwo rwose, usibye mbere.
Nkuko tubibona, nyuma yibyo, impapuro zose zirabaze, usibye iyambere. Byongeye kandi, urupapuro rwa mbere rwafashwe muburyo bwo kubara izindi mpapuro, ariko, nyamara, ntabwo igaragara kuri yo ubwayo.
Uburyo 4: Kubara kurupapuro rwerekanwe
Muri icyo gihe, hari ibihe mugihe bibaye ngombwa ko inyandiko itangira kuva kurupapuro rwa mbere, ariko, kurugero, hamwe na gatatu cyangwa karindwi. Ibikenewe nkibi ntabwo ari kenshi, ariko, nyamara, rimwe na rimwe ikibazo nacyo gisaba igisubizo.
- Dukora umubare muburyo busanzwe, dukoresheje buto ijyanye na kaseti, ibisobanuro birambuye byatanzwe hejuru.
- Jya kuri tab "page".
- Kuri kaseti mugice cyo hepfo yibumoso bwa "page igenamiterere" ibikoresho byahagaritswe hari igishushanyo muburyo bwumwambi ugana. Kanda kuri.
- Idirishya rya Parameter rifungura, jya kuri tab "page", niba yarakinguye muyindi tab. Twashyize mu murima w'urupapuro rwa mbere "Ibipimo byambere, umubare, umubare ugomba gukorwaho. Kanda kuri buto ya "OK".
Nkuko mubibona, nyuma yibi, umubare wurupapuro rwambere mubyanditswe wahindutse kuri imwe yasobanuwe mubipimo. Kubwibyo, umubare w'amabati yakurikiyeho nawo nawo.
Isomo: Nigute ushobora gukuraho footer muri excel
Urupapuro rwa numero mumyitozo ya Excel Excel iroroshye. Ubu buryo bukorwa hamwe nuburyo bwo mutwe kuri. Byongeye kandi, umukoresha arashobora gushiraho umubare wayo ubwayo: Shiraho kwerekana umubare, ongeraho kwerekana umubare wimibare yose, kubarwa uhereye ahantu runaka, nibindi