Excel: Imiterere myinshi itandukanye

Kimwe mu bibazo abakoresha bahurira mugihe bakorana nameza muri Microsoft Excel, ni ikosa "imiterere myinshi ya selire zitandukanye". Birasanzwe cyane mugihe ukorana nameza hamwe na XLS kwagura. Reka tubimenye neza muriki kibazo tumenye uburyo bushobora kuvaho.

Noneho inyandiko izakizwa hamwe no kwagura XlSX, izagufasha gukorana ninshuro nyinshi inshuro icyarimwe kurenza uko byari bimeze iyo ukorana na dosiye ya XLS. Mubwinshi bwibintu byinshi, ubu buryo bwemerera gukuraho ikosa twize.

Uburyo 2: Gusukura imiterere mumirongo yubusa

Ariko biracyahari mugihe uyikoresha akora neza hamwe no kwagura Xlsx, ariko biracyaboneka iri kosa. Ibi biterwa nuko iyo ukorana ninyandiko, imipaka yimiterere 64.000 yarenze. Byongeye kandi, kubwimpamvu zimwe, ikibazo gishoboka mugihe ukeneye kubika dosiye hamwe no kwagura xls, kandi ntabwo XlSX, kuva hamwe nuwambere, kurugero, ushobora gukora gahunda zindito. Muri ibi bihe, ugomba gushakisha ubundi buryo bwo kuva mubihe byubu.

Akenshi, abakoresha benshi bahindura umwanya munsi yameza hamwe na margin kugirango ejo hazaza hatagihe bitakaza umwanya kuri ubu buryo mugihe habaye imbonerahamwe kwaguka. Ariko ubu ni bwo buryo butari bwo. Kubera iyo mpamvu, ingano ya dosiye yiyongereye cyane, ikorana nayo iratinda, byongeye, ibikorwa nkibi birashobora kuvamo ikosa tuganira muri iyi ngingo. Kubwibyo, kuva kurenga nkibi bigomba kuvaho.

1. Mbere ya byose, dukeneye kwerekana agace kose kari munsi yimbonerahamwe, guhera ku mugozi wa mbere aho nta makuru. Kugirango ukore ibi, kanda buto yimbeba yibumoso kumazina yumubare wuyu mugozi kumurongo uhagaritse. Yagenewe umurongo wose. Koresha kanda kuri buto ya CTRL + shift + hepfo umwambi. Yageneye urutonde rwose rwinyandiko iri munsi yameza.



2. Noneho twimukira kuri tab "urugo" tukakanda kuri "Sobane" igishushanyo, kirimo muburyo bwibikoresho byo guhindura. Urutonde rukinguye aho uhitamo "imiterere isobanutse".



3. Nyuma yibi bikorwa, intera yeguriwe izasukurwa.

Mu buryo nk'ubwo, birashoboka gusukura muri selile iburyo bw'ameza.

1. Ibumba ku izina rya mbere ntabwo ryuzuyemo inkingi muri panel ihuriweho. Byerekanwe kuri Niza ubwe. Noneho tubyara igice cya Ctrl + shift + umwambi buto iburyo. Ibi byerekana urwego rwose rwinyandiko, iherereye iburyo bwameza.



2. Noneho, nkuko bimeze mu rubanza rwabanje, tugacamo "igishushanyo" kisobanutse ", no muri menu yamanutse, hitamo Ihitamo" Imyandikire isobanutse ".



3. Nyuma yibyo, isuku izasukurwa mu tugari twose kugeza iburyo bw'ameza.

Uburyo busa mugihe habaye ikosa, tuvuga iri somo, ntabwo rizaba ryiboneye mbere bisa nkaho bihuriye na ameza muri rusange. Ikigaragara ni uko bashobora kuba bafite imiterere "yihishe". Kurugero, inyandiko cyangwa imibare mu kagari ntibishobora kuba, ariko ifite imiterere itandukanye, nibindi. Kubwibyo, ntukabe umunebwe, mugihe habaye ikosa, kugirango usohoze ubu buryo no hejuru yitsinda ryubusa. Ntukeneye kandi kwibagirwa ibishoboka byose byihishe.

Uburyo bwa 3: Gusiba imiterere imbere kumeza

Niba verisiyo ibanza idafasha gukemura ikibazo, noneho birakwiye ko witondera uburyo bukabije mumeza ubwayo. Abakoresha bamwe bakora imitunganyirize mumeza n'ahantu bitareba amakuru yinyongera. Batekereza ko bakora imbonerahamwe nziza cyane, ariko mubyukuri, kenshi, igishushanyo nkiki kirasa neza. Ndetse birushijeho kuba bibi niba ibintu byagenwe biganisha kuri feri ya gahunda cyangwa ikosa dusobanura. Muri iki kibazo, bigomba gusigara kumeza imiterere gusa.

1. Muri izo rurimi rukora uburyo bushobora kuvaho burundu, kandi ibi ntibizagira ingaruka ku makuru ameza, dukora inzira dukurikije algorithm imwe, yasobanuwe muburyo bwambere. Icya mbere, tugaragaza intera iri kumeza aho isuku igomba gusukurwa. Niba ameza ari nini cyane, noneho ubu buryo buzoroherwa gukora, ukoresheje ububiko bwa CTRL + Shift + umwambi Buttons iburyo (ibumoso, hepfo). Niba uhisemo selire imbere yimeza, hanyuma ukoreshe izo mfunguzo, guhitamo bizashyirwaho imbere, kandi bitakorerwa imbere yurupapuro, nkuko muburyo bwabanje.

   Twakanze ku rimenyerewe kuri twe "isobanutse" muri tab ya mu rugo. Murutonde rutonyanga, hitamo Ihitamo "Imyandikire isobanutse".



2. Urwego rwerekanwe rwameza ruzasukurwa rwose.



3. Gusa ikintu gikeneye gukorwa nugushyiraho imipaka muri parike isukuye niba zihari ahasigaye array.

Ariko kubice bimwe byameza, ubu buryo ntibukwiye. Kurugero, muburyo bwihariye urashobora gukuraho ibyuzuye, ariko imiterere itariki igomba gusigara, bitabaye ibyo amakuru azerekanwa nabi, imipaka nibindi bimwe. Inyandiko imwe yibikorwa twavuze haruguru, ikuraho burundu imiterere.

Ariko hariho inzira kandi muriki gihe, ariko, irakora cyane. Mu bihe nk'ibi, umukoresha agomba gutanga buri nkomoko ya quarnoseus yahinduwe kandi ikuraho intoki aho ushobora gukora.

Birumvikana ko ari isomo rirerire kandi ritoroshye, niba ameza ari nini cyane. Kubwibyo, nibyiza rwose mugihe cyo gushushanya inyandiko kudakoresha nabi "heza" kugirango bidafite ibibazo bizagomba kumara umwanya munini.

Uburyo 4: Gukuraho Imiterere

Imiterere yibanze nigikoresho cyoroshye cyo kwiyumvisha amakuru, ariko gusaba kwayo bikabije birashobora kandi gutera ikosa twize. Kubwibyo, ugomba kureba urutonde rwamategeko ateganijwe akoreshwa kururu rupapuro, hanyuma ukureho umwanya muriyo, usibye ibyo ushobora gukora.

1. Iherereye muri tab "urugo", ibumba kuri buto "bisabwa", riherereye mu ruganda "Styles". Muri menu izafungura nyuma yiki gikorwa, hitamo "Amategeko yubuyobozi".



2. Gukurikiza ibi, idirishya gucunga amategeko ryatangijwe, rikubiyemo urutonde rwibintu bifatika.



3. Mburabuzi, gusa ibintu byo guhitamo igice giherereye kurutonde. Kugirango werekane amategeko yose kurupapuro, ongera utegure switch mu mategeko "yerekana uburyo bwo" "uru rupapuro". Nyuma yibyo, amategeko yose yurupapuro ruzerekanwa.



4. Noneho tugenera amategeko tutariyo, hanyuma ukande kuri buto "Gusiba Amategeko.



5. Muri ubu buryo, dukuraho ayo mategeko tutagira uruhare runini mu myumvire yagaragara. Nyuma yuburyo burangiye, kanda buto ya "OK" hepfo y amategeko ashinzwe idirishya.

Niba ukeneye gukuraho burundu imiterere yimiterere itandukanye, noneho biroroshye kubikora.

1. Turagaragaza urwego rwa selile duteganya gukuraho.



2. Kanda kuri "Imiterere itondekanya" muburyo bwa "styles" muri tab ya tab murugo. Kurutonde rugaragara, hitamo "Gusiba Amategeko". Ibikurikira, urundi rutonde rufungura. Muri yo, hitamo "Siba amategeko ava muri selile zatoranijwe".



3. Nyuma yibyo, amategeko yose mu ntangiriro azasibwa.

Niba ushaka gukuraho burundu imiterere ifatika, hanyuma murutonde rwanyuma rwa menu ukeneye guhitamo amahitamo "Gusiba amategeko kuva hejuru yurupapuro".

Uburyo 5: Gusiba imisumico

Byongeye kandi, iki kibazo gishobora kuvuka kubera gukoresha umubare munini wimiterere mibi. Byongeye kandi, barashobora kugaragara nkibisubizo byo gutumiza cyangwa gukoporora mubindi bitabo.

1. Iki kibazo cyakuweho kuburyo bukurikira. Jya kuri tab "urugo". Kuri kaseti muri "Style" guhagarika ibikoresho kanda kumatsinda "muburyo bwa selile".



2. Fungura stre stre. Hariho uburyo butandukanye bwibishushanyo mbonera bya selile, mubyukuri, bikosorwa byimiterere myinshi. Hejuru yurutonde hari "gakondo". Gusa iyi miterere ntabwo yubatswe mbere, ariko nibicuruzwa byibicuruzwa. Niba habaye ikosa, kurandura twiga birasabwa kubisiba.



3. Ikibazo nuko nta gikoresho cyubatswe gikubiyemo uburyo bwo gukuraho imbaga, kugirango buriwese agomba gusiba ukundi. Tuzana indanga muburyo bwihariye buva mu itsinda rya "Custope". Ndabasinda kuri buto yimbeba iburyo no muri menu, hitamo Ihitamo "Gusiba ...".



4. Dusiba muri ubu buryo buri buryo buturuka kuri "gakondo" kugeza ubwo bwubatswe muburyo bwubatswe gusa.

Uburyo 6: Gusiba imiterere yihariye

Uburyo busa cyane bwo gukuraho imisumiro ni ugusiba imiterere yihariye. Ni ukuvuga, tuzasiba ibyo bintu bitari ukubarwa muri excel, ariko byashyizwe mubikorwa numukoresha, cyangwa byubatswe muri inyandiko mubundi buryo.

1. Mbere ya byose, tuzakenera gufungura idirishya. Inzira isanzwe yo gukora ni ugukanda iburyo-umwanya uwo ariwo wose mumyandiko kandi uhereye kuri menu ya contation kugirango uhitemo ihitamo "imiterere ngenda.".

   

   Urashobora kandi, mugihe muri tab "murugo", kanda buto ya "format" muri kaseti "selile" kuri kaseti. Muri menu ikora, hitamo ikintu "imiterere ingirabuzimafatizo ...".

   

   Ubundi buryo bwo guhamagara idirishya ukeneye ni urutonde rwa Ctrl + 1 urufunguzo kuri clavier.

2. Nyuma yo gukora ibikorwa byose byasobanuwe haruguru, idirishya rizatangira. Jya kuri tab "umubare". Muri "Imiterere ya" numero yimibare ", dushyiraho ugana kumwanya" (imiterere yose) ". Kuruhande rwiburyo bwiyi idirishya, umurima uherereyemo hari urutonde rwubwoko bwose bwibintu bikoreshwa muriyi nyandiko.

   Turagaragaza indanga buri. Jya ku izina rikurikira byoroshye hamwe na "Hasi" kuri clavier mu gice cyo kugenda. Niba ikintu cyubatswe, noneho "Gusiba" bitagomba kudakora.



3. Mugihe ikimara kongeweho umukoresha cyerekanwe, "Gusiba" bizogira gukora. Kanda kuri. Muri ubwo buryo, siba amazina yose yo gutunganya neza kurutonde.



4. Nyuma yo kurangiza inzira, tugomba gukanda buto "OK" hepfo yidirishya.

Uburyo 7: Kuraho impapuro zidakenewe

Twasobanuye ibikorwa kugirango dukemure ikibazo murwego rumwe gusa. Ariko ntiwibagirwe ko kimwe cya manipune imwe ikeneye gukorwa nikindi gitabo cyose cyuzuyemo iyi mpapuro.

Mubyongeyeho, impapuro cyangwa impapuro zidakenewe, aho amakuru yigana, nibyiza gusiba na gato. Byakozwe byoroshye.

1. Mugukanda buto yimbeba iburyo kurupapuro rugufi, rugomba gukurwaho hejuru yumurongo. Ibikurikira, muri menu igaragara, hitamo "Gusiba ...".



2. Nyuma yibyo, agasanduku k'ibiganiro gikinguye bisaba kwemeza gukuraho shortcut. Kanda muri yo kuri buto "Gusiba".



3. Gukurikira ibi, ikirango cyatoranijwe kizakurwa mu nyandiko, bityo rero, imikoranire yose kuri yo.

Niba ukeneye kuvanaho ibintu byinshi biherereye, hanyuma ukande kumanywa ya mbere hamwe na buto yimbeba yibumoso, hanyuma ukande kumwanya wanyuma, ariko mugihe kimwe gusa ufashe urufunguzo rwa Shift. Ibirango byose biherereye hagati yibi bintu bizagaragazwa. Ibikurikira, inzira yo gukuraho irakorwa kuri algorithm imwe yasobanuwe haruguru.

Ariko hariho kandi impapuro zihishe, kandi birashobora kuba umubare munini wibintu bitandukanye. Gukuraho imiterere irenze kuri iyi mpapuro cyangwa kuyisiba na gato, ugomba guhita ugaragaza ibirango.

1. Kanda kuri label iyo ari yo yose no muri menu, hitamo ikintu "cyerekana".



2. Urutonde rwimpapuro zihishe zifungura. Hitamo izina ryurupapuro rwihishe hanyuma ukande kuri buto "OK". Nyuma yibyo, bizerekanwa kumwanya.

Igikorwa nkiki cyakozwe hamwe nimpapuro zose zihishe. Noneho turareba icyo gukorana nabo: Gukuraho rwose cyangwa gusukura imiterere myinshi niba amakuru ari ngombwa kuri bo.

Ariko usibye ibi, hari kandi ibyitwa impapuro zikikijwe na super-zikikijwe, kurutonde rwabanjirije impapuro zihishe utabibona. Bashobora kuboneka no kwerekana kumwanya banyuze muri editor ya Vba.

1. Kugirango utangire umwanditsi wa VBA (Macro Muhinduzi), kanda ihuza urufunguzo rushyushye Alt + F11. Muri "umushinga", tugenera izina ryurupapuro. Hano barerekanwa nkimpapuro zisanzwe zigaragara, zihishe kandi zidasanzwe. Muburyo bwo hasi "imitungo" Turareba agaciro ka "Biboneka". Niba hashyizweho kuri "2-xlsHeeveryherveryryshenveryryshenveryry, noneho uru ni urupapuro rwubusa.



2. Kanda kuri iyi parameter no kurutonde rufungura, hitamo izina "-1-Xlsheetvisible". Noneho kanda ukurikije buto isanzwe yo gusoza.

Nyuma yiki gikorwa, urupapuro rwatoranijwe ruzareka kurengerwa kandi ikirango kizerekanwa kumwanya. Ibikurikira, bizashoboka kuyobora inzira yo gukora isuku cyangwa gusiba.

Isomo: Niki gukora niba impapuro zabuze muri excel

Nkuko mubibona, uburyo bwihuse kandi bunoze buzakuraho ikosa ryize muri iri somo - ni ugukiza dosiye hamwe na XLSX kwaguka. Ariko niba iyi nzira idakora cyangwa kubwimpamvu ikwiye, bityo inzira zisigaye zo gukemura ikibazo zisaba umwanya n'imbaraga nyinshi. Byongeye kandi, bose bagomba gukoreshwa muri complex. Kubwibyo, nibyiza mugikorwa cyo gukora inyandiko ntabwo ari ugukoresha nabi imiterere yo kumurika kugirango rero bitagomba gukoresha imbaraga zo gukuraho ikosa.