Nigute wagabanya Excel Ingano ya dosiye

Iyo ukorera muri Excele, ameza amwe agera kubunini butangaje. Ibi biganisha ku kuba ingano yinyandiko iriyongera, rimwe na rimwe na Megabytes icumi nibindi byinshi. Ubwiyongere bwuburemere bwibitabo Excel buyoboye gusa umwanya wacyo bitwawe na disiki ikomeye, ariko bikarushaho gutinda kwihuta gukora ibikorwa nibikorwa bitandukanye. Muri make, mugihe ukorana ninyandiko nkiyi, gahunda ya Excel itangira gutinda. Kubwibyo, ikibazo cyo kwemeza no kugabanya ibitabo nkibi biba ngombwa. Reka tumenye uburyo bwo kugabanya ingano ya dosiye muri Excele.

Uburyo bwo kugabanya uburyo

Hindura dosiye yavutse igomba guhita ahita mubyerekezo byinshi. Abakoresha benshi ntibazi, ariko akenshi igitabo cya Excel zirimo amakuru menshi adakenewe. Iyo dosiye ari nto kuri ibi, ntamuntu witondera cyane ibi, ariko niba inyandiko yabaye igitonyanga, ni ngombwa kubyutsa ibintu byose bishoboka.

Uburyo 1: Kugabanya intera ikora

Urwego rushinzwe ni agace, ibikorwa nibuka neza. Niba inyandiko iba izaba ingenzi, porogaramu isubiza ingirabuzimafatizo zose zakazi. Ariko ntabwo buri gihe bihuriye nurwego umukoresha akora. Kurugero, icyuho kidakwiye cyo kure kure yimbonerahamwe kizagura ingano yibanze kuri kiriya kintu iyi gare iherereye. Biragaragara ko ari indashyikirwa mugihe usubiramo buri gihe bizakemura agace ka selile zubusa. Reka turebe uko iki kibazo gishobora kuvanwa kurugero rw'ameza runaka.

1. Ubwa mbere, reba uburemere bwayo mbere yo guhitamo, kugereranya nibyo bizaba nyuma yuko inzira irakorwa. Ibi birashobora gukorwa mukwimuka muri tab "dosiye". Jya kuri "Ibisobanuro". Kuruhande rwiburyo bwidirishya ryafunguye imitungo yibanze yigitabo. Imitungo ya mbere nubunini bwinyandiko. Nkuko tubibona, muri iki kibazo ni 56.5 kilobytestes.



2. Mbere ya byose, bigomba kuboneka uko imirimo nyayo itandukanye niyakenewe rwose numukoresha. Biroroshye rwose kubikora. Duhinduka muri selile iyo ari yo yose y'umeza ikandike Ctrl + iherezo ryurufunguzo. Excel ako kanya yimukira muri selile iheruka, porogaramu isuzuma ikintu cya nyuma cyakazi. Nkuko mubibona, byumwihariko, ikibazo cyacu ni umurongo wa 913383. Urebye ko ameza afite imirongo itandatu gusa, birashoboka, mubyukuri, ntabwo ari umutwaro wa dosiye , ariko kubera kwisubiraho burundu porogaramu yose ya porogaramu mugihe ikora igikorwa icyo aricyo cyose kiganisha ku kazi kari ku nyandiko.

   

   Birumvikana, mubyukuri, icyuho kinini kiri hagati yimikorere nyayo nukuri ko Excel yemera ko bidasanzwe, kandi twafashe imirongo myinshi yo gusobanuka. Nubwo, rimwe na rimwe hariho nimanza mugihe ahantu hose hafatwa amababi afatwa nkumukozi.

3. Kugirango ukureho iki kibazo, ugomba gukuraho imirongo yose itangirira kubusa no kugeza imperuka. Kugirango ukore ibi, hitamo selile yambere, ako kanya munsi yameza, hanyuma wandike ctrl + shift + umwambi urufunguzo.



4. Nkuko dushobora kubibona, nyuma yibyo bintu byose bigize inkingi yambere, guhera mu kagari kagenwe no kugeza kumpera yagenewe. Noneho kanda kubirimo buto yimbeba. Mubice bikubiyemo ibikubiyemo, hitamo "Gusiba".

   

   Abakoresha benshi bagerageza gusiba bakanze kuri buto yo gusiba kuri clavier, ariko ntabwo aribyo. Iki gikorwa gikuraho ibikubiye muri selile, ariko ntibikura ubwabo. Kubwibyo, muri iki kibazo rwacu ntiruzafasha.

5. Tumaze guhitamo "Gusiba ..." ikintu kiri muri menu, idirishya rito ryo gukuraho selile rifungura. Nashizeho umwanya wa "umugozi" muri yo hanyuma ukande kuri buto ya OK.



6. Imirongo yose yintera yagenewe yakuweho. Witondere gukama igitabo ukanze kuri floppy mugice cyo hejuru cyibumoso bwidirishya.



7. Noneho reka turebe uko byadufashije. Tugenera selile iyo ari yo yose y'umeza ikandike ctrl + iherezo ryurufunguzo. Nkuko mubibona, Excel yageneye selile yanyuma yimeza, bivuze ko ariho nikintu cya nyuma cyikibabi.



8. Noneho twimukira igice cya "Ibisobanuro" bya "dosiye" kugirango tumenye uburyo uburemere bwinyandiko yacu bwagabanutse. Nkuko mubibona, ubu 32.5 Kb. Ibuka ko mbere yo uburyo bwo kumenya, ingano yacyo yari 56.5 Kb. Rero, yagabanutse inshuro zirenga 1.7. Ariko muriki gihe, ibyagezweho nyamukuru ntabwo no kugabanya uburemere bwa dosiye, kandi ko gahunda isonewe kugirango ikureho intera idakoreshwa mubyukuri, izakongeraho cyane igipimo cyo gutunganya inyandiko.

Niba mugitabo cy'amabati menshi ukorana, ugomba kuyobora inzira isa na buri kimwe muri byo. Ibi bizakomeza kugabanya ingano yinyandiko.

Uburyo 2: Kurandura imiterere yo kurenga

Ikindi kintu cyingenzi gituma inyandiko zidasanzwe zifite kiremere, ni ugukamagana. Ibi birimo gukoresha ubwoko butandukanye bwimyandikire, imipaka, imiterere yimibare, ariko mbere ya byose bireba gusuka selile mumabara atandukanye. Mbere rero komeza imiterere ya dosiye, ugomba gutekereza kabiri, kandi niba ari ngombwa kubikora cyangwa udafite ubu buryo byoroshye gukora.

Ibi ni ukuri cyane cyane kubitabo birimo amakuru menshi ubwayo ubwayo ko asanzwe afite ubunini butari bunini. Ongeraho imiterere mubitabo birashobora kongera uburemere bwayo inshuro nyinshi. Kubwibyo, ugomba guhitamo hagati ya "Zahabu" hagati yo kugaragara yo gutanga amakuru mubyangombwa nubunini bwa dosiye, kugirango ukoreshe imiterere gusa aho ari ngombwa rwose.

Ikindi kintu kijyanye no gutunganya, uburemere buremere, nuko abakoresha bamwe bahitamo gukora selile "hamwe na margin." Ni ukuvuga, ntabwo ari uguhindura ameza ubwayo, ahubwo ni urwego ruri munsi yacyo, rimwe na rimwe kugeza imperuka yurupapuro, hamwe no kubara neza ko iyo imirongo mishya yongerewe kumeza, ntabwo izaba ngombwa kugirango ubeho buri gihe.

Ariko ntabwo bizwi mugihe imirongo mishya izongerwaho kandi ni bangahe uzabayongereye, kandi imiterere ibanza ufata dosiye isanzwe kuri ubu, izagira ingaruka mbi kandi ku muvuduko wo gukorana niyi nyandiko. Kubwibyo, niba ufite gahunda yo gukoresha selile zubusa zitashyizwe mumeza, igomba kuvaho.

1. Mbere ya byose, ugomba kwerekana selile zose ziherereye munsi yumurongo hamwe namakuru. Kugirango ukore ibi, kanda kumubare wambere wumurongo wubusa kumurongo uhagaze uhagaze. Yageneye umurongo wose. Nyuma yibyo, dukoresha uburyo bumaze kumenyera guhuza urufunguzo rushyushye Ctrl + hindura hasi hasi.



2. Nyuma yibyo, umurongo wose uri munsi yigice cyimbonerahamwe yuzuyemo amakuru, kanguka. Kuba muri tab "urugo", kanda kuri "Sobane", iherereye kuri kaseti murwego rwo guhindura. Menu ntoya irakinguye. Hitamo "imiterere isobanutse" muri yo.



3. Nyuma yiki gikorwa mu tugari twose k'urutonde rwatanzwe, imiterere izasibwa.



4. Muri ubwo buryo, urashobora gukuraho uburyo budakenewe mumeza ubwayo. Kugirango ukore ibi, hitamo selile cyangwa urwego rwihariye dusuzuma uburyo buke bwingirakamaro, kanda kuri buto "isobanutse" kuri kaseti hanyuma uhitemo "imiterere isobanutse" kurutonde.



5. Nkuko mubibona, gushiraho muburyo bwatoranijwe bwatoranijwe bwakuweho rwose.



6. Nyuma yibyo, turasubiza iyi miterere yibintu dusuzuma bifite akamaro: Imipaka, imiterere yumubare, nibindi.

Ibikorwa byasobanuwe haruguru bizafasha kugabanya cyane ubunini bwibitabo byihariye kandi bihutisha akazi muri yo. Ariko nibyiza kubanza gukoresha imiterere gusa aho byukuri bikwiriye kandi bikenewe kuruta kumara umwanya wo gutegura inyandiko.

Isomo: Gukoresha imbonerahamwe muri excel

Uburyo 3: Kuraho amahuza

Mubyangorero bimwe, umubare munini cyane uhuza aho indangagaciro ziruweho. Ibi birashobora kandi gutinda cyane umuvuduko wakazi muri bo. By'umwihariko bitwarwa cyane no hanze yibanze kubindi bitabo, nubwo ibyingenzi byimbere nabyo bigaragarira nabi mubikorwa. Niba inkomoko iva aho umurongo usaba amakuru ntabwo uhora ivugururwa, ni ukuvuga ibisobanuro byo gusimbuza aderesi muri selile kubintu bisanzwe. Ibi birashobora kongera umuvuduko wo gukorana ninyandiko. Ihuza cyangwa agaciro biri mu kagari gasanzwe, muri formula kumurongo nyuma yo guhitamo ikintu.

1. Hitamo agace karimo amakuru. Kuba muri tab ya mu rugo, kanda kuri buto "kopi" iherereye kuri kaseti mu itsinda rya clipboard.

   

   Ubundi, nyuma yo guhitamo intera, urashobora gukoresha guhuza urufunguzo rushyushye Ctrl + C.

2. Nyuma yamakuru yandukuye, ntukureho guhitamo muri kariya gace, hanyuma ukande kuri buto yimbeba iburyo. Ibikubiyemo byatangijwe. Muri yo, muri "shyiramo igenamiterere", ugomba gukanda kuri "indangagaciro". Ifite icyerekezo cya pictogramu n'imibare igaragara.



3. Nyuma yibyo, ingingo zose mubice byitabye Imana izasimburwa nindangagaciro zibarurishamibare.

Ariko ugomba kwibuka ko ubu buryo bwo guhitamo igitabo Excel ntabwo buri gihe bwemewe. Irashobora gukoreshwa gusa mugihe amakuru avuye mu isoko yumwimerere ntabwo afite imbaraga, ni ukuvuga ko batazahinduka igihe.

Uburyo 4: Imiterere irahinduka

Ubundi buryo bwo kugabanya cyane ingano ya dosiye ni uguhindura imiterere. Ubu buryo, birashoboka, ibyinshi muri byose bifasha gukanda igitabo, nubwo kandi birakenewe kandi gukoresha amahitamo yavuzwe haruguru muri complex.

Muri Excel hari "kavukire" nyinshi - XLS, XLSX, XLSM, XLSB. Imiterere ya XLS yari iyabukwa ryibanze kuri porogaramu ya Excel 2003 na mbere yaho. Amaze kubitagenda, ariko, nyamara, abakoresha benshi baracyakomeza gukurikizwa. Byongeye kandi, hari ibibazo mugihe ugomba gusubira kukazi hamwe namadosiye ashaje yakozwe mumyaka myinshi ishize nubwo kubura imiterere igezweho. Tutibagiwe nuko porogaramu nyinshi zabasirikare zabatonye zikorana nibitabo hamwe niki cyagutse, itazi gutunganya amahitamo ya Excel.

Twabibutsa ko igitabo cyo kwagura XLS gifite ubunini bunini kuruta kuri antalogue iriho yuburyo bwa XlsX, iki gihe kuri iki gihe gikwiye gukoresha nkiyi nkuru. Mbere ya byose, ibi biterwa nuko XLSX dosiye zijyanye nububiko. Kubwibyo, niba ukoresha kwagura XLS, ariko urashaka kugabanya uburemere bwigitabo, noneho ibi birashobora gukorwa kubihagarika muburyo bwa XlSX.

1. Guhindura inyandiko kuva kumurongo wa Xls kumiterere ya XlSX, jya kuri dosiye.



2. Mu idirishya rifungura, mpita kwitondera igice "ibisobanuro", aho byerekanwe ko kuri ubu uburemere bw'inyandiko ari 40 KB. Ibikurikira, kanda ku izina "Kubika nka ...".



3. Idirishya rikize. Niba ubishaka, urashobora kujya mububiko bushya, ariko abakoresha benshi biroroshye kubika inyandiko nshya ahantu hamwe kode yinkomoko. Izina ryigitabo, niba ryifuzwa, rishobora guhinduka mumwanya wa "Izina", nubwo ridakenewe. Ikintu cyingenzi muri ubu buryo ni ugushiraho umurima wa "Ubwoko bwa dosiye" "Excel (.xlsx)" igitabo. Nyuma yibyo, urashobora gukanda buto "OK" hepfo yidirishya.



4. Nyuma yo kuzigama bikozwe, jya kuri "Ibisobanuro" birambuye kuri File tab kugirango urebe uburemere bwagabanutse. Nkuko mubibona, ubu ni 13.5 kbytes kurwanya kbytes 40 mbere yuburyo bwo guhindura. Ni ukuvuga, kuzigama gusa muburyo bugezweho byatumye bishoboka gukanda igitabo hafi inshuro eshatu.

Mubyongeyeho, hariho ubundi buryo bwa Xlsb bugezweho cyangwa igitabo cya binary. Muri yo, inyandiko yakijijwe muri binary presding. Aya madosiye apima karenze ibitabo muburyo bwa XlSX. Byongeye kandi, ururimi rwanditswe hafi ya gahunda ya Excel. Kubwibyo, ikorana nibitabo nkibi byihuse kuruta ubundi buryo bwose. Mugihe kimwe, igitabo cyimiterere yihariye ku mikorere nibishoboka byo gukoresha ibikoresho bitandukanye (imiterere, imikorere, ibishushanyo, ibishushanyo, nibindi) ntibirenze imiterere ya xlsx.

Impamvu nyamukuru yatumye Xlsb idahindutse imiterere isanzwe muri Excel niyo gahunda yabantu ya mbere ishobora gukorana nayo. Kurugero, niba ukeneye kohereza amakuru yohereza kuri porogaramu ya 1C, birashobora gukorwa hamwe na XLSX cyangwa XLLS, ariko ntabwo hamwe na XLSB. Ariko, niba udateganya kwimura amakuru kuri gahunda ya gatatu yishyaka, urashobora kubika neza inyandiko muburyo bwa XLSB. Ibi bizagufasha kugabanya ingano yinyandiko no kongera umuvuduko wakazi muri yo.

Uburyo bwo kuzigama dosiye muri Xlsb Kwagura XLSB bisa nabyo twakozwe kugirango twagure xlsx. Muri tab "dosiye", kanda kuri "Kubika nka ...". Mu idirishya rikiza rifungura umurima wa "Ubwoko bwa dosiye", ugomba guhitamo amahitamo "Exced Igitabo (* .xlsb)". Noneho kanda kuri buto "Kubika".

Turareba uburemere bwinyandiko muri "Ibisobanuro". Nkuko mubibona, byaragabanutse nibindi byinshi kandi ubu ni 11.6 Kb gusa.

Vuga ibisubizo rusange, dushobora kuvuga ko niba ukorana na dosiye ya XLS, noneho inzira nziza yo kugabanya ingano yacyo ni ingufu muri xlsb format ya none cyangwa Xlsb. Niba umaze gukoresha amakuru yo kwagura dosiye, hanyuma ugabanye ibiro byabo, ugomba kubagena neza aho ukorera, kura imikoranire irenze kandi bitari ngombwa. Uzakira kugaruka cyane niba utanze ibyo bikorwa byose muri complex, kandi ntugarukire kubihitamo kimwe.