Nigute Gukora Ingirabuzimafatizo zingana muri Excel

Akenshi, mugihe ukorana nameza ya excel, ugomba guhindura ubunini bwa selile. Biragaragara ko ibintu bigize indangagaciro zitandukanye ziboneka kurupapuro. Nibyo, ntabwo buri gihe bifite ishingiro nibikorwa bifatika kandi ni byiza akenshi bidashimisha umukoresha. Kubwibyo, ikibazo kivuka uburyo bwo gukora selile kimwe mubunini. Reka tumenye uburyo bashobora guhumurizwa.

Ingano yo guhuza

Kugirango uhuze ingano ya selile kurupapuro, ugomba gukoresha inzira ebyiri: hindura ingano yinkingi na rots.

Ubugari bw'inkingi burashobora gutandukana kuva kuri 0 kugeza 255 (ingingo 8.43 zashyizweho muburyo busanzwe), uburebure bwumugozi ni amanota 0 kugeza 409 (busanzwe). Uburebure bumwe ni santimetero 0.035.

Niba ushaka gupima uburebure n'ubugari, urashobora gusimbuza ubundi buryo.

1. Kuba muri tab "dosiye", kanda kuri "ibipimo".



2. Mu idirishya rya Portl rifungura, dukora inzibacyuho ku kintu "cyateye imbere". Mu gice cyo hagati yidirishya dusangamo "ecran" guhagarika parameter. Turagaragaza urutonde rwerekeye "Ibice kumurongo" parameter hanyuma uhitemo bumwe muburyo bune bushoboka:
   • Santimetero;
   • Santimetero;
   • Milimetero;
   • Ibice (byashyizwe mubitekerezo).

   Nyuma yo kwiyemeza hamwe nagaciro, kanda kuri buto "OK".

Rero, urashobora gushiraho igipimo uyikoresha areba neza. Iyi sisitemu izezwa nyuma mugihe isobanura uburebure bwakazi nubugari bwinkingi yinyandiko.

Uburyo 1: Guhuza selile yumurongo wabigenewe

Mbere ya byose, tuzumva uburyo bwo guhuza selile zurwego runaka, nk'ameza.

1. Turagaragaza intera kurupapuro duteganya gukora ubunini bwa selile bingana.



2. Kuba muri tab "urugo", kanda ahanditse RIBBON kuri "imiterere", ishyirwa mubikoresho "selile". Urutonde rwimiterere irafungura. Mubunini bwugari guhagarika, hitamo ikintu "uburebure bwumurongo ...".



3. "Uburebure bw'umurongo" bufungura. Twinjiye mumurima umwe urimo, ingano mubice byifuzwa kwinjiza kumurongo wose wurwego rwatanzwe. Hanyuma ukande kuri buto "OK".



4. Nkuko tubibona, ubunini bwa selile yintera ntarengwa yagereranijwe. Noneho tuzakenera kwiyumvisha mubugari. Kugirango ukore ibi, utakuyeho guhitamo, wongeye guhamagara menu ukoresheje buto "imiterere" kuri kaseti. Iki gihe mubunini bwa "ubunini bwa selire", hitamo ingingo "ubugari bwinkingi ...".



5. Idirishya ritangira kimwe nkuko byari bimeze mugihe uburebure bwumurongo. Twinjiye mubugari bwinkingi mubice mumurima, bizakoreshwa murwego rwihariye. Kanda kuri buto ya "OK".

Nkuko dushobora kubibona, nyuma yimibare yuzuye, selile y'akarere katoranijwe yabaye kimwe mubunini.

Hariho ubundi buryo bwo kuri ubu buryo. Urashobora guhitamo kuri horizontate ya horizontal ihuza inkingi, ubugari ukeneye kubikora. Noneho kanda kuri iri genda hamwe na buto yimbeba iburyo. Muri menu ifungura, hitamo ingingo "ubugari bwinkingi ...". Nyuma yibyo, idirishya rifungura kumenyekanisha ubugari bwinkingi yurwego rwiyeguriye, ibyo twavuze haruguru.

Mu buryo nk'ubwo, tugaragaza ihuriro ryerekeye itsinda rihagaritse ry'umurongo w'urwego dushaka gutanga. Hamwe na buto yimbeba iburyo kuri panel, muri menu ifungura, hitamo ikintu "uburebure bwumurongo ...". Nyuma yibyo, idirishya rifungura aho uburebure bugomba gukorwa.

Uburyo 2: Guhuza selile y'urupapuro rwose

Ariko hariho ibibazo mugihe ari ngombwa kuringaniza selile ntabwo ari urwego rwifuzwa gusa, ahubwo urupapuro rwose muri rusange. Ni intoki zagenewe kugenera - isomo rirerire cyane, ariko haribishoboka hagomba gutangwa kubwiki gukanda.

1. Kanda kuri urukiramende giherereye hagati yumurongo utambitse kandi uhagaritse. Nkuko mubibona, nyuma yibyo, urupapuro rwose rugenewe burundu. Hariho ubundi buryo bwo kwerekana urupapuro rwose. Kugirango ukore ibi, amanota gusa na ctrl + clavier kuri clavier.



2. Nyuma y'akarere k'urupapuro rwerekanwe, duhindura ubugari bw'inkingi n'uburebure bw'imigozi imwe ku bunini bumwe kuri algorithm imwe yasobanuwe igihe yakoresheje uburyo bwa mbere.

Uburyo bwa 3: Gukuramo Imipaka

Byongeye kandi, guhuza ingano ya selile irashobora gukurura intoki imipaka.

1. Turagaragaza urupapuro nkumwenyura cyangwa urwego rwa selile kumurongo wa horizontal uhuza uhuza nuburyo byaganiriweho hejuru. Shyira indanga kumupaka winkingi kuri panel ihuriweho na horizontal. Muri icyo gihe, aho kuba indanga, umusaraba uzagaragara hari imyambi ibiri igamije mu byerekezo bitandukanye. Kuraho buto yimbeba yibumoso hanyuma ukuremo imipaka iburyo cyangwa ibumoso ukurikije niba dukeneye kubigura cyangwa gufunga. Muri iki gihe, ubugari bwahinduwe ku kagari gusa, hamwe n'imbibi uyobora, ariko izindi selile zose zintera yagenewe.

   

   Nyuma yo gukurura no kugabanuka no kurekura buto yimbeba, selile zatoranijwe mubugari zizagira ibipimo bimwe bihuye nubugari bwibyo muri ibyo bikorerwa.



2. Niba utarahisemo urupapuro rwose, noneho utanga selile kumurongo uhagaze neza. Bisa nigika kibanziriza iki, gukurura imipaka imwe mumirongo ifite buto yimbeba yimbeba kugeza selile ziri muri uyu murongo wageze ku burebure bushimishije. Noneho kurekura buto yimbeba.

   

   Nyuma yibi bikorwa, ibintu byose byurwego rwatoranijwe bizagira uburebure bumwe nkugariko wakoresheje.

Uburyo 4: Shyiramo ameza

Niba winjije imbonerahamwe yandukuwe kurupapuro muburyo busanzwe, noneho akenshi inkingi muburyo bwinjijwe izagira ingano zitandukanye. Ariko hariho ikibazo kizarinda.

1. Hitamo imbonerahamwe ushaka gukoporora. Kanda kuri "Gukoporora", biherereye kuri kaseti muri tab ya "Guhana Buffer". Urashobora kandi aho kugirango ibyo bikorwa nyuma yo guhitamo guhamagara CTRL + C Cination kuri clavier.



2. Turagaragaza selile kurupapuro rumwe, kurundi rupapuro cyangwa mubindi bitabo. Aka kagari kagomba kuba ikintu cyo hejuru cyibumoso cyimeza yinjijwe. Kanda iburyo ku kintu cyeguriwe Imana. Ibikubiyemo biragaragara. Muri yo, genda unyuze kuri "kwinjiza bidasanzwe ..." ikintu. Muri menu yinyongera, izagaragara nyuma yibi, kanda, na none, ku kintu hamwe nizina rimwe.



3. Idirishya ryihariye ryinjiza. Muri "shyiramo" igenamiterere, dutondekanya guhinduranya "ubugari bwa coln". Kanda kuri buto ya "OK".



4. Nyuma yibyo, kumpapuro hazabaho selile zinjizamo ubunini hamwe nababaye kumeza yinkomoko.

Nkuko mubibona, muri Excel hari inzira nyinshi zo gushiraho ubunini bwa serure, byombi cyangwa imbonerahamwe yihariye. Ikintu cyingenzi mugihe ukora ubu buryo butanga neza intera, ibipimo ushaka guhindura no kuganisha ku gaciro kamwe. Ibipimo byagatiburo byubutambuka nubugari bwa selile birashobora kugabanywamo ubwoko bubiri: gushiraho agaciro kahariye mumibare igaragazwa mumibare no gukurura imfashanyigisho. Umukoresha ubwayo ahitamo inzira yoroshye, muri algorithm yacyo neza.