Umubare wikora wimirongo muri excel. Inzira 3 zo Kugena Umubare wikora wa Rows muri Excel

Iyo ukorana nimeza, umubare urashobora gukenerwa. Icyuma, kigufasha kugenda vuba kandi ushakishe amakuru akenewe. Mu ntangiriro, gahunda isanzwe ifite umubare, ariko irahagaze kandi ntishobora guhinduka. Itekereza gufata intoki umubare woroshye, ariko ntabwo wizewe, biragoye gukoresha mugihe ukorana nimbonerahamwe nini. Kubwibyo, muriyi bikoresho tuzareba uburyo butatu kandi bworoshye-gukoresha uburyo bwo gukoresha imbonerahamwe kuri excel.

Uburyo 1: Kubara nyuma yo kuzuza umurongo wambere

Ubu buryo nuburyo bworoshye kandi bukoreshwa cyane mugihe bakorana nameza mito n'abiciriritse. Bifata igihe ntarengwa kandi byemeza usibye amakosa yose ari kumwe. Intambwe ya By-Intambwe Basa nkibi:

1. Ubwa mbere ushaka gukora inkingi itemewe kumeza izagenewe kurushaho kubarirwa.
2. Inkingi ikimara iremwa, kumurongo wambere, shyira numero 1 mubwa kabiri, no kumurongo wa kabiri, shyira imibare 2.

Kora inkingi hanyuma wuzuze selile

1. Hitamo selile ebyiri zuzuye kandi uzengurutswe hejuru yiburyo bwiburyo bwatoranijwe.
2. Mugihe igishushanyo cyambukiranya umukara kigaragara, fata LKM hanyuma uhembe ahantu kugeza kumeza.

Kurambura umubare kumurongo wose

Niba ibintu byose bikozwe neza, inkingi yo gushiramo izahita yuzura. Ibi bizaba bihagije kugirango tugere kubisubizo byifuzwa.

Ibisubizo byakazi byakozwe

Uburyo 2: Umukoresha

Noneho tujya mubukoresha bukurikira bwo kubara, bisobanura gukoresha imikorere idasanzwe "umugozi" wihariye:

1. Ubwa mbere, ugomba gukora inkingi kumibare, niba ntawe uhari.
2. Mu ruhererekane rwa mbere rwiyi nkingi, andika formula yibi bikurikira: = umurongo (a1).

Tumenyekanisha formula mu Kagari

1. Nyuma yo kwinjira kuri formula, menya neza kanda urufunguzo rwa "Enter", ukora umurimo, uzabona igishusho 1.

Uzuza selile hanyuma urambure umubare

1. Noneho birasa nuburyo bwa mbere bwo kuzana indanga iburyo bwiburyo bwatoranijwe, tegereza umusaraba wumukara hanyuma urambura aho ameza yawe.
2. Niba ibintu byose bikozwe neza, inkingi izuzura umubare kandi irashobora gukoreshwa mugushakisha amakuru.

Tugereranya ibisubizo

Hariho ubundi buryo, hiyongereyeho uburyo bwerekanwe. Nukuri, bizaba ngombwa gukoresha "Inshingano Yingenzi" Module:

1. Mu buryo nk'ubwo, kora inkingi yo gushiramo.
2. Kanda kuri selire yambere yumurongo wambere.
3. Kuva hejuru hafi yumurongo wishakisha kanda ahanditse "FX".

Kora "Master of Imikorere"

1. "Imikorere Master" ikora, aho ukeneye gukanda amanota "icyiciro" hanyuma uhitemo "amahuza na arrays".

Hitamo ibice bikenewe

1. Kuva mubikorwa byateganijwe, uzahitamo uburyo "umurongo".

Koresha imikorere "umugozi"

1. Idirishya ryibindi rizagaragara kugirango winjire amakuru. Ugomba gushyira indanga kuri "Reba" hamwe no kwerekana aderesi ya selile yambere yinkingi (muri iki kibazo ni A1).

Kuzuza amakuru asabwa

1. Ndashimira ibikorwa byakozwe muri selile ya mbere yubusa, imibare igaragara. 1. Birakomeje gukoresha inguni yo hepfo yumwanya watoranijwe kugirango ugera kumeza yose.

Kurambura imikorere kumeza yose

Ibi bikorwa bizafasha kubona umubare wose ukenewe kandi utazafasha kurangara nkayo ​​mugihe ukorana nameza.

Uburyo 3: Gushyira mu bikorwa iterambere

Kandi ubu buryo buratandukanye nibindi bintu bikuraho abakoresha kuba bakeneye gukoresha ikimenyetso cyiyo acyo. Iki kibazo gifite akamaro kinini, kubera ko porogaramu yacyo idakora iyo ikorana n'ameza manini.

1. Kora inkingi kumibare hanyuma urebe muri selile yambere ya 1.

Kora ibikorwa byibanze

1. Jya kumurongo wibikoresho hanyuma ukoreshe igice "murugo", aho tujya ahagaragara "guhinduranya" no gushaka igishushanyo mbonera (mugihe uzengurutse izina "kuzuza").

Jya kuri "Iterambere"

1. Muri menu yamanutse ukeneye gukoresha imikorere "Iterambere".
2. Mu idirishya rigaragara, ibi bikurikira bigomba gukorwa:

Uzuza amakuru akenewe

1. Niba ibintu byose bikozwe neza, uzabona ibisubizo byo kubara byikora.

Igisubizo cyakiriwe

Hariho ubundi buryo bwo gukora umubare nkiyi asa nibi:

1. Turasubiramo ibikorwa byo gukora inkingi n'ikimenyetso muri selire ya mbere.
2. Tugenera urutonde rwose rwameza uteganya kubarwa.

Twizihiza ameza yose

1. Jya kuri "urugo" hanyuma uhitemo agace "guhindura".
2. Turimo gushakisha ikintu "kuzuza" no guhitamo "gutera imbere".
3. Mu idirishya rigaragara, tubona amakuru nk'urwo, ukuri ubu ntiruzuzwa ikintu "ntarengwa.

Uzuza amakuru mumadirishya yihariye

1. Kanda kuri "OK".

Ihitamo ni ibintu byinshi, kubera ko bidasaba kubara biteganijwe imirongo ikeneye numero. Nibyo, uko byagenda kose ugomba gutanga urwego rugomba kubarwa.

Igisubizo cyiteguye

Umwanzuro

Umubare wumurongo urashobora koroshya akazi hamwe nimbonerahamwe bisaba kuvugurura cyangwa gushakisha amakuru yifuzwa. Bitewe nibisobanuro birambuye byasobanuwe haruguru, urashobora guhitamo igisubizo cyiza cyo gukemura icyo gikorwa.

Ubutumwa bwo mu buryo bwikora bwo kugereranya imirongo muri Excel. Inzira 3 zo gushiraho imigozi yikora muri Excel yagaragaye mbere kuri tekinoroji yamakuru.