Nigute Gukora inyandiko ihangayitse muri Excel

Anonim

Guhangayikishwa inyandiko muri Microsoft Excel

Kwandika ukoresheje inyandiko yikamba bikoreshwa kugirango werekane ko ahakana, bidasobanutse kubikorwa cyangwa ibyabaye. Rimwe na rimwe, iyi mikorere igaragara ko ari ngombwa gusaba mugihe ukora muri Excel. Ariko, ikibabaje, ntanubwo kuri clavier, cyangwa igice kigaragara cyimikorere ya gahunda nta bikoresho byita kubikorwa byo gukora iki gikorwa. Reka tumenye uko ushobora gutondeka inyandiko yambutse.

Isomo: Yashimangiye inyandiko muri Microsoft Ijambo

Gusaba inyandiko yambutse

Kwirukana muri Excel ni ikintu cyo guhindura. Kubwibyo, uyu mutungo urashobora gutangwa ukoresheje imiterere.

Uburyo 1: Ibikubiyemo

Uburyo bukunze kugaragara mu bakoresha ni inzira yo gufungura inyandiko yambutse ijyanye ninzibacyuho binyuze muri menu muri "Imiterere ya selire".

  1. Turagaragaza selile cyangwa intera, inyandiko ukeneye kunyuramo. Kanda buto yimbeba iburyo. Ibikubiyemo bifungura. Kanda kurutonde ukoresheje "imiterere ya selile".
  2. Inzibacyuho Kuburyo Bwakagari muri Microsoft Excel

  3. Idirishya rifungura. Jya kuri tab "Imyandikire". Shyiramo ikimenyetso imbere "ikintu" cyoroshye ", kiri muri" guhindura "igenamiterere. Kanda kuri buto ya "OK".

Imiterere muri Microsoft Excel

Nkuko tubibona, nyuma yibi bikorwa, inyuguti ziri munzu wabigenewe zambutse.

IMISEREZO RY'INGENZI MU BISOMO MURI Microsoft Excel

Isomo: Imbonerahamwe ya Excel

Uburyo 2: Guhindura amagambo kugiti cye

Akenshi, birakenewe kugirango tutagerwaho byose mu Kagari, ariko amagambo yihariye arimo gusa, cyangwa igice cyijambo. Muri Excel birashoboka kandi gukora.

  1. Dushiraho indanga imbere muri selire kandi tugagaragaza igice cyinyandiko ugomba gukorwa. Kanda iburyo kuri menu. Nkuko tubibona, ifite ubwoko butandukanye kuruta mugihe ukoresheje uburyo bwabanje. Nubwo bimeze bityo ariko, ikintu nkeneye "formalls ..." Hariho nazo. Kanda kuri.
  2. Inzibacyuho Kuburyo Bwakagari muri Microsoft Excel

  3. Idirishya "selire" rifungura. Nkuko mubibona, bigizwe nibintu byose kuva kuri tab imwe "imyandikire" imwe, koroshya umurimo, kuko udakeneye kujya ahantu hose. Dushiraho amatiku ahateganye nikintu "gihangayikishije" kandi ukande buto "OK".

Imiterere ya selile muri gahunda ya Microsoft Excel

Nkuko dushobora kubibona, nyuma yibi mabine, igice cyatoranijwe gusa cyibimenyetso byanditse muri kasho byarajanjaguwe.

Guhangayikishwa inyandiko muri selile muri Microsoft Excel

Uburyo 3: Ibikoresho kuri lente

Inzibacyuho kumiterere ya selile kugirango utange inyandiko yambutse, irashobora gukorwa binyuze muri kaseti.

  1. Turagaragaza selile, itsinda rya selile cyangwa inyandiko imbere. Jya kuri tab "urugo". Kanda ku gishushanyo muburyo bwimyambi ya oblique iherereye mugice cyo hepfo yiburyo bwimyandikire yimyandikire kuri kaseti.
  2. Inzibacyuho kugirango uhindure muri Microsoft Excel

  3. Idirishya ryimiterere rifungura cyangwa rifite imikorere yuzuye, cyangwa hamwe na ngufi. Biterwa nuko wahaye agaciro: selile cyangwa inyandiko gusa. Ariko nubwo idirishya rizaba rifite imikorere yuzuye, izafungura muri tab "Imyandikire", dukeneye gukemura icyo gikorwa. Ibikurikira, kora kimwe no muburyo bubiri bwabanje.

Imiterere ya selile muri Microsoft Excel

Uburyo 4: Urufunguzo

Ariko inzira yoroshye yo gukora inyandiko yarenze ni ugukoresha urufunguzo "rushyushye". Kugirango ukore ibi, hitamo selile cyangwa inyandiko) hanyuma uhamagare urufunguzo rwa clavier kuri Ctrl + 5 Mwandikisho.

Inyandiko ifunze muri Microsoft Excel

Birumvikana ko ibi ari byiza cyane kandi byihuse muburyo bwose bwasobanuwe, ariko uhabwa ko umubare muto wabakoresha ukomeza kuba umwe urufunguzo rushyushye ruri munsi yingingo yambukiranya uburyo binyuze mu idirishya.

Isomo: Urufunguzo rushyushye muri Excele

Muri Excel hari inzira nyinshi zo gukora inyandiko yambutse. Aya mahitamo yose afitanye isano n'imikorere ihindura. Inzira yoroshye yo gukora ikimenyetso cyerekanwe ni ugukoresha guhuza urufunguzo rushyushye.

Soma byinshi