Yawan atomatik na kirtani a Excel. Hanyoyi 3 don saita lambar atomatik na layuka a fice

Lokacin aiki tare da tebur, ana iya buƙatar lamba. Yana tsara, ba ku damar sauri kewaya kuma bincika mahimman bayanan. Da farko, shirin tuni yana da lamba, amma ba za a iya canzawa ba. An yi amfani da shi da hannu shigar da adadin da ya dace, amma ba abin dogara ba, yana da wuya a yi amfani da shi lokacin aiki tare da manyan tebur. Saboda haka, a cikin wannan kayan za mu kalli hanyoyi masu amfani da sau uku da sauƙi a cikin fice.

Hanyar 1: lamba bayan cika layuka na farko

Wannan hanyar shine mafi sauki kuma mafi yawan amfani yayin aiki tare da ƙananan tebur da matsakaici. Yana ɗaukar mafi ƙarancin lokaci kuma yana ba da tabbacin duk wani kurakurai cikin lamba. Mataki-mataki Umarnin da suke kama da wannan:

1. Da farko kuna son ƙirƙirar shafin zaɓi na zaɓi a cikin tebur da za a tsara don ƙarin lamba.
2. Da zaran an ƙirƙiri shafi, a layin farko, sanya lamba 1 a cikin na biyu, kuma a layin na biyu, sanya lambar 2.

Ƙirƙiri shafi kuma cika sel

1. Select da aka cika biyu da aka cika da kuma tsayawa a saman ƙananan kusurwar yankin da aka zaɓa.
2. Da zaran gunkin Black giciye ya bayyana, riƙe lkm da shimfiɗa yankin zuwa ƙarshen tebur.

Shimfiɗa lamba akan duka kewayon tebur

Idan an yi komai daidai, za a cika shafi lamba ta atomatik. Wannan zai isa ya cimma sakamakon da ake so.

Sakamakon aikin da aka yi

Hanyar 2: Strack Stord

Yanzu muna zuwa hanyar da ta gaba ta lamba, wanda ke nuna amfani da aikin "kirtani":

1. Da farko, ya kamata ka kirkiri shafi na lamba, idan babu kowa.
2. A cikin kirtani na farko na wannan shafi, shigar da dabara na abun ciki: = layi (A1).

Mun gabatar da dabara a cikin tantanin halitta

1. Bayan shigar da dabara, tabbatar da danna maɓallin "Shigar", wanda ke kunna aikin, kuma zaku ga hoton 1.

Cika tantanin halitta da shimfiɗa adadin

1. Yanzu ya kasance kama da na farko hanyar kawo siginan siginar zuwa dama na zaɓaɓɓen kusurwa na zaɓaɓɓen yankin da aka zaɓa, jira na Black giciye da shimfiɗa yankin zuwa ƙarshen teburinku.
2. Idan komai yayi daidai, shafi zai cika da lamba kuma ana iya amfani dashi don kara bincike don bayani.

Mun kiyasta sakamakon

Akwai wani hanyar daban, ban da hanyar da aka ayyana. Gaskiya ne, zai zama dole don amfani da "Ayyukan Jagora" Module:

1. Hakanan, ƙirƙiri shafi na lamba.
2. Danna kan tantanin farko na layin farko.
3. Daga sama kusa da wurin binciken danna danna kan "FX" icon.

Kunna "Jagora na Ayyuka"

1. An kunna "Master Autum", wanda kuke buƙatar danna maɓallin "Kategory" kuma zaɓi "Haɗin da kuma Arrays".

Zabi mahimman sassan

1. Daga ayyukan da aka gabatar, zaku zaɓi zaɓin "layin".

Yi amfani da aikin "kirtani"

1. Ƙarin taga zai bayyana don shigar da bayanai. Kuna buƙatar sanya siginan kwamfuta zuwa "Magana" kuma a cikin Saka da adireshin tantanin halitta na farko na shafi (a cikin mu ne1).

Cika bayanan da ake buƙata

1. Godiya ga ayyukan da aka yi a cikin sel na farko na farko, lambar ta bayyana. 1. Ya sake yin amfani da ƙananan kusurwar dama ta zaɓaɓɓu na yankin da aka zaɓa don shimfiɗa zuwa duka tebur.

Shimfiɗa aikin ga duka kewayon tebur

Wadannan ayyukan zasu taimaka wajen samun duk adadin da ya wajaba kuma zasu taimaka wajen ba da irin wannan trifles yayin aiki tare da tebur.

Hanyar 3: Aikace-aikacen ci gaba

Kuma wannan hanyar ta bambanta da sauran abubuwan da ke kawar da masu amfani daga buƙatar amfani da alamar atomatik. Wannan tambaya tana da matukar dacewa, tunda aikace-aikacen sa ba shi da amfani lokacin aiki tare da manyan tebur.

1. Airƙiri shafi na lamba da bayanin kula a cikin lambar farko 1.

Yi ainihin ayyuka

1. Je zuwa kayan aiki da amfani da sashin "Gida", inda muke zuwa zuwa maɓallin "Gyara" kuma muna neman alamar kibiya ƙasa (lokacin da kuka haye wajan "cika").

Je zuwa aikin "ci gaba"

1. A cikin menu na saukarwa kuna buƙatar amfani da "aikin ci gaba".
2. A cikin taga wanda ya bayyana, ya kamata a yi masu zuwa:

Cika bayanan da suka dace

1. Idan an yi komai daidai, zaku ga sakamakon atomatik.

Sakamakon da aka samu

Akwai wata hanyar da za a yi don yin irin wannan adadin da ke kama da wannan:

1. Muna maimaita ayyukan don ƙirƙirar shafi da alama a cikin tantanin farko.
2. Mun rarraba duk kewayen tebur da kuke shirin ƙidaya.

Muna murnar gaba daya kewayon tebur

1. Je zuwa sashen "gida" ka zaɓi sashin "Gyara".
2. Muna neman abun "cika" kuma za mu zabi "ci gaba".
3. A cikin taga da ta bayyana, mun lura da irin wannan bayanan, gaskiyar ba ta cika a cikin abun "iyaka ma'anar".

Cika bayanai a cikin taga daban

1. Latsa "Ok".

Wannan zabin ya fi dacewa da tsari, tunda baya buƙatar ƙididdigar wajibi na layuka da ke buƙatar lambobi. Gaskiya ne, a kowane hali dole ne ka ware kewayon da dole ne a ƙidaya.

Sakamakon shirye

Ƙarshe

Layi lamba iya sauƙaƙan aiki tare da tebur wanda ke buƙatar sabuntawa ko bincika bayanan da ake so. Saboda cikakken bayanin da aka ayyana a sama, zaku iya zabi mafi kyawun bayani don warware aikin.

Sako ta atomatik yawan kirtani a Excel. Hanyoyi 3 don saita kirga lambar atomatik a cikin fifita fice da farko akan fasahar bayanai.