Yadda ake motsa layuka a cikin Excel. Kunna layi a cikin Excel - hanyoyi 3

Daga lokaci zuwa lokaci, lokacin aiki tare da maƙunsar bayanai, ya zama dole don canza matsayi na layuka da yawa dangane da juna. Misali, akwai yanayin da aka shigar da bayanan da mai amfani ya kayyade ba da gangan ba a cikin tantanin halitta da bai dace ba, kuma ana buƙatar dawo da madaidaicin jerin layuka. Babu buƙatar sake shigar da wannan bayanin, kawai kuna buƙatar musanya layuka. A yau za mu yi nazarin hanyoyin da yawa kamar uku na yadda za a yi haka, da kuma bayyana duk fa'idodi da rashin amfaninsu.

Yadda ake Kunna Layuka a cikin Teburin Excel

Menene waɗannan hanyoyin sihiri? Akwai manyan hanyoyi guda uku don musanya layuka a cikin takaddar Excel:

1. Amfani da daidaitaccen kayan aikin kwafin-manna.
2. Yin amfani da linzamin kwamfuta don nada layi.

Za mu raba hanya ta farko gida biyu, domin kowanne daga cikinsu yana da nasa takamaiman.

Hanyar 1. Amfani da linzamin kwamfuta

Wannan yana ɗaya daga cikin hanyoyin da suka fi dacewa. Babban fa'idarsa shine saurin wannan aikin. Duk abin da kuke buƙata don kunsa layi shine linzamin kwamfuta da madannai. Bari mu dubi abin da ya kamata a yi:

1. Matsar da siginan kwamfuta zuwa sandar daidaitawa. A can muna aiwatar da linzamin kwamfuta na hagu danna kan layin da muke buƙatar motsawa.
2. Bayan haka, matsar da siginan kwamfuta zuwa saman iyakar kowane ɗayan sel waɗanda ke cikin wannan jeri. Muhimmiyar sanarwa: kafin aiwatar da aiki na gaba, dole ne ka tabbatar cewa siginan kwamfuta ya ɗauki nau'in kibiya mai nuni a wurare huɗu daban-daban.
3. Bayan haka, danna maɓallin Shift akan madannai kuma ka riƙe shi ƙasa. Bayan haka, muna matsar da wannan layi zuwa wuri mai dacewa. Hakanan dole ne a riƙe maɓallin linzamin kwamfuta a wannan lokacin. Ana buƙatar maɓallin Shift don kada a maye gurbin bayanai. Idan ka matsar da layin da linzamin kwamfuta kawai, ba tare da amfani da maballin ba, to za a sauya bayanan kawai, kuma za ku sake jujjuya komai don kada ku rasa bayanai.

Mun ga cewa wannan hanya mai sauƙi ne kuma mai sauƙi. Babban abu shine tuna cewa kuna buƙatar matsar da layin yayin riƙe maɓallin Shift.

Hanyar 2. Ta hanyar sakawa

Idan aka kwatanta da hanyar da ta biyo baya, wanda za mu bayyana, wannan hanya tana da babban adadin abũbuwan amfãni. Yana ba ku damar canza tsarin layi tare da ƙaramin lokaci da ƙoƙari. Bari mu ba da misali na gaske na yadda ake aiki da wannan hanya.

1. Nemo lambar layin da muke buƙatar matsawa akan mashaya mai daidaitawa kuma danna kan shi. Bayan haka, an zaɓi duka layin. Na gaba, muna neman toshe "Clipboard" a cikin ribbon, wanda muke neman maɓallin "Yanke". Toshe kanta yana nan da nan a gefen hagu na tef ɗin. Bugu da ƙari, zaɓi mai kyau shine amfani da menu na mahallin. Don yin wannan, danna-dama akan layin da ya dace kuma sami abu "Yanke". Hakanan zaka iya amfani da gajeriyar hanyar keyboard Ctrl + X.
2. Bayan haka, kuna buƙatar danna-dama akan layin da ke ƙarƙashin wurin da kuke son saka layin yanke. Bayan haka, a cikin menu da ya bayyana, zaɓi abu "Saka yanke sel".
3. Bayan kammala waɗannan matakan, layin zai matsa kai tsaye zuwa wurin da ya dace. A lokaci guda, ba a ga canje-canje a cikin jerin sauran layuka ba.

Wannan hanya ta sa ya yiwu a nade layi a cikin matakai uku kawai. PDuk da haka, wannan hanya tana da hankali fiye da na baya, tun da yake wajibi ne don kaddamar da menu na mahallin, bincika kayan aikin da suka dace a ciki, da kuma a kan kintinkiri. Amma idan aka kwatanta da hanya mai zuwa, wannan yana da sauri sosai. Bari mu matsa zuwa hanyar da ta fi ɗaukar lokaci, amma ya kamata har yanzu ƙwararren mai amfani da Excel ya san shi.

Hanyar 3. Ta hanyar kwafi

Wannan hanyar tana kama da wacce ta gabata, amma tana buƙatar mai amfani ya yi wasu ƙarin matakai. Wannan hanyar tana nuna buƙatar ƙirƙirar ƙarin layi ba tare da wani bayani ba, sannan kwafi bayanai daga ainihin layin a ciki, sannan a cire kwafi. Bari mu ga a aikace yadda ake yin haka.

1. Wajibi ne a zaɓi tantanin halitta a jere a ƙarƙashin wanda muke son saka bayanai. Yi danna dama kuma menu na mahallin ya bayyana. A ciki, zaɓi abu "Saka".
2. Bayan haka, ƙaramin taga zai buɗe inda kake buƙatar zaɓar abu "layi". Muna tabbatar da ayyukanmu.
3. Bayan haka, ƙarin layin zai bayyana, wanda yanzu muna buƙatar zaɓar layin da muke buƙatar canjawa zuwa sabon halitta.
4. Dama danna shi kuma kwafi. Hakanan zaka iya amfani da kayan aiki daidai akan ribbon ko danna maɓallin Ctrl + C. Mai amfani zai iya zaɓar hanyar da ta fi dacewa da shi.
5. Bayan haka, danna kan tantanin halitta na farko a cikin sabon layin da aka ƙirƙira kuma danna “Manna” ko kuma kuna iya amfani da haɗin maɓalli Ctrl + V.
6. Mataki na gaba shine cire kwafi. Don yin wannan, danna-dama tantanin halitta daga jere na asali kuma zaɓi abu "Share" a cikin jerin ayyukan da ya bayyana. Hakazalika, taga zai bayyana inda muke buƙatar zaɓar abin "layi" kuma tabbatar da ayyukanmu.

A sakamakon haka, layinmu ya koma daga wannan wuri zuwa wani. Kamar yadda kake gani, wannan abu yana buƙatar ƙarin adadin ayyuka masu yawa. Bai dace sosai don matsar da manyan layuka ba. Hakanan ana iya yin kuskure, saboda a aikace yana da sauƙin mantawa don share tsohon layi.

Lokacin da zaku buƙaci kunsa layuka a cikin Excel

Akwai yanayi da yawa lokacin da zaku buƙaci kunsa layuka a cikin Excel. Misali, tsarin da aka jera kaya yana taka rawa. Ko mai amfani yana son ba da fifiko ga wasu bayanai. Misali, mutane da yawa suna rubuta shirye-shiryensu na yau da kullun a cikin Excel kuma suna tsara abubuwa ta wannan hanyar, suna aika na farko zuwa sama, da waɗanda zasu iya jira zuwa ƙasa. Ko menene dalilin son koyon rubutun layi daga gare ku, yanzu kun riga kun san yadda ake yin shi. Ƙananan horo, kuma za ku iya amfani da ilimin ku a aikace. Sa'a.