Uburyo bwo Gukuraho Urupapuro Muri Excel

Anonim

Kuraho urupapuro rwa Microsoft Excel

Nkuko mubizi, mugitabo Excel hari amahirwe yo gukora impapuro nyinshi. Byongeye kandi, igenamiterere risanzwe ryerekanwe kugirango inyandiko iremye ifite ibintu bitatu. Ariko, hari ibibazo abakoresha bakeneye kuvanaho amakuru cyangwa ubusa kugirango batabangamira. Reka turebe uko ibi byakorwa muburyo butandukanye.

Gukuraho inzira

Gahunda ya Excel ifite ubushobozi bwo gukuraho urupapuro rumwe na benshi. Reba uburyo bikorwa mubikorwa.

Uburyo 1: Kuraho binyuze muri menu

Uburyo bworoshye kandi bwimuntu bwo gukora ubu buryo bugomba gukoresha ibishoboka ko ibikubiyemo bitanga. Dukora buto yimbeba iburyo kumurongo, itagikenewe. Mu rutonde rwabigizengingo, hitamo "Gusiba".

Kuraho urupapuro rwa Microsoft Excel

Nyuma yibi bikorwa, urupapuro ruzashira kurutonde rwibintu hejuru yimiterere.

Uburyo 2: Kuraho ibikoresho bya kaseti

Birashoboka gukuraho ibintu bikenewe bidakenewe ukoresheje ibikoresho biherereye kuri kaseti.

  1. Jya ku rupapuro dushaka gukuraho.
  2. Inzibacyuho kurutonde muri Microsoft Excel

  3. Mugihe muri tab "murugo", kanda kuri buto kuri "Gusiba" muri "Ibikoresho bya Kagari". Muri menu igaragara, kanda kumashusho muburyo bwa mpandeshatu hafi ya "Gusiba". Muri menu ifunguye, guhagarika guhitamo ikintu "gusiba ibibabi".

Kuraho urupapuro ukoresheje kaseti muri Microsoft Excel

Urupapuro rukora ruzahita rukurwaho.

Uburyo 3: Gusiba ibintu byinshi

Mubyukuri, uburyo bwo gusiba ubwabwo ni kimwe no muburyo bubiri bwasobanuwe. Gusa kugirango ukureho impapuro nyinshi mbere yo gukora inzira itaziguye, tugomba kubagenera.

  1. Kugenera ibintu biherereye, fata urufunguzo rwa Shift. Noneho kanda ahabanza, hanyuma ucya nyuma, ufashe buto irakanda.
  2. Guhitamo impapuro zikurikirana muri Microsoft Excel

  3. Niba ibyo bintu ushaka gukuraho ntabwo ari hamwe, ahubwo biratatanye, noneho muriki kibazo ukeneye gukanda buto ya CTRL. Noneho kanda kuri buri zina ryimpapuro zizakenera kuvaho.

Hitamo impapuro kugiti cye muri Microsoft Excel

Ibintu bimaze kugaragara, birakenewe gukoresha bumwe muburyo bubiri bwo kuvaho, byaganiriweho hejuru.

Isomo: Nigute Wongeyeho urupapuro mu nyanja

Nkuko mubibona, ukure impapuro zidakenewe muri gahunda ya Excel biroroshye. Niba ubishaka, ni birashoboka ko ukureho ibintu byinshi icyarimwe.

Soma byinshi