Me yasa a cikin hijira maimakon haruffa lambobi

An sani cewa a cikin saba yanayin, ana nuna alamun alamun shafi na fice a cikin haruffan Latin. Amma, a wani lokaci, mai amfani zai iya gano cewa yanzu ana nuna alamun lambobi. Wannan na iya faruwa saboda dalilai da yawa: nau'ikan nau'ikan shirye-shirye masu yawa, daban-daban na rashin aikin da ba a yi ba, wanda mai amfani da gangan ya nuna, da sauransu. Amma, abin da ke faruwa ba haka ba, lokacin da ake tambaya irin wannan irin wannan batun dawo da nuna alamun sunayen ginshiƙi zuwa ga daidaitaccen halin ya zama mai dacewa. Bari mu gano yadda ake canza lambobi a cikin haruffa a Excel.

Nuna canukan canza zabin

Akwai zaɓuɓɓuka guda biyu don kawo kwamitin gudanarwa zuwa tunanin da aka saba. Ofayansu yana gudana ne ta hanyar neman ɗan lokaci, kuma na biyu yana nuna umarnin umarni da hannu ta amfani da lambar. Yi la'akari da cikakken bayani sau biyu.

Hanyar 1: Yin Amfani da Cibiyar Nazarin

Hanya mafi sauki don canza nuni da sunayen ginshiƙai da lambobi a kowace haruffa shine amfani da kayan aikin shirin kai tsaye.

1. Muna yin canjin zuwa "Fayil".



2. Mun koma zuwa "sigogi" sashe.



3. A cikin shirin sigogin shirin da ke buɗe, je zuwa sashin "dabara".



4. Bayan juyawa zuwa tsakiyar taga, mun sami "aiki tare da dabarun" saiti. Game da sigar hanyar haɗin R1C1 ta cire kaska. Latsa maɓallin "Ok" a kasan taga.

Yanzu sunan ginshiƙan da aka tsara shi zai ɗauki kamuwa da kullun a gare mu, shine, za a yi alama da haruffa.

Hanyar 2: Amfani da Macro

Zabi na biyu a matsayin mafita ga matsalar ta ƙunshi amfani da macro.

1. Kunna yanayin mai haɓakawa akan tef, idan ya zama ya zama nakasassu. Don yin wannan, yana motsawa zuwa shafin "fayil". Bayan haka, danna maɓallin "sigogi".



2. A cikin taga da ke buɗe, zaɓi abu mai ribbon saiti. A gefen dama na taga, mun saita kaska kusa da "mai haɓakawa". Latsa maɓallin "Ok". Don haka, ana kunna yanayin haɓakawa.



3. Je zuwa shafin mai haɓakawa. Mun danna maballin "gani na yau da kullun" wanda yake a gefen hagu na tef a cikin "lambar" Saiti. Ba za ku iya samar da waɗannan ayyukan a kan tef ba, amma danna maɓallin keyboard akan alt + F11 keyboard.



4. Da Edita VBA Edita ya buɗe. Danna maɓallin maballin haɗin haɗin Ctrl + G makullin. A cikin taga da ke buɗe, shigar da lambar:

   Aikace-aikace.Raukaki = XLA1

   Latsa maɓallin Shigar.

Bayan waɗannan ayyukan, yanayin haruffan haruffa na sunan takardar ginshiƙai zai dawo, canza zaɓin da yawa.

Kamar yadda kake gani, canjin da ba tsammani na sunan ginshiƙai sassauƙa daga harafin zuwa mara iyaka ya kamata a sa shi a ƙarshen mai amfani ba. Komai yana da sauƙin komawa cikin jihar da ta gabata ta canji a cikin sigogin Excel. Zaɓin amfani da macro yana da ma'ana don amfani kawai idan saboda wasu dalilai ba za ku iya amfani da daidaitaccen hanyar ba. Misali, saboda wani irin gazawa ne. Tabbas, zaku iya amfani da wannan zaɓi don dalilin gwajin don ganin yadda irin wannan nau'in sauya canjin aiki.