Nigute wandika inyandiko ihagaritse mubuhungiro

Anonim

Umwandiko uhagaritse muri Microsoft Excel

Rimwe na rimwe, iyo ukorana ameza, ugomba gushyiramo inyandiko muri selire uhagaritse, kandi ntabwo ari mu buryo butambitse, nkuko bikunze kwemerwa. Iyi mikorere itangwa na gahunda ya Excel. Ariko ntabwo buri mukoresha azi kuyikoresha. Reka duhangane nuburyo burenze ushobora kwandika inyandiko ihagaritse.

Isomo: Nigute wandika uhagaritse mwijambo rya Microsoft

Kwandika gufata amajwi

Ikibazo cyo kubamo ubushyuhe muri Excel gikemuwe ukoresheje ibikoresho. Ariko nubwo bimeze, hari inzira zitandukanye zo kubishyira mubikorwa.

Uburyo 1: Guhuza binyuze muri menu

Kenshi na kenshi, abakoresha bahitamo gushyiramo inyandiko ihagaritse kumyandiko bahuza idirishya "uko ugendanwa" ushobora kunyura muri menu.

  1. Mugukanda buto yimbeba iburyo kuri selire, ikubiyemo inyandiko tugomba guhindura mumwanya uhagaritse. Mubice bikubiyemo ibikubiyemo, hitamo "imiterere ya" selile ".
  2. Inzibacyuho Kuburyo Bwakagari muri Microsoft Excel

  3. Idirishya "selire" rifungura. Jya kuri tab "guhuza". Kuruhande rwiburyo bwidirishya rifunguye hari "icyerekezo". Muri "dogere", Mburabuzi ni "0". Ibi bivuze icyerekezo cya horizontal cyinyandiko muri selile. Gutwara muri uyu murima ukoresheje agaciro ka clavier "90".

    Gushiraho impamyabumenyi muri Microsoft Excel

    Urashobora kandi gukora bimwe mu buryo butandukanye. Mu nyandiko "inyandiko" Hariho ijambo "inyandiko". Kanda kuri yo, vuga buto yimbeba yibumoso hanyuma ubyuke kugeza ijambo ryemera umwanya uhagaze. Reka kurekura buto yimbeba.

  4. Gukomera kuri Microsoft Excel

  5. Nyuma yigenamiterere ryasobanuwe haruguru rikozwe mumadirishya, kanda kuri buto ya OK.

Kuzigama ibipimo byimiterere ya selile muri Microsoft Excel

Nkuko tubibona, nyuma yibi bikorwa, ibyinjira mumateka yatoranijwe byabaye imbonanke.

Kwinjira mu bushake muri Microsoft Excel

Uburyo 2: ibikorwa bya rubbon

Ntabwo byoroshye gukora inyandiko vertical - ikoreshwa na buto idasanzwe kuri lente, abakoresha benshi bazi ko bitarenze imiterere.

  1. Hitamo selile cyangwa intera aho duteganya gushyira amakuru.
  2. Guhitamo intera muri Microsoft Excel

  3. Jya kuri tab "urugo", niba uri muriki gihe turi muyindi tab. Kuri kaseti muri "guhuza" ibikoresho, kanda buto "icyerekezo". Kurutonde rufungura, hitamo "kuzenguruka inyandiko hejuru" ikintu.

Inyandiko yibiziga muri Microsoft Excel

Nyuma yibi bikorwa, inyandiko muri selile yatoranijwe cyangwa intera izerekanwa ku buryo buhagaritse.

Inyandiko yoherejwe muri Microsoft Excel

Nkuko mubibona, ubu buryo burushaho bworoshye kuruta icyambere, ariko, nyamara, burakoreshwa cyane. Kuri Byose, Byinshi Nkunda Gukora Ubu buryo unyuze mu idirishya, noneho urashobora kujya kuri tab yaryo hamwe na kaseti. Kugirango ukore ibi, mugihe muri tab "murugo", birahagije gukanda kumashusho muburyo bwumwambi wiburyo, uherereye mu mfuruka yo hepfo yiburyo bwitsinda ryibikoresho byo guhuza.

Inzibacyuho Kuburyo Bwakagari muri Microsoft Excel

Nyuma yibyo, idirishya rya "selile" rizafungurwa kandi ibikorwa byose byabakoresha bigomba kuba bisa nkuburyo bwa mbere. Ni ukuvuga, bizaba ngombwa gukora manipuline hamwe nibikoresho muri "icyerekezo" kuri tab yo guhuza.

Imiterere ya selile muri gahunda ya Microsoft Excel

Niba ushaka guhagarikwa ahantu h'inyandiko ubwayo, kandi inyuguti zari mumwanya usanzwe, noneho nayo ikorwa ukoresheje buto yo kwerekeza kuri kaseti. Twanditse kuriyi buto no kurutonde rugaragara, hitamo "ikintu gihagaritse".

Guhinduranya kumyandiko ihagaritse muri Microsoft Excel

Nyuma yibi bikorwa, inyandiko izafata umwanya uhuye.

Umwandiko uhagaritse muri Microsoft Excel

Isomo: Imbonerahamwe ya Excel

Nkuko mubibona, hariho inzira ebyiri zingenzi zo guhindura icyerekezo cyinyandiko: binyuze mu "miterere ya selile" no guhuza "kuri kaseti. Hamwe nibyo, ubwo buryo byombi bukoresha uburyo bumwe. Mubyongeyeho, ugomba kumenya ko hari verisiyo ebyiri zahantu hahagaritse ibintu biri mu kagari: Ahantu hahagaritse inyuguti hamwe nu mwanya usa n'amagambo muri rusange. Mu rubanza rwa nyuma, inyuguti zanditswe mumwanya usanzwe, ariko mu nkingi.

Soma byinshi