Nigute ushobora gukora igika cyagaciro

Rimwe na rimwe, abakoresha bo mu biro bya Microsoft bakeneye kwiyandikisha muri kasho imwe y'umeza atray icyarimwe y'inyandiko nyinshi, bigatuma igika. Amahirwe nka Excel arashobora gushyirwa mubikorwa muburyo butandukanye ukoresheje ibikoresho bya gahunda bisanzwe. Kubijyanye nuburyo bwo kongeramo igika mu kagari ka Madamu Extl Excel bizabwirwa muri iyi ngingo.

Uburyo bwo kohereza inyandiko mu tugari twameza

Muri Excel, ntibishoboka gukora igika cyo gukanda urufunguzo rwa "Enter" uva kuri clavier ya mudasobwa, nko mu Ijambo. Hano birakenewe gukoresha ubundi buryo. Bazaganirwaho.

Uburyo 1. Kwimura inyandiko ukoresheje ibikoresho byo guhuza

Inyandiko yose yinyandiko yose yimbonerahamwe ntabwo ishyirwa mu kagari keza, bityo igomba kwimurirwa kuwundi murongo wikintu kimwe. Inzira yoroshye yo gukora umurimo igabanyijemo intambwe zikurikira:

1. Urufunguzo rwibumoso rwa Manipilator ni ukugaragaza selile aho igika kigomba gukorwa.

Guhitamo selile wifuza kugirango ukore igika muriyo

1. Himura kuri tab "urugo", ziherereye muri Toolbar ya Porogaramu nkuru ya gahunda.
2. Mu gice cya "Guhuza", kanda buto "Kwimura inyandiko".

Inzira igana "inyandiko yoherejwe" muri Excel. Ikora muburyo bwose bwa gahunda

1. Reba ibisubizo. Nyuma y'ibikorwa byabanjirije iki, ubunini bw'akagari byatoranijwe biziyongera, kandi inyandiko nayo izongera kubakwa mu gika, yongeraho imirongo myinshi mu kintu.

Ibisubizo byanyuma. Inyandiko mukagari yimukiye kumurongo mushya. Uburyo 2. Uburyo bwo gukora paragarafu nyinshi muri selire imwe

Niba inyandiko yagenwe mubintu bya Excel bigizwe nibisabwa byinshi, birashobora kugabanywamo, guhera buri gitekerezo kumurongo mushya. Ibi bizongera icyerekezo cyigishushanyo, isura yisahani izatera imbere. Kugirango ugere kubice nkibi, birakenewe gukora kuburyo bukurikira:

1. Hitamo Akagari wifuza.
2. Reba umugozi kugirango winjire kumurongo hejuru ya menu nyamukuru iri munsi yibikoresho bisanzwe. Muri yo, inyandiko yikintu cyatoranijwe cyerekanwe rwose.
3. Shira imbeba indanga hagati yinyandiko ebyiri zifatiwe.
4. Hindura clavier ya pc muri Imiterere yicyongereza hanyuma icyarimwe ushimangira "Alt + Enter" buto.
5. Menya neza ko ibyifuzo byarateganijwe, kandi umwe muri bo yimukiye ku murongo ukurikira. Rero, igika cya kabiri gishyirwaho muri kasho.

Gukora paragarafu nyinshi muri selire imwe yumeza ya Excel array

1. Kora ibikorwa bisa nindi nteruro yinyandiko yagenwe.

Uburyo 3. Ukoresheje ibikoresho

Ubu buryo bwo gukora igika muri Microsoft Office Setl bikubiyemo guhindura imiterere ya selile. Kugirango ubishyire mubikorwa, ni ngombwa gukora intambwe zoroshye kuri algorithm:

1. LKM yerekana selile aho inyandiko yahamagaye itashyizwe mubunini bunini.
2. N'agace icyo ari cyo cyose cya element, ukanze iburyo wa Manipulator.
3. Mu idirishya rifungura ubwoko bwibisobanuro, kanda kuri "Imiterere ya selire ..." ikintu.

INZIRA YITONDO Idirishya Idirishya muri Microsoft Office Crorvil

1. Muburyo bwo guhindura ibintu bizerekanwa nyuma yo gukora manipulation yabanjirije, ugomba kujya muri "guhuza".
2. Mu gice gishya cya menu, shakisha "kwerekana" hanyuma ushireho akamenyetso kuruhande "kwimura ukurikije" ibipimo.
3. Kanda kuri "Ok" hepfo yidirishya kugirango ushyiremo impinduka.

Igikorwa algorithm muri tab yo guhuza muri menu "imiterere ya selile" yo kurema igika

1. Reba ibisubizo. Akagari kazahita uhitamo ibipimo wifuza kugirango inyandiko itarenze imipaka yayo, kandi igika kizarema.

Uburyo 4. Gushyira mu bikorwa formula

Microsoft Office Excel ifite formula idasanzwe yo gukora paragarafu, kohereza inyandiko kumirongo myinshi iri kumeza array. Kugirango usohoze inshingano, urashobora gukoresha adgorithm zikurikira:

1. Hitamo selile yihariye yameza ya LKM. Ni ngombwa ko mu ntangiriro nta nyandiko nizindi nyuguti mu kintu.
2. Intoki kuva Mwandikisho ya mudasobwa Injira formula "= gufata (" inyandiko1 "; ikimenyetso (10);" inyandiko2 ")". Mu mwanya w'amagambo "inyandiko1" na "inyandiko2", ugomba gutwara indangagaciro zifatika, I.E. Andika inyuguti zisabwa.
3. Nyuma yo kwandika kugirango ukande kuri "Enter" kugirango urangize formula.

Gushyira mu bikorwa formula idasanzwe yo kohereza imirongo kuri excel

1. Reba ibisubizo. Inyandiko yerekanwe izaba iri kumurongo ukabije, bitewe nubunini bwacyo.

Nigute wagura formula yo gushyiraho paragarafu kumubare wifuzwa

Niba umukoresha akeneye kwimura umurongo icyarimwe mubintu byinshi byimbonerahamwe ukoresheje formula yaganiriye hejuru, birahagije kugirango ukore imikorere ku nsanganyamatsiko yagenwe. Muri rusange, uburyo bwo kuvugurura formula muri excel birasa nkibi:

1. Hitamo akagari aho ibisubizo bya formula yanditswe.
2. Shira imbeba indanga kuruhande rwiburyo bwiburyo bwikintu cyatoranijwe hanyuma ukagira lkm.
3. Rambura akagari kumubare wifuzwa wimbonerahamwe yameza, utikuye LKM.
4. Kurekura urufunguzo rwibumoso rwa Manipulator hanyuma urebe ibisubizo.

Umwanzuro

Rero, kurema ibika muri Microsoft Ofricals ntabwo bitera ibibazo no mubakoresha abadafite uburambe. Kugirango wimure neza umurongo, ni ngombwa kuyoborwa n'amabwiriza yavuzwe haruguru.

Ubutumwa nkuko biri mu kagari ka Excel kugirango igika gitabyebwa mbere kugirango ubone amakuru yamakuru.