Canza sunayen shafi daga lambobi zuwa haruffa

An san cewa a cikin al'ada, ana nuna jigon shafi a cikin Excel ta haruffan haruffan latin. Amma, a wani lokaci, mai amfani na iya gano cewa yanzu ana nuna ginshiƙan lambobi ta lambobi. Wannan na iya faruwa saboda dalilai da yawa: nau'in ɓarna iri daban-daban, ayyukan ba da gangan ba, da gangan sauya nuni zuwa wani mai amfani, da dai sauransu. Amma, duk abin da dalilai, a yayin da aka sami irin wannan halin, batun dawo da allon sunayen kwatankwacin jiha ya zama ya dace. Bari mu bincika yadda ake canza lambobi zuwa haruffa a cikin Excel.

Nunin Canjin Zaɓuɓɓuka

Akwai zaɓuɓɓuka biyu don kawo kwamitin daidaitawa a cikin hanyar da aka saba. Carriedayan ɗayansu ana aiwatar da su ta hanyar keɓaɓɓiyar dubawa, kuma na biyu ya ƙunshi shigar da umarnin da hannu ta amfani da lambar. Bari muyi la’akari da duka hanyoyin daki daki daki daki.

Hanyar 1: yi amfani da dubawar shirin

Hanya mafi sauki don sauya taswirar sunayen shafi daga lambobi zuwa haruffa shine amfani da kayan aikin kai tsaye na shirin.

1. Munyi canji zuwa shafin Fayiloli.



2. Mun matsa zuwa sashin "Zaɓuɓɓuka".



3. A cikin taga wanda zai buɗe, saitunan shirin suna zuwa yanki Tsarin tsari.



4. Bayan juyawa a cikin ɓangaren tsakiyar taga, muna neman toshe saiti "Yin aiki tare da dabaru". Kusa da misali "Tsarin hanyar R1C1" cika Latsa maballin "Ok" a kasan taga.

Yanzu sunan ginshiƙai akan kwamitin gudanarwa zai ɗauki hanyar da muka saba, wato, ana nuna shi da haruffa.

Hanyar 2: amfani da macro

Zabi na biyu a zaman mafita ga matsalar ya shafi amfani da macro.

1. Muna kunna yanayin mai haɓaka akan tef, idan ya kashe. Don yin wannan, matsa zuwa shafin Fayiloli. Bayan haka, danna kan rubutun "Zaɓuɓɓuka".



2. A cikin taga da ke buɗe, zaɓi Saitin Ribbon. A cikin hannun dama na taga, duba akwatin kusa da "Mai Haɓakawa". Latsa maballin "Ok". Don haka, ana kunna yanayin mai haɓaka.



3. Je zuwa shafin "Mai haɓaka". Latsa maballin "Kayayyakin aikin Kayan gani"wadda take kan gefen hagu na haƙarƙarin a toshe saitunan "Lambar". Ba za ku iya aiwatar da waɗannan ayyuka akan tef ɗin ba, amma kawai buga gajerar hanyar faifan maɓallin keyboard Alt + F11.



4. Edita VBA ya buɗe. Latsa gajeriyar hanya a maballin Ctrl + G. A cikin taga yana buɗe, shigar da lambar:

   Aikace-aikacen.ReferenceStyle = xlA1

   Latsa maballin Shigar.

Bayan waɗannan ayyukan, allon wasiƙar sunayen shafi na takardar zai dawo, yana canza zaɓin lambobi.

Kamar yadda kake gani, canjin da ba'a zata ba na sunan shafi shafi daga haruffa zuwa lambobi bazai girgiza mai amfani ba. Kowane abu mai sauƙi ana iya komawa zuwa matsayin da ya gabata ta canza saitin Excel. Zaɓin amfani da macro yana da ma'ana don amfani kawai idan, saboda wasu dalilai, baza ku iya amfani da madaidaicin hanyar ba. Misali, saboda wani irin rashin nasara. Hakanan zaka iya, amfani da wannan zabin don dalilai na gwaji, kawai dan ganin yadda wannan nau'in sauyawa yake aiki a aikace.