Nigute wandika kumeza ya Excel kurupapuro rumwe. Guhindura icyerekezo, gushiraho imipaka yinkingi na rots, page no gucapa ibipimo

Iyo akazi karangiye kuri Microsoft Office Clonl, abakoresha bafite icyo ari ngombwa gucapa inyandiko. Ibikoresho byubatswe muri gahunda bigufasha gucapa kumeza rwose kurupapuro rwa A4. Ariko, ibi bizasaba byinshi bya manipulations izaganirwaho muriyi ngingo.

Gushiraho page

Mbere ya byose, ugomba kugenzura igenamiterere ryimpapuro zikora ubu hanyuma uhindure nibiba ngombwa. Hariho ibipimo byinshi nkaba indashyikirwa, kugirango dusobanukirwe neza ingingo, birakenewe kubitekereza muburyo burambuye buri kimwe muri byo.

Inzira igana "Page Ibipimo". Algorithm ijyanye na verisiyo zose za Excel Tabs

Iyi niyo ntera kuva hejuru yidirishya rya porogaramu. Bimwe mubintu byayo bizagomba gukoresha mugihe ushyiraho urupapuro.

Urupapuro

Kugenzura icyerekezo cyurupapuro hanyuma uhinduke, ni ngombwa gukora ibikorwa bikurikira kuri algorithm:

1. Hindura kurubuga "urupapuro rwamakuru" hejuru ya Microsoft Excel.
2. Hasi yigabanyirizo ryo kubona page "urupapuro rwerekana" hanyuma ukande kuri mukuru, uherereye mu mfuruka yiburyo. Idirishya rihuye rigomba gufungura.
3. Himura igice cya "page" kugirango ukore igenamiterere rikwiye.

Ibikorwa bigomba gukorwa mugice cya "page" kugirango ushire kumeza kurupapuro rumwe

Iyo icapiro ryameza muri excel, ni ngombwa gusuzuma ingano yumurima. Iyi ni intera iringaniye kuva ku nkombe yikibabi mbere yo gutangira inyandiko. Reba indangagaciro zerekanwe mu nzego zikurikira:

1. Nk'uko gahunda imwe yaganiriweho mu gika kibanziriza iki, yimuke mu gice "Urupapuro" hejuru ya porogaramu, hanyuma ukande buto ya "Urupapuro Igenamiterere".
2. Mu idirishya rimenyerewe, rizerekanwa nyuma yo gukora ibi bikoresho, ugomba kujya muri tab "imirima".
3. Iki gice cyumukoresha gishishikajwe nikintu "hagati kurupapuro". Ukurikije icyerekezo cyurupapuro hano ukeneye gushyira akamenyetso cyangwa uteganye umurima "uhagaritse" cyangwa kuruhande rwagaciro ".
4. Hindura indangagaciro zo hejuru no hepfo footer nibiba ngombwa. Ariko, ibi ntibishobora gukorwa muriki cyiciro.

Hindura indangagaciro zo hejuru hamwe na footer mumirima. Birasabwa kandi gukoresha imikorere yo hagati.

Iyi niyo tab yanyuma kurupapuro "urupapuro rwerekana", ishinzwe ireme ryinyandiko zacapwe. Muri iki gice, urashobora kwerekana kimwe muburyo bwo gucapa: gride, umukara n'umweru, bikabije, imitwe ikomeye ninkingi. Birashoboka kandi kwerekana igice cyimbonerahamwe yo gucapa niba isahani yose idashyizwe kurupapuro rumwe yandika ibipimo byifuzwa muri "Shira umurongo".

Urupapuro "Urupapuro" murupapuro "Urupapuro Ibipimo" bya Footers

Ibi nibice bimwe byinyandiko bizahita bicapa kuri buri gice. Yagabanije agaciro k'ibirenge, uyikoresha arekura umwanya winyongera kurupapuro rwakazi, azafasha kwerekana ikimenyetso. Kugirango ukureho burundu binyuze mu nyandiko ziva mu nyandiko zose zizagaragara iyo icapiro, ugomba gukora ukurikije amabwiriza:

1. Jya kuri tab "page Mariko" hejuru ya menu nkuru ya gahunda.
2. Kanda inshuro imwe kuri "page igenamiterere".
3. Kanda ku Ijambo "Footers" muburyo bwo hejuru ishusho yerekana Windows.
4. Mu murima "ikirenge cyo hejuru" na "Umutwe" shyira agaciro "(Oya)" kugirango ukureho rwose mu nyandiko.

Kuzimya imitwe mugice gikwiye

Iyo umukoresha agaragaza ibipimo byose bikenewe, bizashoboka guhinduranya inyandiko yo gucapa. Kubwiyi ntego, ugomba gukora intambwe zikurikira:

1. Mu buryo nk'ubwo, jya mu "rupapuro".
2. Mu idirishya rifungura, jya kuri tab "page".
3. Hasi ya menu, ugomba gukanda buto ya "Reba", nyuma yinyandiko nkuru yicapiro ifungura.
4. Iburyo bwidirishya ryakinguye rizerekanwa ahomeza ku bakozi. Niba ibintu byose bihuye hano, noneho ugomba gukanda kuri buto ya "Icapa" iherereye hejuru yibumoso. Nibiba ngombwa, muriyi idirishya, urashobora gukosora ibipimo byacapwe ugahita urebe impinduka.

Ibisohoka byicapiro hamwe no kureba mbere

Uburyo bwo kugabanya (compress) Imbonerahamwe nini yo gucapa kurupapuro rumwe

Rimwe na rimwe, imbonerahamwe nini cyane muri Excel ntabwo ihuye nurupapuro rumwe. Mubihe byubu, urashobora kugabanya imbonerahamwe yumurongo wifuzwa kugirango ubihuze kurupapuro rumwe. Ubu buryo bukorwa mubyiciro byinshi, buri kimwe muricyo kizasobanurwa hepfo.

Injiza urupapuro rumwe

Ubu buryo bufite akamaro niba igice gito cyimbonerahamwe kirenze urupapuro rumwe nkora. Guhuza isahani kurupapuro rumwe, uzakenera gukora umubare utari muto utoroshye:

• Kwagura igice cya dosiye mugice cyo hejuru cyibumoso cya porogaramu ukanze kuri lkm.
• Mubya menu, kanda kumurongo "Icapa".

Inzira igana "Icapa Parameter" Idirishya muri Excel

• Kuruhande rwiburyo bwidirishya ryerekana amakuru yose yerekeye gucapa inyandiko. Hano umukoresha azakenera kubona agace ka "Gushiraho".
• Kanda kumusaza hamwe na Radomu hamwe na "ubungubu" hanyuma ukande kumahitamo "andika urupapuro kurupapuro rumwe."
• Tegereza kugeza imiterere ya Microsoft Excel irangiza inzira yo guhuza ameza hanyuma ifunga idirishya hamwe na igenamiterere.
• Reba ibisubizo.

Guhindura Umwanya

Agaciro gasanzwe gaciro katewe na Excele gafata umwanya munini kurupapuro. Kurekura umwanya, iyi parameter igomba kugabanuka. Noneho imbonerahamwe irashobora gushyirwa kurupapuro rumwe. Ni ngombwa gukora ku buryo bukurikira:

• Nk'uko gahunda yaganiriweho hejuru, jya mu gice "Page Page", hanyuma ukande buto "Urupapuro".

Gufungura page "page igenamiterere". Intambwe na intambwe algorithm

• Mu idirishya ryerekanwe, hindukirira igice "imirima".
• Mugabanye hejuru, hepfo, ibumoso nububuryo bwimirima cyangwa gukora iyi parameter zeru, hanyuma ukande "OK".

Guhindura ingano yimirima muri tab ya "page Page Page" muburyo bwa page

Ihitamo muri Excel, rigufasha muburyo bwo kwerekana imipaka yurupapuro rwakazi, ugereranije ubunini bwabo. Inzira yo kwikuramo ameza ukoresheje uburyo bwa page igabanijwemo ibyiciro byinshi, buri kimwe kikwiye kwiga witonze:

• Fungura urupapuro rwawe hanyuma uhindukire kuri tab "Reba", iherereye hejuru ya porogaramu nkuru.
• Mubikoresho byafunguwe, kanda kuri buto "Gap Mode" kugirango ukore amahitamo.

Ibikorwa byo gukora page Mode muri Excel

• Mu idirishya rishya, shakisha umurongo wa kabiri wubururu hanyuma ubimure uhereye ibumoso kugeza iburyo bukabije. Nkuko iyi strip igenda, ingano yimbonerahamwe izagabanuka.

Icyerekezo cy'ibabi

Kugirango uhuze ameza kurupapuro rumwe, ni ngombwa guhitamo icyerekezo neza. Algorithm ikurikira izafasha guhindura icyerekezo cyinyandiko:

1. Fungura uburyo bwo mumuhanda, bikaba bishoboka ko bishoboka kumva imiterere ya plac kurupapuro rwakazi. Kugirango ukoreshe uburyo, ugomba kujya kuri tab "kureba" hejuru ya menu nkuru ya gahunda, hanyuma mubikoresho bya Toolka hepfo, kanda kuri buto "Page Page".
2. Noneho ugomba kujya mubice "page Markup" hanyuma ukande kumurongo "icyerekezo".
3. Hindura icyerekezo kiriho hanyuma urebe aho ameza. Niba umurongo ushyizwe ku rupapuro rwakazi, noneho icyerekezo cyatoranijwe gishobora gusigara.

Guhindura icyerekezo cyurupapuro muri Excel Guhindura ingano ya selile

Rimwe na rimwe, isahani ntabwo ibangamira urupapuro rumwe kubera selile nini. Kugirango ukosore ikibazo cya selile, birakenewe kugabanya haba mu cyerekezo gihagaritse cyangwa butambitse bitewe nibibazo byihariye. Kugirango uhindure ibintu by'ameza array, manipulations ikurikira igomba gukorwa:

• Hitamo byuzuye inkingi cyangwa umugozi wifuzwa mumeza hamwe nurufunguzo rwibumoso rwa Manipulator.
• Kanda selile ya LKM kumupaka winkingi cyangwa imirongo hanyuma ubimure muburyo bukwiye: ibumoso buhagaritse cyangwa butambitse. Byunvikana neza yerekanwe mumashusho hepfo.

Kugabanuka kw'intongo mu bunini bwa selile muri Microsoft Office Excel

• Nibiba ngombwa, hindura ingano ya selile zose. Kubwiyi ntego, ugomba kubanza guhindura tab "urugo", hanyuma ujye mu gice "selile".
• Ibikurikira, ohereza igice "Imiterere" no muri menu, kanda kumurongo "umurongo wuburebure rusange".

Gukora imikorere yo kuzuza imirongo yuburebure

Icapa igice cyangwa igice cyahariwe

Muri Excel, urashobora gucapa gusa igice cyumukoresha. Kugirango ukore ibi, uzakenera gukora intambwe nyinshi kuri algorithm:

1. Hitamo ahantu wifuza kumeza array ibumoso.
2. Kanda kuri buto ya "dosiye" mugice cyo hejuru cyibumoso cya ecran.
3. Kanda umurongo wa "Gucapa".
4. Mu gikurikira, gushiraho kuruhande rwiburyo bwa ecran, kanda LKM ukurikije "Icapa ryatanze ibisobanuro".
5. Reba ibisubizo. Byatoranijwe mbere yimbonerahamwe igomba gucapwa.

Gucapa gusa ibimenyetso byatoranijwe

Nigute wandika imbonerahamwe yubusa kugirango wuzuze selile kurupapuro rwose

Gukora umurimo ukeneye:

1. Mu buryo nk'ubwo gukora "urupapuro rwerekana" muguhinduka "kureba". Imirongo ikurikiraho ako gace kazarangwa ni imbibi zimpapuro zakazi.
2. Hitamo selile iyo ari yo yose ukanda urufunguzo rwibumoso rwa Manipulator.
3. Kanda kuri selile ya PCM hanyuma uhitemo amahitamo ya "Imiterere yingabo" mumirongo yingingo.
4. Ibindi byiyongera bizakingura, aho ukeneye guhindura igice "umupaka" uva hejuru.
5. Kanda buto "hanze" na "imbere" uhitamo pictograde ikwiye.

Gukora amatora yo hanze na imbere yo gucapa imbonerahamwe yubusa

1. Kanda "OK" hepfo yidirishya hanyuma urebe ibisubizo.

Shira impapuro ebyiri zinyandiko zavuzwe kurupapuro rumwe

Iki gikorwa kirimo gukora icapiro ry'ibihugu byombi. Gushyira mu bikorwa ubu bushobozi bwo gukenera:

1. Kanda buto ya LKM kuri "dosiye" hejuru ya menu nkuru.
2. Jya kuri "icapiro".
3. Kwagura "Gucapa kw'ibihugu" hanyuma uhitemo bumwe mu buryo bushoboka usoma ibisobanuro byazo.

Gukora kubicana kabiri kuruhande

Umwanzuro

Rero, muri Excel, bihuye nimeza hamwe namakuru manini kurupapuro rumwe nuworoshye. Ikintu cyingenzi cyo gukora umubare wibisobanuro bijyanye, nyamukuru byasobanuwe haruguru.

Ubutumwa Nigute wandika kumeza ya Excel kurupapuro rumwe. Guhindura icyerekezo, gushiraho imipaka yinkingi n'imirongo, ibipimo byurupapuro hanyuma wandike byagaragaye mbere kuri tekinolojiya.