Nkuko mubizi, muburyo busanzwe, muri selile imwe, urupapuro rwa Excel ruherereye umurongo umwe hamwe numubare, inyandiko cyangwa andi makuru. Ariko nkwiye gukora iki niba ukeneye kohereza inyandiko muri selire imwe kuwundi murongo? Iki gikorwa kirashobora gukorwa ukoresheje ibintu bimwe na bimwe bya gahunda. Reka tumenye uburyo bwo gukora umurongo bihindura muri selile muri Excel.
Inzira zo Kwimura inyandiko
Abakoresha bamwe bagerageza kohereza inyandiko imbere mukagari bakanda Enter Button. Ariko kubwibyo bashaka gusa ko indanga yimukira kumurongo ukurikira. Tuzareba amahitamo yo kwimura neza imbere ya selile, byombi byoroshye kandi bigoye.Uburyo 1: Gukoresha clavier
Uburyo bwo kwimura cyane nundi mugozi nugushiraho indanga mbere yigice ushaka kwimura, hanyuma wandike urufunguzo rwa clavier Alt (ibumoso) + Injira.
Bitandukanye no gukoresha buto imwe gusa, ukoresheje ubu buryo, bizashoboka ko ibisubizo bishyirwa.
Isomo: Urufunguzo rushyushye muri Excele
Uburyo 2: Gutunganya
Niba umukoresha adashyizeho imirimo yo kwimura amagambo akomeye kumurongo mushya, kandi ukeneye gusa kubihuza muri kaligarani, utarenze umupaka wacyo, urashobora gukoresha igikoresho cyo guhinduranya.
- Hitamo selile aho inyandiko irenze imipaka. Kanda kuri Iburyo bwimbeba. Kurutonde rufungura, hitamo ikintu "imiterere ingirabuzimafatizo ...".
- Idirishya rifungura. Jya kuri tab "guhuza". Muri "kwerekana" igenamiterere, hitamo "kwimura ukurikije" ibipimo, bikabimenya hamwe na ikimenyetso. Kanda kuri buto ya "OK".
Nyuma yibyo, niba amakuru agaragara hakurya yimipaka ya selire, bizahita kwagura uburebure, kandi amagambo azoherezwa. Rimwe na rimwe, ugomba kwagura imipaka intoki.
Kugirango nabo badahindura buri kintu kugiti cye, urashobora guhita uhitamo agace kose. Ibibi byiyi nzira nuko iyimurwa ryakozwe gusa niba amagambo adahuye nimbibi, usibye, amacakubiri akorwa mu buryo bwikora atazirikana icyifuzo cyumukoresha.
Uburyo 3: Gukoresha formula
Urashobora kandi gukora iyimurwa imbere ya selile ukoresheje formula. Ihitamo rifite akamaro cyane cyane niba ibiyirimo byerekanwe ukoresheje imikorere, ariko birashobora gukoreshwa mubihe bisanzwe.
- Hindura selile nkuko bigaragara muri verisiyo ibanza.
- Hitamo selile hanyuma wandike imvugo ikurikira kuri yo cyangwa mumurongo:
= Gufata ("inyandiko1"; ikimenyetso (10); "inyandiko2")
Aho kugirango "inyandiko1" na "inyandiko2", ugomba gusimbuza amagambo cyangwa amategeko ushaka kwimura. Inyuguti zisigaye ntabwo zikenewe.
- Kugirango ibisubizo bigaragare kurupapuro, kanda buto yinjira kuri clavier.
Ibibi nyamukuru byubu buryo nukuri ko bigoye kubishyira mubikorwa kuruta amahitamo yabanjirije.
Isomo: IBIKURIKIRA BY'INGENZI BYASOBLE
Muri rusange, umukoresha agomba guhitamo icyerekezo cyateganijwe ari cyiza cyo gukoresha mugihe runaka. Niba ushaka inyuguti zose kugirango zihuze ni imbibi za selire, hanyuma uyishyire muburyo bwifuzwa, kandi ibyiza muri byose imiterere. Niba ushaka gushiraho ihererekanya yamagambo yihariye, hanyuma uhamagare urufunguzo ruhuye, nkuko byasobanuwe mubisobanuro byuburyo bwa mbere. Ihitamo rya gatatu rirasabwa gusa mugihe amakuru akuwe mubindi bipimo akoresheje formula. Mu bindi bihe, gukoresha ubu buryo ntabwo byumvikana, kuko hari uburyo bworoshye bwo gukemura icyo gikorwa.