Lissafin layi ta atomatik a cikin Excel: hanyoyi 3

Yayin aiki a cikin Excel, ba sabon abu ba ne don buƙatar lambobi a cikin wani shafi daban. Ana iya yin haka ta shigar da serial lambobi da hannu, a wasu kalmomi, ta hanyar buga su a madannai. Koyaya, lokacin aiki tare da babban adadin bayanai, shigar da lambobi da hannu ba hanya ce mai daɗi da sauri ba, wanda, ƙari kuma, ana iya yin kurakurai da buga rubutu. Abin farin ciki, Excel yana ba ku damar sarrafa wannan tsari, kuma a ƙasa za mu dubi yadda za a iya yin hakan ta hanyoyi daban-daban.

Hanyar 1: Lambobi Bayan Cika Layi na Farko

Wannan hanya ita ce watakila mafi sauki. Lokacin aiwatar da shi, kawai kuna buƙatar cika layuka biyu na farko na ginshiƙi, bayan haka zaku iya shimfiɗa lambobi zuwa sauran layuka. Duk da haka, yana da amfani kawai lokacin aiki tare da ƙananan tebur.

1. Na farko, ƙirƙiri sabon shafi don ƙididdige layi. A cikin tantanin halitta na farko (ba a kirga header) za mu rubuta lamba 1, sannan mu je na biyu, a cikinsa za mu shigar da lamba 2.
2. Yanzu kuna buƙatar zaɓar waɗannan sel guda biyu, bayan haka muna jujjuya siginan linzamin kwamfuta akan kusurwar dama ta ƙasan da aka zaɓa. Da zaran mai nuni ya canza kamanninsa zuwa giciye, riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa layin ƙarshe na ginshiƙi.
3. Mun saki maɓallin linzamin kwamfuta na hagu, kuma jerin lambobin layin za su bayyana nan da nan a cikin layin da muka rufe lokacin da muke miƙewa.

Hanya 2: STRING mai aiki

Wannan hanyar don ƙididdige layi ta atomatik ya ƙunshi amfani da aikin "LINE".

1. Mun tashi a cikin tantanin halitta na farko na ginshiƙi, wanda muke so mu sanya lambar serial 1. Sa'an nan kuma mu rubuta wannan tsari a ciki: =СТРОКА(A1).
2. Da zaran mun danna Shigar, serial number zai bayyana a cikin zaɓaɓɓen tantanin halitta. Ya rage, kama da hanyar farko, don shimfiɗa dabarar zuwa layin ƙasa. Amma yanzu kuna buƙatar matsar da siginan linzamin kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta tare da dabara.
3. Komai yana shirye, mun ƙididdige duk layuka na tebur ta atomatik, wanda aka buƙata.

Maimakon shigar da dabarar da hannu, zaku iya amfani da Mayen Aiki.

1. Muna kuma zaɓi tantanin halitta na farko na ginshiƙi inda muke son saka lambar. Sai mu danna maballin "Saka aikin" (zuwa hagu na mashayin dabara).
2. Tagan Wizard Aiki yana buɗewa. Danna kan rukunin ayyuka na yanzu kuma zaɓi daga lissafin da ke buɗewa "References da Arrays".
3. Yanzu, daga jerin masu aiki da aka tsara, zaɓi aikin "LINE", sannan latsa OK.
4. Wani taga zai bayyana akan allon tare da mahallin aiki don cikawa. Danna filin shigarwa don ma'auni "Layi" kuma saka adireshin tantanin halitta na farko a cikin ginshiƙi wanda muke son sanya lamba gare shi. Ana iya shigar da adireshin da hannu ko kawai danna kan tantanin halitta da ake so. Danna gaba OK.
5. Ana saka lambar jere a cikin tantanin halitta da aka zaɓa. Yadda za a shimfiɗa lamba zuwa sauran layin, mun tattauna a sama.

Hanyar 3: amfani da ci gaba

Ƙarƙashin hanyoyi na farko da na biyu shine cewa dole ne ka shimfiɗa lambobi zuwa wasu layi, wanda ba shi da matukar dacewa ga manyan masu girma dabam na tsaye. Don haka, bari mu dubi wata hanyar da za ta kawar da buƙatar yin irin wannan aikin.

1. Mun nuna a cikin tantanin halitta na farko na ginshiƙi lambar sa ta asali, daidai da lamba 1.
2. Canja zuwa shafin "Gida", danna maballin "Cika" (sashe "Editing") kuma a cikin jerin da ke buɗewa, danna kan zaɓi "Ci gaba...".
3. Wani taga zai bayyana a gabanmu tare da sigogin ci gaba waɗanda ke buƙatar daidaitawa, bayan haka muna danna OK.
   • zaɓi tsari "ta ginshiƙai";
   • saka nau'in "lissafi";
   • a cikin darajar mataki muna rubuta lambar "1";
   • a cikin filin "Ƙimar Ƙimar", nuna adadin layuka na tebur waɗanda ke buƙatar ƙidaya.
4. Ana yin lambobi ta atomatik, kuma mun sami sakamakon da ake so.

Ana iya aiwatar da wannan hanya ta wata hanya dabam.

1. Muna maimaita mataki na farko, watau Rubuta lamba 1 a cikin tantanin halitta na farko na ginshiƙi.
2. Muna zaɓar kewayon da ya ƙunshi duk sel waɗanda muke son saka lambobi a cikinsu.
3. Bude taga kuma "Ci gaba". Ana saita sigogi ta atomatik bisa ga kewayon da muka zaɓa, don haka dole ne mu danna OK.
4. Kuma sake, godiya ga waɗannan ayyuka masu sauƙi, muna samun lambobin layi a cikin kewayon da aka zaɓa.

Amfanin wannan hanyar shine ba buƙatar ƙidaya da rubuta adadin layukan da kuke son saka lambobi a ciki ba. Kuma rashin amfani shine, kamar yadda a cikin hanyoyi na farko da na biyu, dole ne ku zaɓi nau'in sel a gaba, wanda bai dace ba lokacin aiki tare da manyan tebur.

Kammalawa

Ƙididdigar layi na iya sauƙaƙe aiki a cikin Excel yayin aiki tare da adadi mai yawa na bayanai. Ana iya yin shi ta hanyoyi da yawa, kama daga cikawa na hannu zuwa cikakken tsari mai sarrafa kansa wanda zai kawar da duk wani kuskure da kuskure.