Uburyo bwo guhuza selile muri excel

Kenshi na kenshi, mugihe ukorana nameza muri gahunda ya Microsoftl Excel, ibintu bibaho mugihe ukeneye guhuza selile nyinshi. Igikorwa ntabwo kigoye cyane niba iyi selile zidafite amakuru. Ariko icyo gukora niba amakuru amaze gukorwa muri bo? Bizarimburwa? Reka tumenye uburyo bwo guhuza ingirabuzimafatizo, harimo nta gutakaza ibirimo, muri Microsoft Excel.

Guhuza selile muri excel

Reba ishyirahamwe muburyo bwose aho ingirangingo zizakira amakuru. Niba imyanya ibiri yegeranye yo guhuza ibizaza afite amakuru atandukanye, arashobora gukizwa muribihe byombi - kubwibi, pakeki y'ibiro itanga imirimo idasanzwe yaganiriweho. Ihuriro rishobora gukenerwa gusa kugirango dukore amakuru gusa muri selire ebyiri muri imwe, ariko kandi, kurugero, kugirango dukore ingofero kubintu byinshi.

Uburyo 1: Ishyirahamwe ryoroshye

Inzira yoroshye yo guhuza selile nyinshi ni ugukoresha buto yatanzwe muri menu.

1. Bikurikiranye hitamo buto yimbeba yibumoso kugirango uhuze. Irashobora kurongora, inkingi cyangwa amahitamo yo guhuza. Muburyo bwafashwe, dukoresha umurongo uhuza.



2. Jya kuri tab "urugo".



3. Shakisha hanyuma ukande kumyambi yibikubiyemo bya menu yibuka, aho hari amahitamo menshi ashoboka, muri bo bahitamo koroshya - umugozi ".



4. Muri iki gihe, selile ihujwe, kandi amakuru yose azahuza na selile yashyizwe hamwe izaguma ahantu hamwe.



5. Kugirango uhindure inyandiko nyuma yo guhuza ikigo, ugomba guhitamo ikintu "guhuza no guhuza hagati". Nyuma y'ibikorwa byakozwe, ibirimo birashobora guhuzwa muburyo bwawe ukoresheje ibikoresho bikwiye.



6. Kugirango utazahuze numurongo munini ukwabo, koresha "ishyirahamwe ryimbere".

Uburyo 2: Hindura imitungo

Birashoboka guhuza selile zinyuze muri menu. Igisubizo cyabonetse kuburyo kidatandukanye nuwambere, ariko umuntu arashobora korohereza gukoresha.

1. Shyira ahagaragara indanga muri selile, ugomba guhuzwa, kanda kuri IT Kanda neza, kandi mubikubiyemo bigaragara, hitamo "imiterere yimodoka".



2. Muburyo bwa selire idirishya rifungura, jya kuri tab yo guhuza. Twizihiza agasanduku k'igenzura "Ishyirahamwe ry'Akagari". Ako kanya, ibindi bipimo birashobora gushyirwaho: icyerekezo nicyerekezo cyanditse, urwego rutambitse kandi ruhagaritse, ubugari, ubugari bwamagambo. Iyo igenamiterere ryose rikozwe, kanda kuri buto "OK".



3. Nkuko mubibona, ishyirahamwe rya selile ryabaye.

Uburyo 3: Ubumwe nta gihombo

Niki ugomba gukora niba hari amakuru muri selile nyinshi zahujwe, kuko iyo uhuye nimpanga zose zitari hejuru yo hejuru izabura? Muri iki gihe, amakuru akenewe ava muri selire imwe kugirango akureho kuri selile ya kabiri, kandi ayare umwanya mushya rwose. Hamwe nibi, ikimenyetso cyihariye cya "&" cyitwa "amahugurwa") cyangwa formula "gufata (eng. Contrat)" irashobora kwihanganira ibi.

Reka dutangire hamwe nuburyo bworoshye. Icyo ukeneye gukora nukugaragaza inzira igana ingirabuzimafatizo zahujwe muri selile nshya, hanyuma ushiremo ikimenyetso cyihariye hagati yabo. Reka duhuze selile eshatu icyarimwe muri imwe, bityo dukora umurongo winyandiko.

1. Hitamo akagari wifuza kubona ibisubizo byubumwe. Muri yo, andika ikimenyetso cyuburinganire "=" kandi bikurikiranye hitamo imyanya yihariye cyangwa urutonde rwose rwamakuru yo guhuza. Hagati ya buri selile cyangwa intera igomba kuba ikimenyetso cyamasomo "&". Mu rugero runaka, duhuza selile "A1", "B1", "muri imwe -" D1 ". Nyuma yo kwinjira mubikorwa, kanda "Enter".



2. Bitewe nibikorwa byabanjirije muri kasho hamwe na formula, imyanya itatu yose yahujwe muri imwe.



3. Kugirango inyandiko irangire, urashobora kongeramo umwanya hagati ya selile. Muri formulat iyo ari yo yose, kugirango wongere ibintu hagati yamakuru, ugomba kwinjiza umwanya mumutwe. Kubwibyo, shyira hagati ya "A1", "B1" na "C1" muri ubu buryo: "= A1 &" & B1 & "& C1".



4. Fortala yerekana kubyerekeye ihame rimwe - Ingirabuzimafatizo zagenwe cyangwa iringaniza zizahuzwa mumwanya uhimbye imikorere "= gufata ()". Urebye urugero rw'abashaka, kubisimbuza ku bikorwa byavuzwe: "= gufata (A1;";; "; C1; Nyamuneka menya ko umwanya uhita wongeyeho kugirango worohereze. Muri formula, umwanya ufatwa nkumwanya wihariye, ni ukuvuga, twongeyeho umwanya kuri selile ya A1, hanyuma selile ya B1 nibindi.



5. Niba ukeneye gukuraho amakuru yinkomoko yakoreshejwe muguhuza, gusiga ibisubizo gusa, urashobora kwigana amakuru atunganijwe nkagaciro hanyuma ukureho inkingi zinyongera. Kugirango ukore ibi, wandukure agaciro karangiye muri "CTRL + CUGARUKA" CTRL + C ", kanda iburyo kuri selile yubusa hanyuma uhitemo" indangagaciro ".



6. Nkigisubizo - ibisubizo bisukuye nta formulaire muri selire. Noneho urashobora gusiba amakuru yabanjirije byoroheye.

Niba selile isanzwe ihuza gahunda ya Microsoft Excel Byoroshye, noneho hamwe nishyirahamwe rya selile nta gihombo rigomba kumvikana. Nubwo bimeze bityo ariko, ibi nabyo bikorwa nibikorwa kuri gahunda yubu. Gukoresha ibiranga hamwe ninyuguti zidasanzwe zizarokora umwanya munini mugutunganya amakuru menshi.