Lokacin aiki tare da tebur, sau da yawa wajibi ne don ƙidaya ginshiƙan. Tabbas, ana iya yin wannan da hannu, da gangan tuki lamba don kowane shafi daga maballin. Idan teburin yana da ginshiƙai da yawa, zai ɗauki lokaci mai yawa. Excel yana da kayan aikin musamman waɗanda zasu ba ku lambar da sauri. Bari mu ga yadda suke aiki.
Hanyar lambobi
Akwai zaɓuɓɓuka da yawa don lambar lambar atomatik a cikin Excel. Wasu daga cikinsu masu sauki ne kuma masu fahimta ne, wasu sun fi wahalar ganewa. Bari muyi tunani akan kowannensu don yanke hukunci wanda zaɓi ya yi amfani da shi ya fi fa'ida a wani yanayi.
Hanyar 1: cika maki
Hanya mafi mashahuri don lambar lambobi ta atomatik shine ta amfani da alamar mai cikawa.
- Muna buɗe teburin. Sanya wani layi a ciki, wanda za'a sanya lamba na lamba. Don yin wannan, zaɓi kowane tantanin halitta a cikin jere wanda zai kasance ƙarƙashin lambobi nan da nan, danna-dama, ta haka ana kiran menu na mahallin. A cikin wannan jeri, zaɓi "Manna ...".
- Smallan ƙaramin taga yana buɗewa. Juya canjin zuwa wuri "Sanya layin". Latsa maballin "Ok".
- Sanya lamba a farkon sigar da aka kara "1". To matsar da siginan kwamfuta zuwa ƙananan kusurwar dama ta wannan tantanin. Mawaƙin ya juya ya zama gicciye. Ana kiranta alamar cikawa. A lokaci guda, riƙe maɓallin linzamin kwamfuta na hagu da maɓallin Ctrl a kan keyboard. Ja mai alamar alamar dama daga ƙarshen tebur.
- Kamar yadda kake gani, layin da muke buƙata yana cike da lambobi cikin tsari. Wato, an aiwatar da lambobin lamba.
Hakanan zaka iya yin wani abu. Cika sel biyu na farko na ƙara layi tare da lambobi "1" da "2". Zaɓi ƙwayoyin biyu. Sanya siginan kwamfuta zuwa ƙananan kusurwar dama na dama daga cikinsu. Tare da maɓallin linzamin kwamfuta, buga mai alamar zuwa ƙarshen tebur, amma wannan lokacin ta Ctrl babu buƙatar latsawa. Sakamakon zai zama irin wannan.
Kodayake sigar farko ta wannan hanyar tana da sauƙi, amma, duk da haka, yawancin masu amfani sun fi son amfani da na biyu.
Akwai kuma wani zaɓi don amfani da alamar mai cikawa.
- A cikin sel na farko mun rubuta lamba "1". Yin amfani da alamar, yi kwafin abinda ke ciki zuwa dama. A wannan yanayin, sake maɓallin Ctrl babu buƙatar matsawa.
- Bayan an yi kwafin, mun ga cewa layin gaba ɗaya ya cika da lambar "1". Amma muna buƙatar lamba domin tsari. Mun danna kan gunkin da ya bayyana kusa da tantanin halitta na karshe da ya cika. Lissafin ayyuka ya bayyana. Saita canji zuwa wuri Cika.
Bayan wannan, duk ƙwayoyin da aka zaɓa za a cika su da lambobi don tsari.
Darasi: Yadda ake yin autocomplete a Excel
Hanyar 2: lamba ta amfani da maɓallin "Cika" akan kintinkiri
Wata hanyar lamba na lamba a cikin Microsoft Excel shine amfani da maballin Cika a kan tef.
- Bayan an ƙara layin don lambobin lamba, muna shigar da lamba a cikin sel na farko "1". Zaɓi duka layi na tebur. Kasancewa cikin shafin "Gidan", a kintinkiri danna maɓallin Cikalocated a cikin toshe kayan aiki "Gyara". Menuarin saukar menu yana bayyana. A ciki, zaɓi abu "Ci gaba ...".
- Window na ci gaba taga yana buɗewa. Duk sigogi a can yakamata a daidaita su ta atomatik kamar yadda muke buƙata. Koyaya, ba zai zama mafi girma ba don bincika yanayin su. A toshe "Wuri" dole sai an saita mai sauyawa zuwa Yayi layi-layi. A cikin siga "Nau'in" dole ne a zaɓi "Ilmin lissafi". Gano matakin Auto dole ne a kashe. Wannan shine, ba lallai bane cewa akwai alamar bincike kusa da sunan sigogi masu dacewa. A fagen "Mataki" duba cewa lambar tana "1". Filin "Iyakataccen darajar" dole ne komai. Idan wani siga bai dace da matsayin da aka bayyana a sama ba, sannan saita yadda aka bada shawara. Bayan kun tabbatar cewa dukkan sigogi sun cika daidai, danna maballin "Ok".
Biye da wannan, za a ƙidaya ginshiƙan tebur cikin tsari.
Ba za ku iya zaɓar koda layi ɗaya ba, amma kawai sanya lambobi a cikin tantanin farko "1". Sannan kira taga tsarin saurin ci gaba kamar yadda aka bayyana a sama. Dukkan sigogi dole ne su yi daidai da waɗanda muka ambata a baya, ban da filin "Iyakataccen darajar". Ya kamata ya sanya adadin ginshiƙai a cikin tebur. Saika danna maballin "Ok".
Za a cika. Zaɓin na ƙarshe yana da kyau ga tebur tare da adadi mai yawa na ginshiƙai, tunda lokacin da kake amfani da shi, ba kwa buƙatar jan siginar a ko'ina.
Hanyar 3: Aikin COLUMN
Hakanan zaka iya lambar lambobi ta amfani da aiki na musamman, wanda ake kira COLUMN.
- Zaɓi gidan da adadin ya kamata "1" a lamba Latsa maballin "Saka aikin"an sanya shi a hagu na dabarar dabara.
- Yana buɗewa Mayan fasalin. Ya ƙunshi jerin ayyukan Excel masu yawa. Muna neman suna SARAUTA, zaɓi shi kuma danna maballin "Ok".
- Farashin muhawara na aiki zai bude. A fagen Haɗi Dole ne a tantance hanyar haɗi zuwa kowane tantanin halitta a sashin farko na takardar. A wannan gaba, yana da matukar muhimmanci a kula sosai, musamman idan layin farko na teburin ba shine farkon shafi na takardar ba. Za'a iya shigar da adreshin hanyar haɗin da hannu. Amma yana da sauƙin yin haka ta saita siginan kwamfuta a cikin filin Haɗi, sannan danna danna wayar da ake so. Kamar yadda kake gani, bayan wannan, an nuna kwastomomin sa a fagen. Latsa maballin "Ok".
- Bayan waɗannan ayyuka, lamba tana bayyana a cikin tantanin da aka zaɓa "1". Don ƙidaya dukkan ginshiƙai, muna tsaye a cikin kusurwar dama ta dama kuma kiran alamar cika. Kamar dai yadda a cikin lokutan baya, ja shi zuwa dama daga ƙarshen tebur. Riƙe mabuɗin Ctrl babu buƙatar, kawai danna maɓallin linzamin kwamfuta na dama.
Bayan kammala duk matakan da ke sama, duk ginshiƙan tebur za a ƙidaya su.
Darasi: Wizard ɗin Aiki a cikin Excel
Kamar yadda kake gani, akwai hanyoyi da yawa don yin lissafin ginshiƙai a Excel. Mafi shahararrun waɗannan shine amfani da alamar cikawa. Yada tebur da yawa yayi ma'ana don amfani da maɓallin Cika tare da sauyawa zuwa saitunan ci gaba. Wannan hanyar ba ta unshi juya murfin ko'ina cikin jirgin saman takarda ba. Bugu da kari, akwai aiki na musamman. COLUMN. Amma saboda rikitarwa na amfani da basira, wannan zaɓi ba shi da mashahuri ko da a tsakanin manyan masu amfani. Ee, kuma wannan hanyar tana ɗaukar lokaci fiye da yadda aka saba amfani da mai alamar.
