Numbera'idojin Lambar Salula a Microsoft Excel

Ga masu amfani da Microsoft Excel, ba asirin ba ne cewa an sanya bayanai a cikin wannan na'urar aikin falle a cikin sel daban. Don mai amfani da damar samun wannan bayanan, ana sanya kowane ɓangaren takardar a cikin adireshin. Bari mu gano ta wace hanya ce ake ƙididdige abubuwan da ke cikin Excel kuma ko za a iya sauya wannan lamba.

Lambobin Lissafi a Microsoft Excel

Da farko dai, ya kamata a faɗi cewa a cikin Excel akwai yiwuwar sauyawa tsakanin nau'in lambobi biyu. Adireshin abubuwan yayin amfani da zaɓi na farko, wanda aka saita ta tsohuwa, yana da tsari A1. Zabi na biyu an gabatar dashi a tsari mai zuwa - R1C1. Don amfani da shi, kuna buƙatar canzawa cikin saitunan. Bugu da kari, mai amfani zai iya lambar sel da hannu, ta yin amfani da zabin dayawa lokaci daya. Bari mu kalli dukkan waɗannan abubuwan fasalin.

Hanyar 1: canza lambar lamba

Da farko, bari mu bincika yiwuwar sauya yanayin lamba. Kamar yadda aka ambata a baya, an saita adireshin tsohuwar sel ta nau'in A1. Wato, ana nuna ginshiƙan ta haruffan haruffan latin, kuma lambobin suna nuna lambobin larabci. Canja zuwa yanayin R1C1 yana ba da shawarar zaɓi wanda a sa lambobi ba wai kawai daidaitawar layuka ba, har ma da ginshiƙai. Bari mu ga yadda ake yin wannan juyawa.

1. Matsa zuwa shafin Fayiloli.



2. A cikin taga da ke buɗe, ta menu a tsaye na hagu, je zuwa sashin "Zaɓuɓɓuka".



3. Taga zabin na Excel yana buɗewa. Ta hanyar menu, wanda ke gefen hagu, je zuwa ƙaramin sashin Tsarin tsari.



4. Bayan sauyawa, kula da hannun dama na taga. Muna neman rukuni na saiti a can "Yin aiki tare da dabaru". Kusa da misali "Tsarin hanyar R1C1" saka alamar nema. Bayan haka, zaku iya latsa maɓallin "Ok" a kasan taga.



5. Bayan an yi amfani da abubuwan da ke sama a cikin taga zaɓuɓɓuka, salon mahaɗin zai canza zuwa R1C1. Yanzu, ba kawai layuka ba, har ma za a ƙidaya lambobi cikin lambobi.

Don dawo da ƙirar daidaitawar tsoho, kuna buƙatar aiwatar da tsari guda, kawai wannan lokacin buɗe akwati "Tsarin hanyar R1C1".

Darasi: Me yasa a cikin Excel maimakon haruffa, lambobi

Hanyar 2: cika maki

Bugu da ƙari, mai amfani da kansa zai iya lambar layuka ko ginshiƙai waɗanda sel suke a ciki, gwargwadon buƙatunsa. Wannan lambar ta al'ada ana iya amfani dashi don nuna layuka ko ginshiƙai na tebur, don wuce lambar jere zuwa ayyukan ayyukan ginannun Excel, da sauran dalilai. Tabbas, ana iya yin lambobi da hannu, kawai ta hanyar fitar da lambobin da suka zama dole daga maballin, amma yafi sauki da sauri don aiwatar da wannan hanyar ta amfani da kayan aikin gama-gari. Gaskiya ne gaskiya yayin ƙidayar manyan bayanai.

Bari muyi la'akari da yadda, ta amfani da alamar mai cikawa, zaku iya abubuwan samfuri na kansu.

1. Mun sanya lamba "1" zuwa tantanin da muke shirin fara lambobi. To matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na abin da aka ƙayyade. A lokaci guda, ya kamata a canza shi zuwa gicciyen baƙar fata. Ana kiranta alamar cikawa. Mun riƙe maɓallin linzamin kwamfuta na hagu kuma ja siginar ƙasa ko dama, dangane da abin da daidai kuke buƙatar lamba: layuka ko ginshiƙai.



2. Bayan isa ga sel na ƙarshe, wanda ya kamata a ƙidaya, saki maɓallin linzamin kwamfuta. Amma, kamar yadda muke gani, duk abubuwanda suke da lambobi suna cike da raka'a kawai. Don gyara wannan, danna kan gunkin a ƙarshen lambar da aka ƙidaya. Saita canjin kusa da abun Cika.



3. Bayan aiwatar da wannan aikin, za a ƙidaya dukkan kewayon da tsari.

Hanyar 3: ci gaba

Wata hanyar da zaku iya lissafa abubuwa a cikin Excel ita ce amfani da kayan aiki da ake kira "Ci gaba".

1. Kamar yadda yake a hanyar da ta gabata, saita lamba "1" a cikin tantanin farko da za a ƙidaya. Bayan haka, kawai zaɓi wannan ɓangaren takardar ta danna kan shi tare da maɓallin linzamin kwamfuta na hagu.



2. Bayan an zaɓi kewayon da ake so, matsa zuwa shafin "Gida". Latsa maballin Cikasanya a kan tef a cikin toshe "Gyara". Lissafin ayyuka ya buɗe. Zabi wani matsayi daga gare ta "Ci gaba ...".



3. An buɗe wani window na Excel "Ci gaba". Akwai saiti da yawa a wannan taga. Da farko dai, bari mu tsaya a shinge "Wuri". Sauyi yana da matsayi biyu a ciki: Yayi layi-layi da Harafi da shafi. Idan kanada bukatar sanya lambobi a kwance, to sai a zabi zabi Yayi layi-layiidan a tsaye - to Harafi da shafi.

   A cikin toshe saitin "Nau'in" don dalilan mu muna buƙatar saita sauya zuwa "Ilmin lissafi". Koyaya, ya riga ya kasance a wannan matsayin ta tsohuwa, don haka kawai kuna buƙatar sarrafa matsayinta.

   Tsarin saiti "Itsungiyoyi" kawai yana aiki lokacin da aka zaɓi wani nau'in Kwanaki. Tunda mun zabi nau'in "Ilmin lissafi", toshewar da ke sama bazai ba mu sha'awa ba.

   A fagen "Mataki" adadi ya kamata a saita "1". A fagen "Iyakataccen darajar" saita yawan lambobi.

   Bayan aiwatar da matakan da ke sama, danna kan maɓallin "Ok" kasan taga "Ci gaba".



4. Kamar yadda muke gani, takamaiman a cikin taga "Ci gaba" za a ƙidaya abubuwan da za'a iya amfani da su don tsari.

Idan baka son ƙididdige yawan abubuwan takardar ƙididdiga waɗanda suke buƙatar ƙididdigewa don nuna su a filin "Iyakataccen darajar" a cikin taga "Ci gaba", sannan a wannan yanayin, kafin fara taga da aka ƙayyade, zaɓi duka kewayon da za'a ƙidaya.

Bayan haka, a cikin taga "Ci gaba" muna yin duk matakan guda ɗaya waɗanda aka bayyana a sama, amma wannan lokacin barin filin "Iyakataccen darajar" fanko.

Sakamakon zai zama iri ɗaya: abubuwan da aka zaɓa za a ƙidaya.

Darasi: Yadda ake yin autocomplete a Excel

Hanyar 4: amfani da aikin

Hakanan zaka iya samar da abubuwan ƙira na lamba ta amfani da ayyukan Excel. Misali, zaka iya amfani da afareta don lambobin layin. LADA.

Aiki LADA yana nufin toshe masu aiki Tunani da Arrays. Babban aikinta shi ne dawo da layin lambar Excel wanda za a saita mahaɗin. Wannan shine, idan muka ayyana azaman hujja ga wannan aikin kowane tantanin halitta a layin farko na takarda, to, zai nuna ƙimar "1" a cikin tantanin halitta inda yake kanta. Idan ka kirkiri hanyar haɗi zuwa kashi na layi na biyu, mai aiki zai nuna lamba "2" da sauransu
Syntax aiki LADA mai zuwa:

= LINE (mahaɗi)

Kamar yadda kake gani, hujja kawai ga wannan aikin ita ce hanyar haɗi zuwa cikin tantanin halitta wanda ya kamata a nuna lambar layinsa a ƙayyadaddun takardar.

Bari mu ga yadda za mu yi aiki tare da ma'aikacin da aka ƙayyade a aikace.

1. Zaɓi abu wanda zai zama na farko a cikin adadin da aka ƙidaya. Danna alamar "Saka aikin", wanda yake sama da babban filin aiki na Excel.



2. Ya fara Mayan fasalin. Munyi canji a ciki zuwa wani rukuni Tunani da Arrays. Daga cikin sunayen afareto da aka jera, zabi sunan LADA. Bayan nuna alamar wannan sunan, danna maballin "Ok".



3. Windowaddamar da taga gardamar aikin LADA. Tana da filin guda ɗaya kaɗai, gwargwadon yawan waɗannan muhawara iri ɗaya. A fagen Haɗi muna buƙatar shigar da adireshin kowane sel da ke cikin layin farko na takardar. Za'a iya shigar da masu shiga ta hannu ta hanyar tuka su ta hanyar maballin. Amma duk da haka ya fi dacewa ayi wannan ta kawai sanya siginar kwamfuta a cikin filin sannan kuma danna hagu-danna akan kowane abu a layin farko na takarda. Adireshinta zai bayyana nan da nan a cikin taga muhawara LADA. Saika danna maballin "Ok".



4. A cikin tantanin takarda wanda aikin yake LADA, lambar ya bayyana "1".



5. Yanzu muna buƙatar lamba duk sauran layin. Domin kada muyi aikin ta amfani da mai siye don kowane abu, wanda, hakika, zai ɗauki lokaci mai yawa, zamu kwafa dabarar ta amfani da alamar cikawar da muka riga muka sani. Tsaya saman gefen dama na tantanin halitta tare da dabara LADA kuma bayan an cika alamar ta bayyana, riƙe maɓallin linzamin kwamfuta na hagu. Mun shimfiɗa siginan kwamfuta akan adadin layin da za'a ƙididdige.



6. Kamar yadda kake gani, bayan aiwatar da wannan matakin, dukkan layin yawan da aka kayyade za a ƙidaya shi ta lambar mai amfani.

Amma kawai mun ƙidaya layuka, kuma don kammala aikin sanya adireshin tantanin halitta kamar lamba a cikin teburin, ya kamata mu ƙidaya lambobi. Hakanan za'a iya yin wannan ta amfani da aikin ginanniyar Excel. Ana sa ran wannan ma'aikaci ya kasance SARAUTA.

Aiki COLUMN Hakanan yana cikin rukunan masu aiki Tunani da Arrays. Kamar yadda zaku iya tsammani, aikinsa shine fitar da lambar shafi zuwa ainihin takaddar takarda zuwa tantanin da aka sanya hanyar haɗin. Gwanin wannan aikin kusan daidai yake da bayanin da ya gabata:

= COLUMN (mahaɗi)

Kamar yadda kake gani, kawai sunan mai aiki ya sha bamban, kuma gardamar, kamar ta ƙarshe, haɗi ne zuwa takamaiman abin da shafin yake.

Bari mu ga yadda za mu cim ma aikin ta amfani da wannan kayan aiki a aikace.

1. Zaɓi abu wanda sashin farko na zangon da aka sarrafa zai dace. Danna alamar "Saka aikin".



2. Je zuwa Mayan fasalinmatsar da rukuni Tunani da Arrays kuma a wurin muna nuna sunan SARAUTA. Latsa maballin "Ok".



3. Farkon Tsararren Window COLUMN. Kamar lokacin da ya gabata, sanya siginan kwamfuta a fagen Haɗi. Amma a wannan yanayin, muna zaɓar kowane sashi ba na layi na farko na takarda ba, amma na layi na farko. Za'a nuna kwaskwarimar nan da nan a fagen. Sannan zaku iya danna maballin. "Ok".



4. Bayan haka, lambar za a nuna shi a cikin tantanin da aka tsara "1"m zuwa ga lamba shafi na dangin da aka ƙayyade ta mai amfani. Don ƙidaya ragowar ginshiƙai, haka kuma a game da layuka, muna amfani da alamar cikawa. Tsaya akan ƙananan gefen dama na tantanin da ke ɗauke da aikin COLUMN. Muna jiran alamar mai cikewar ta bayyana kuma, rike maɓallin linzamin kwamfuta na hagu, ja siginar hannun dama ta dama abubuwan da ake so.

Yanzu duk ƙwayoyin da ke cikin teburinmu na da lambar ƙidayar su. Misali, wani sashi wanda aka sa hoton 5 a cikin hoton da ke ƙasa yana da daidaitawar mai amfani (3;3), duk da cewa cikakkiyar adireshin sa a cikin mahallin ya rage E9.

Darasi: Wipe Feature in Microsoft Excel

Hanyar 5: suna ta hanyar tantanin halitta

Baya ga hanyoyin da ke sama, ya kamata a lura cewa, duk da sanya lambobi zuwa lambobi da layuka na takamammen tsararru, za a saita sunayen sel a ciki daidai da lambar lambar. Ana iya ganin wannan a filin suna na musamman lokacin zabar wani kashi.

Don canja sunan mai dacewa ga daidaitawa na takardar zuwa wanda muka ƙayyade ta amfani da daidaitawa na dangi don tsarinmu, ya ishe zaɓi zaɓi da madoshi tare da danna maɓallin linzamin kwamfuta na hagu. To, kawai daga keyboard a cikin filin suna, fitar da sunan da mai amfani ya ɗauka ya zama dole. Zai iya zama kowace kalma. Amma a cikin yanayinmu, muna kawai shigar da haɗin gwiwar dangi na wannan kashi. A cikin sunanmu, muna nuna lambar layin ta haruffa "Shafin", da lambar shafi "Tebur". Mun sami sunan nau'in mai zuwa: "Tabasabas". Muna fitar da shi cikin filin suna kuma danna maɓallin Shigar.

Yanzu an sanya tantanin mu suna bisa ga adireshin dangin sa a cikin tsarin. Ta wannan hanyar, zaka iya ba sunayen wasu abubuwan na tsararru.

Darasi: Yadda ake kiran suna a cikin Excel

Kamar yadda kake gani, akwai nau'ikan nau'ikan lambobi guda biyu a cikin Excel: A1 (tsoho) da R1C1 (an haɗa shi cikin saiti). Wadannan nau'ikan adreshin suna aiki ne da duk takarda. Amma Bugu da kari, kowane mai amfani na iya yin nasu mai amfani lamba a cikin tebur ko takamaiman bayanai. Akwai hanyoyi da yawa da aka tabbatar don sanya lambobin al'ada zuwa sel: ta amfani da mai cike da alamar, kayan aiki "Ci gaba" da ayyuka na musamman da aka gina a ciki. Bayan an saita lambobi, zaku iya sanya suna zuwa takamaiman abun da shafin ya dogara dashi.