Lambobin layi ta atomatik a cikin Excel. Hanyoyi 3 don saita lambar layi ta atomatik a cikin Excel

Lokacin aiki tare da tebur, ƙila ƙididdigewa ya zama dole. Yana tsarawa, yana ba ku damar kewayawa da sauri a cikinsa kuma bincika mahimman bayanai. Da farko, shirin ya riga ya sami lamba, amma a tsaye kuma ba za a iya canza shi ba. Ana ba da hanyar shigar da lamba da hannu, wanda ya dace, amma ba kamar yadda ake dogara ba, yana da wahala a yi amfani da shi lokacin aiki tare da manyan tebur. Saboda haka, a cikin wannan labarin, za mu dubi hanyoyi uku masu amfani da sauƙi don amfani don ƙididdige tebur a cikin Excel.

Hanyar 1: Lambobi Bayan Cika Layi na Farko

Wannan hanya ita ce mafi sauƙi kuma mafi yawan amfani da ita lokacin aiki tare da ƙananan tebur da matsakaici. Yana ɗaukar ɗan ƙaramin lokaci kuma yana ba da garantin kawar da kowane kurakurai a cikin lambar. Umarnin su na mataki-mataki sune kamar haka:

1. Da farko kana buƙatar ƙirƙirar ƙarin shafi a cikin tebur, wanda za a yi amfani da shi don ƙarin ƙididdigewa.
2. Da zarar an ƙirƙiri ginshiƙi, sanya lamba 1 a jere na farko, kuma sanya lamba 2 akan layi na biyu.

3. Zaɓi sel biyu da aka cika kuma ku shawagi a kan ƙananan kusurwar dama na yankin da aka zaɓa.
4. Da zaran gunkin giciye baƙar fata ya bayyana, riƙe LMB kuma ja yankin zuwa ƙarshen tebur.

Idan duk abin da aka yi daidai, to, shafi mai lamba za a cika ta atomatik. Wannan zai isa don cimma sakamakon da ake so.

Hanyar 2: Mai aiki "ROW".

Yanzu bari mu matsa zuwa hanyar ƙidayar lamba ta gaba, wacce ta ƙunshi amfani da aikin “STRING” na musamman:

1. Da farko, ƙirƙiri ginshiƙi don ƙidaya, idan babu ɗaya.
2. A cikin layin farko na wannan shafi, shigar da dabara mai zuwa: = ROW(A1).

3. Bayan shigar da tsarin, tabbatar da danna maɓallin "Enter", wanda ke kunna aikin, kuma za ku ga lamba 1.

4. Yanzu ya kasance, kamar hanyar farko, don matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na yankin da aka zaɓa, jira baƙar fata ya bayyana kuma ya shimfiɗa yankin zuwa ƙarshen teburin ku.
5. Idan an yi komai daidai, to ginshiƙi zai cika da lamba kuma ana iya amfani da shi don ƙarin dawo da bayanai.

Akwai madadin hanyar, ban da ƙayyadadden hanyar. Gaskiya ne, zai buƙaci amfani da tsarin "Aikin Wizard":

1. Hakazalika ƙirƙiri ginshiƙi don ƙidayawa.
2. Danna kan tantanin halitta na farko a jere na farko.
3. A saman kusa da sandar bincike, danna gunkin "fx".

4. An kunna "Wizard Aiki", wanda a ciki kuna buƙatar danna abu "Kategori" kuma zaɓi "References da Arrays".

5. Daga ayyukan da aka tsara, ya rage don zaɓar zaɓin "ROW".

6. Wani ƙarin taga don shigar da bayanai zai bayyana. Kuna buƙatar sanya siginan kwamfuta a cikin abu "Haɗi" kuma a cikin filin yana nuna adireshin tantanin halitta na farko na shafi mai lamba (a cikin yanayinmu, wannan shine darajar A1).

7. Godiya ga ayyukan da aka yi, lambar 1 za ta bayyana a cikin tantanin halitta na farko mara komai. Ya rage don amfani da ƙananan kusurwar dama na yankin da aka zaɓa kuma don ja shi zuwa dukan tebur.

Waɗannan ayyukan za su taimaka muku samun duk lambobi masu mahimmanci kuma su taimake ku don kada ku shagala da irin waɗannan abubuwa yayin aiki tare da tebur.

Hanyar 3: amfani da ci gaba

Wannan hanya ta bambanta da sauran ta wannan yana kawar da buƙatar masu amfani don amfani da alamar cikawa ta atomatik. Wannan tambaya tana da matukar dacewa, tunda amfani da shi ba shi da inganci yayin aiki tare da manyan tebura.

1. Muna ƙirƙira ginshiƙi don ƙidayawa kuma muna yiwa lamba 1 alama a cikin tantanin halitta na farko.

2. Za mu je kayan aiki kuma mu yi amfani da sashin "Gida", inda za mu je sashin "Editing" kuma mu nemi gunkin a cikin nau'i na kibiya na ƙasa (idan an yi shawagi, zai ba da sunan "Cika").

3. A cikin menu mai saukewa, kuna buƙatar amfani da aikin "Ci gaba".
4. A cikin taga da ya bayyana, yi haka:
   • yi alamar darajar "Ta ginshiƙai";
   • zaɓi nau'in lissafi;
   • a cikin filin "Mataki", yi alama lamba 1;
   • a cikin sakin layi na "Ƙimar Ƙimar" ya kamata ku lura da yawan layukan da kuka shirya don lamba.

5. Idan an yi komai daidai, to za ku ga sakamakon lambobi ta atomatik.

Akwai madadin hanyar yin wannan lambar, wanda yayi kama da haka:

1. Maimaita matakan don ƙirƙirar shafi kuma yi alama a cikin tantanin halitta na farko.
2. Zaɓi gabaɗayan kewayon tebur ɗin da kuke shirin ƙima.

3. Je zuwa sashin "Gida" kuma zaɓi sashin "Editing".
4. Muna neman abu "Cika" kuma zaɓi "ci gaba".
5. A cikin taga da ya bayyana, mun lura da irin wannan bayanan, kodayake yanzu ba mu cika abin "Ƙimar Ƙimar" ba.

6. Danna "Ok".

Wannan zaɓin ya fi duniya baki ɗaya, tunda baya buƙatar ƙidayar tilas na layukan da ke buƙatar ƙidaya. Gaskiya, a kowane hali, dole ne ka zaɓi kewayon da ake buƙatar ƙidaya.

Kula! Domin samun sauƙin zaɓar kewayon tebur da ke biye da lambobi, zaku iya zaɓar shafi kawai ta danna kan Excel. Sannan yi amfani da hanyar lamba ta uku kuma kwafi tebur zuwa sabon takarda. Wannan zai sauƙaƙa adadin manyan teburi.

Kammalawa

Ƙididdigar layi na iya sauƙaƙe aiki tare da tebur wanda ke buƙatar sabuntawa akai-akai ko yana buƙatar nemo bayanan da kuke buƙata. Godiya ga cikakken umarnin da ke sama, zaku iya zaɓar mafi kyawun mafita don aikin da ke hannunku.