Nigute Wongeyeho Izina rya Diam muri Excel

Uburyo 1: Guhindura bihita byongeweho

Inzira ya mbere niyo yoroshye, kubera ko ishingiye ku guhindura izina ryongeweho izina. Bigaragara ako kanya nyuma yo gukora ibishushanyo cyangwa ubundi bwoko bwinzego, kandi bizaba ngombwa kugirango ibitekerezo byinshi bihinduke.

1. Nyuma yo gukora igishushanyo, kanda kuri "Igishushanyo Umutwe" umurongo.



Niba nyuma yo gukora igishushanyo, izina ryayo ntabwo ryongewe mu buryo bwikora cyangwa wasibwe kubwimpanuka, koresha uburyo bukurikira aho ubundi buryo bwatanzwe muburyo burambuye.

Uburyo 2: Igikoresho "Ongeraho Imbonerahamwe"

Abakoresha benshi mugihe bakorana na Excel igishushanyo "uwashushanyije", yagenewe guhindura ibishushanyo nibindi bintu byinjizwa. Irashobora gukoreshwa mugukongeramo izina munsi yumunota.

1. Ubwa mbere, shyira ahagaragara igishushanyo ubwacyo kugirango tabs zifite inshingano zo kubicunga bigaragara hejuru yijuru.



2. Himura kuri tab.



3. Ku gisigaye ni "igishushanyo" clock "aho ukeneye kohereza menu yamanutse" Ongeraho imbonerahamwe y'imbonerahamwe ".



4. Himura indanga kuri "Igishushanyo Umutwe" hanyuma uhitemo bumwe muburyo bwo gukosorwa.



5. Noneho urabona izina risanzwe ryerekana kandi urashobora kuyihindura utanditse gusa, ahubwo unone imiterere yerekana.



Uburyo bumwe ni bufite akamaro kandi kubwizina ryishoka, gusa muri menu imwe yamanutse igomba guhitamo ikindi kintu, bityo ubundi buryo bukorwa muburyo bumwe.

Uburyo 3: Izina ryikora

Ihitamo ni ingirakamaro cyane kubakoresha bakorana nameza aho izina ryigishushanyo rihujwe nizina ryinkingi cyangwa umugozi rimwe na rimwe bihinduka. Muri iki kibazo, ukoresheje imikorere yubatswe muburyo bwubatswe, urashobora gukora izina ryikora ryikora ryahawe selile kandi rihinduka ukurikije guhindura.

1. Niba izina ryamagambo atari rwose, koresha amahitamo yabanjirije kugirango uyiremo.



2. Nyuma yibyo, shyira ahagaragara kugirango uhindure, ariko ntukibone icyo ari cyo cyose.



3. Kumurongo wo kwinjira kuri formula, andika ikimenyetso =, kizaba bisobanura intangiriro yizina ryikora.



4. Iguma gukanda gusa kuri selire, izina ryibyo ushaka gutanga igishushanyo ubwacyo. Muburyo bwinjiza umurongo, impinduka zizagaragara - kanda urufunguzo rwinjira kugirango uyikoreshe.



5. Reba uburyo izina rya diagram rihinduka rifite imbaraga, rihindura iyi selile.



Ni ngombwa kwandika ikimenyetso = mumurongo wo guhindura formulaire, kandi ntuhagarike izina ryimbonerahamwe, kuko syntax ya porogaramu idakora kandi ihatire Autom ntabwo izakora.