Idan kun buɗe Excel kuma ba zato ba tsammani ya gano cewa akwai lambobi a cikin rubutun shafi maimakon haruffan da aka saba, kada ku karaya kuma karanta wannan labarin har zuwa ƙarshe! A cikin wannan darasi, za ku koyi yadda ake canza lambobi zuwa haruffa a cikin ginshiƙai, da kuma sanin hanyoyin haɗin yanar gizo a cikin Microsoft Excel.
Menene salon hanyar haɗin gwiwa?
Kowane takardar Excel an yi shi ne da layuka da ginshiƙai. A mafi yawan lokuta, ginshiƙai ana nuna su ta haruffa (A, B, C) kuma ana nuna layuka da lambobi (1, 2, 3). A cikin Excel ana kiransa hanyar haɗi A1. Koyaya, wasu sun fi son yin amfani da salon daban, inda ginshiƙan kuma ake ƙididdige su. Ana kiranta Hanyar hanyar haɗin R1C1.
Salon hanyar haɗin yanar gizo na R1C1 na iya zama da amfani a wasu yanayi, amma kamar yadda aikin ya nuna, wannan baƙon abu ne. Har ila yau, akwai ƙungiyar masu amfani waɗanda ke son yin aiki tare da wannan tsarin hanyar haɗin gwiwa, duk da haka, ba su zama sababbin ba. A mafi yawan lokuta, zakuyi aiki tare da salon hanyar haɗin A1, wanda aka shigar a cikin Microsoft Excel ta tsohuwa.
Wannan koyawa da kusan dukkan darussan da ke wannan rukunin yanar gizon suna amfani da salon hanyar haɗin A1. Idan a halin yanzu kuna amfani da salon hanyar haɗin R1C1, kuna buƙatar kashe shi.
Kunna/ kashe salon hanyar haɗin R1C1
- danna fayil, Don matsawa zuwa kallon baya.
- latsa Siga.
- A cikin akwatin maganganu da ya bayyana Zaɓuɓɓukan Excel Zaɓi sashe tsari. Duba akwatin Hanyar hanyar haɗin R1C1 kuma latsa OK. Excel zai canza zuwa salon hanyar haɗin R1C1.
Kamar yadda kuke tsammani, don komawa zuwa salon hanyar haɗin A1, ya isa ku cire alamar wannan akwatin.