Nigute ushobora guhindura imbonerahamwe hasi muri excel

Umuntu wese ukora igihe kirekire hamwe nimbonerahamwe ya Excel, mumaso mugihe ukeneye kwimura inkingi imwe cyangwa nyinshi hasi. Ibi birashobora guterwa nuko umubare munini wamakuru agomba gushyirwa mukarere kakazi cyangwa ukeneye kugereranya ameza ya hoteri (inkingi) hagati yabo. Nta gikoresho gitandukanye cyo gukora iki gikorwa muri Excel. Ariko, ibi birashobora gukorwa muguhuza ubushobozi bwiyi gahunda hagati yabo. Ku buryo bwemejwe bwo kwimura imbonerahamwe Ikiganiro byinshi muriki kiganiro.

Kwimura inkingi imwe cyangwa nyinshi binyuze muri "gukata" na "kopi" + "paste"

Uburyo bugaragara kandi buzwi cyane bwo kwimura ameza hasi cyangwa andi mashyaka - binyuze kuri "gukata" na "Paste". Ariko, ni ngombwa kuzirikana ko inzira izatandukana muburyo bumwe cyangwa ameza yose azahindurwa. Uburyo bwo Kwimura Inkingi imwe:

1. Mu ntangiriro, ugomba kwerekana inkingi yose hamwe namakuru. Kugirango ukore ibi, kanda ku nyuguti y'Ikilatini mu mutwe wayo.
2. Kugabanya inkingi, urashobora gukanda urufunguzo rwo guhuza - Ctrl + x. Ihitamo rya kabiri nuguhamagara imiterere ya menu ukanda buto yimbeba iburyo kumutwe winkingi, hitamo imikorere "yaciwe".

Koresha imikorere "Kata" ku mbonerahamwe yihariye

1. Imbeba iragaragara aho ukeneye kwimura inkingi. Kanda PKM, hitamo "Shyiramo Gukata Gukata"
2. Abatoranijwe mbere yibintu byameza y'akazi bizimurirwa ahantu hatoranijwe.

Guhindura inkingi zimwe na rimwe, urashobora gukoresha imwe muburyo 3:

1. Gukoresha imirimo - "Gukoporora" + "shyiramo" + "gusiba" (ikintu kirenze).
2. Gukoresha amategeko - "gukata" + "shyiramo".
3. Gukurura imbeba.

Inzira yo kwimura inkingi imwe cyangwa nyinshi zinyuze mumabwiriza "kopi" + + "Shyiramo" + "Gusiba":

1. Mbere ya byose, ugomba kwerekana inkingi imwe cyangwa nyinshi ukeneye kwimuka. Urashobora kubikora imbeba cyangwa unyuze kurufunguzo kuri clavier (shift - ugomba kuzamuka iyi buto, kanda kumutwe winkingi, kanda ku mutwe winkingi yinkingi) .

Gutangwa gusa ingirabuzimafatizo zuzuyemo amakuru amwe

1. Ibikurikira, birakenewe gushira ahantu mumeza aho ushaka kwimura umurongo watanzwe hamwe namakuru (kanda buto yimbeba). Kanda PCM ahantu hatoranijwe, uhereye kuri menu, hitamo "shyiramo selile".

Ongeraho urutonde rwabigenewe kumeza yifuzwa

1. Igikorwa cya nyuma Ugomba kongera guhitamo inkingi yambere hamwe namakuru, kanda PCM kugirango uhamagare ibikubiyemo, kanda buto "Gusiba".

Himura imbonerahamwe yimitsi

Inzira yoroshye yo kwimura inkingi kugiti cye cyangwa ako kanya mumeza ya Excel - gukurura imbeba. Inzira:

1. Imbeba igenerwa inkingi imwe cyangwa nyinshi. Niba uhuza lkm hamwe na buto ya shift, urashobora guhita uranga umwanya.
2. Kata imbeba indanga kumupaka winkingi cyangwa intera yashyizweho, aho izamukira. Ni ngombwa gutegereza isura yishusho yumusaraba hamwe nimyambi diverge mu byerekezo bitandukanye.
3. Ibikurikira, ugomba gufata urufunguzo rwa shift, ukurura urwego rwurwego ukeneye kugirango uhinduke kumupaka watoranijwe.

Iyo inkingi 1 cyangwa nyinshi zizimurwa ahantu wifuza, ugomba kurekura buto yimbeba nurufunguzo rwa shift.

Koresha macroros

Abakoresha bafite urwego rwo hejuru rwakazi hamwe nameza ya Excel bazakoresha gusa Macro idasanzwe kugirango yimure ibintu byihariye byimeza, yeguriwe Imana. Gushyira mubikorwa ubu buryo, ugomba kwigenga kwandika VBA Macro. Ariko, ubu buryo bufite ikibazo gikomeye. Igihe kinini nigihe cyo gushiraho macro kugeza ku nkingi cyangwa intera yimurirwa ahantu hamwe.

Himura imirongo imwe cyangwa myinshi

Bikwiye kwitabwaho bidasanzwe muburyo busanzwe - bwo hasi-hasi cyangwa byinshi kumeza. Inzira yo kwimura umurongo umwe:

1. Kanda buto yimbeba yibumoso numubare wumurongo ugomba kwimurwa (igipimo gifite imibare giherereye kuruhande rwibumoso bw'ameza).
2. Nyuma yuko umurima watoranijwe ugaragara, uta imbeba hamwe na lkm yashyizwe kumurongo wifuzwa kumurongo wifuzwa.

Iyo umurongo watoranijwe uherereye ahantu wifuza, ugomba kurekura buto yimbeba. Inzira yo kwimura imirongo yegeranye:

1. Ibumoso-Kanda kumurongo wambere wurubuga uhereye kumurongo. Kanda urufunguzo rwa Shift.
2. Kuzenguruka imbeba kugirango uzunguruke ameza.
3. Kurekura buto ya Shift nyuma yimirongo isabwa iragaragara.

Nyuma yibyo, biracyashobora gukanda LKM kumubare uwo ariwo wose watoranijwe, hindura umutekano. Gukora inzira kumanuka kumirongo myinshi iherereye kuri mugenzi wawe:

1. Kanda buto ya CTRL.
2. Ibumoso bwimbeba buto Shyira imirongo yose igomba kwimurwa.

Kanda LKM kumubare uwo ariwo wose watoranijwe, ubamuke ahantu runaka hepfo, reka reka buto yimbeba.

Umwanzuro

Inzira yo kwimura imbonerahamwe yakazi cyangwa urwego rwabigenewe rugoye cyane, niba utazi guhuza imirimo yibanze ya Excel. Biroroshye cyane kwimurwa kubintu byihariye byikintu cyakazi cyibumoso cyangwa bwiburyo. Ariko, kuba twarasobanukiwe nuburyo bwo kumenza byinshi mubitekerezo, mubikorwa ntikwiye kubaho ingorane.

Ubutumwa nkuko biri muri Excel bimura imbonerahamwe yagaragaye mbere kugirango ubone ikoranabuhanga.