Iyo ukorera muri gahunda ya Excel, birakenewe cyane kongeramo imirongo mishya mumeza. Ariko, ikibabaje, abakoresha bamwe batazi gukora ibintu byoroshye. Nibyo, twakagombye kumenya ko iki gikorwa gifite "imitego". Reka tumenye uburyo bwo gushiramo umurongo muri Microsoft Excel.
Shyiramo imirongo hagati yumurongo
Twabibutsa ko uburyo bwo kwinjiza umurongo mushya muri verisiyo zigezweho ya gahunda ya Excel mubyukuri ntabwo ifite itandukaniro.
Noneho, fungura ameza ukeneye kugirango wongere umugozi. Kwinjiza umugozi hagati yumurongo ukanze buto yimbeba iburyo kumurongo wumurongo wumurongo, duteganya gushyiramo ikintu gishya. Mubice bikubiyemo ibikubiyemo, kanda kuri "Paste ...".
Kandi, hari amahirwe yo kwinjiza udahamagaye ibivugwamo. Kugirango ukore ibi, kanda gusa kuri clavier urufunguzo rwa clavier "Ctrl +".
Agasanduku k'ibiganiro karafungura, iduha kwinjiza mumeza y'akagari hamwe no guhinduranya, selile hamwe na shice iburyo, inkingi, n'umugozi. Dushiraho switch kuri "umugozi", hanyuma ukande kuri buto "OK".
Nkuko mubibona, umurongo mushya muri gahunda ya Microsoft Excel wongeyeho.
Kwinjiza imirongo kumpera yimeza
Ariko icyo gukora niba ukeneye kwinjiza akagari bitari hagati yumurongo, ariko ongeraho umugozi kumpera yimeza? N'ubundi kandi, niba ukoresha uburyo bwavuzwe haruguru, umurongo wongeyeho ntuzashyirwa mumeza, ariko uzaguma hanze yumupaka wacyo.
Kugirango uteze imbere imbonerahamwe, hitamo umurongo wa nyuma wimeza. Mu mfuruka yiburyo bwiburyo, umusaraba. Ndayikuramo imirongo myinshi nkuko dukeneye kwagura ameza.
Ariko, nkuko tubibona, selile zose zo hasi zikorwa hamwe namakuru yuzuye kuva muri selile. Gukuraho aya makuru, hitamo selile nshya zakozwe, hanyuma ukande buto yimbeba iburyo. Mubikubiyemo bigaragaye, hitamo "ibintu bisobanutse".
Nkuko mubibona, selile zisukurwa, kandi ziteguye kuzuza amakuru.
Birakenewe gusuzuma ko ubu buryo bukwiye gusa niba nta murongo wanyuma wibisubizo biri kumeza.
Gukora ameza yubwenge
Ariko, byoroshye kurema, yiswe, "ameza yubwenge". Ibi birashobora gukorwa rimwe, hanyuma ntugahangayikishe ko umurongo runaka mugihe wongeyeho utinjira kumeza imipaka. Iyi mbonerahamwe izarambukira, kandi usibye, amakuru yose yagize uruhare rutazavamo formulaire ikoreshwa mumeza, ku rupapuro no mu gitabo muri rusange.
Rero, kugirango dukore "ameza yubwenge", tugenera selile zose zigomba kubyinjiramo. Muri tab ya Murugo, kanda kuri "imiterere nkimeza". Kurutonde rwimiterere iboneka, duhitamo imiterere utekereza ko ukunda cyane. Gukora "ameza yubwenge", guhitamo uburyo runaka ntacyo bitwaye.
Nyuma yuburyo bwatoranijwe, agasanduku k'ibiganiro gifungura, aho urwego rwingirabuzimafatizo rwatoranijwe natwe rwasobanuwe, kuburyo udakeneye kugira ibyo uhindura. Kanda buto ya "OK".
"Imbonerahamwe y'ubwenge" iriteguye.
Noneho, kugirango wongere umugozi, kanda ku kagari umugozi uzaremwa. Mubikubiyemo, hitamo "shyiramo umurongo wameza hejuru" ikintu.
Umugozi wongeyeho.
Umugozi uri hagati yumurongo urashobora kongerwaho ukanda gusa "Ctrl +" urufunguzo. Ntabwo ngomba kwinjira mubindi byose.
Ongeraho umurongo urangije ameza yubwenge muburyo butandukanye.
Urashobora guhaguruka kuri selile iheruka kumurongo wanyuma, hanyuma ukande kuri clavier urufunguzo rwa Tabe (tab).
Kandi, urashobora guhaguruka indanga iburyo bwiburyo bwa selile iheruka, hanyuma ubikure hasi.
Iki gihe, selile nshya zizuzura ubusa mu ntangiriro, kandi ntibazakenera gusukurwa ku makuru.
Kandi urashobora kwinjiza gusa amakuru kumurongo uri munsi yameza, kandi bizahita bishyirwa mumeza.
Nkuko mubibona, ongeraho ingirabuzimafatizo muri gahunda ya Microsoft Excel zirashobora kuba muburyo butandukanye, ariko kugirango ntakibazo cyo kongeramo, mbere, nibyiza gukora "imbonerahamwe yubwenge" ukoresheje imiterere.