Nigute wasinya umurongo wimbonerahamwe muri excel

Anonim

Imbonerahamwe amashoka mu Microsoft Excel

Nyuma kubaka imbonerahamwe muri gahunda Microsoft Excel, mu amashoka Mburabuzi kuguma Bitashizweho umukono. Birumvikana, bituma cyane bigoye gusobanukirwa ibikubiye muri gishushanyo. Muri urwo rubanza, ikibazo kugaragaza izina ku amashoka uba zibishinzwe. Reka figure uko gusinya biyunze bw'iki gishushanyo mu gahunda Microsoft Excel, n'uko Kugenera aryita.

Izina fatizo Uhagaritse

Nuko, dufite Igishushanyo yiteguye aho ukeneye gutanga amazina amashoka ku.

Imbonerahamwe mu Microsoft Excel

Kugira ngo Kugenera izina rya fatizo Uhagaritse rw'iki gishushanyo, kujya mu "Igaragaza" tab ya Shebuja wa Works na Ibishushanyo ku Microsoft Excel ribbon. Kanda ku "bami izina" Akabuto. Duhisemo, Ikintu "izina nyamukuru Uhagaritse biyunze". Maze, guhitamo neza aho izina izaba iherereye.

Hari ibintu bitatu kuri izina:

  1. Rotated;
  2. Uhagaritse;
  3. Utambitse.

Duhisemo, reka kuvuga igikombe arahindukira.

Ihitamo Ishyira mu mwanya Bya izina biyunze mu Microsoft Excel

Ivyo vyandiko biravuga Mburabuzi bigaragara, ari na yo bita "biyunze izina".

Izina biyunze mu Microsoft Excel

Kanda ku, na twebwe izina izina ko Amakoti iyi Umurongo fatizo na biravugwa.

Guhindura izina rya fatizo Uhagaritse mu Microsoft Excel

Niba uhisemwo Ishyira Uhagaritse izina, ubwoko icandiko izaba bikurikira nk'uko yagejeje hepfo.

izina Uhagaritse ya biyunze mu Microsoft Excel

Na Ishyira Utambitse, ryanditseho izaba abahagarika bukurikira.

Utambitse fatizo izina mu Microsoft Excel

Izina rya fatizo Utambitse

Hafi mu buryo nk'ubwo, mu izina rya fatizo Utambitse ahawe.

Kanda ku i Akabuto ku "Izina udushoka", ariko igihe iyi mpisemo Ikintu "izina nyamukuru Utambitse biyunze". Hari umwe gusa amacumbi Ihitamo - "munsi fatizo mu". Guhitamo ni.

Kwitura ku izina rya fatizo Utambitse mu Microsoft Excel

Nk'uko nyuma, Kanda gusa ku izina, na Guhindura izina ngo we turimbura ngombwa.

Guhindura izina rya alarium biyunze mu Microsoft Excel

Gutyo, amazina amashoka byombi bashinzwe.

Change Utambitse umukono

Uretse izina, biyunze afite imikono, ni ukuvuga amazina indangagaciro buri cyiciro. Ushobora guhindura na bo.

Itondekanya Kuri Guhindura ubwoko umukono biyunze Utambitse, Kanda ku "bami" Akabuto, na Guhitamo i Agaciro "Main Utambitse fatizo" hari. Mburabuzi, umukono cyashyizwe iburyo ibumoso. Ariko ku ku i Ibigize "Nta" cyangwa "nta umukono", ushobora rusange Kwangira i Kugaragaza: Bya i Isinya Utambitse.

Nta umukono biyunze mu Microsoft Excel

Kandi nyuma i Ikintu "iburyo ibumoso", umukono Amahinduka ubuyobozi bwayo.

Biyunze ku bwo Ibumoso mu Microsoft Excel

Uretse, ushobora Kanda ku "Ibigenga Ibindi nyamukuru Utambitse fatizo ...".

Hindura Kuri Ibigenga y'inyongera biyunze Utambitse mu Microsoft Excel

Nyuma, A Idirishya yugurura aho umubare Bya Kugaragaza fatizo Igenamiterere zitangwa: i Intera hagati amacakubiri, umurongo Ibara, umukono Ibyatanzwe Imiterere (Bikurikije umubare, amafaranga, Umwandiko , n'ibindi), umurongo Ubwoko Itunganya, n'ibindi byinshi.

Ibigenga by'inyongera biyunze mu Microsoft Excel

Guhindura Uhagaritse umukono

Guhindura umukono Uhagaritse, Kanda ku "bami" Akabuto, na Hanyuma Gyayo Kuri izina "Main Uhagaritse biyunze". Nk'uko ubibona, muri uru rubanza, bisa uburyo bwinshi bwo guhitamo Ishyira mu mwanya Bya umukono ku Umurongo fatizo ku. Ntushobora kwerekana fatizo gato, ariko ushobora guhitamo Rimwe Bya i Amahitamo Imibare bane Kugaragaza:

  • mu bihumbi,
  • muri za miriyoni,
  • mu miriyari;
  • mu ishusho rugero logarithmic.

Kugenzura biyunze Uhagaritse mu Microsoft Excel

Nk'uko kwerekana gahunda ikurikira, nyuma gutoranya runaka Ikintu, indangagaciro y'igipimo duhindurirwa twisunze.

Uhagaritse biyunze mu bihumbi Microsoft Excel

Uretse, ushobora guhita guhitamo "Ibigenga y'inyongera nyamukuru Uhagaritse fatizo ...". Bameze Ikintu bibereye biyunze Utambitse.

Inzibacyuho ngo Ibigenga y'inyongera biyunze Uhagaritse mu Microsoft Excel

Nk'uko ubibona, mu ryandikwa izina n'umukono wa amashoka muri gahunda Microsoft Excel si cyane urusobe, na, muri rusange, Igaragaza. Ariko, nyuma byose, icyoroshye ni gutahura babitumwe na we, ufite mfashanyigisho n'ido kugira igikorwa iburyo. Gutyo, birashoboka ko bugaragara save gihe ku kwiga mice.

Soma byinshi