Yin aiki a Excel, wani lokaci ana iya fuskanci bukatun yin shinge layi a wurare. Akwai hanyoyi da dama da aka tabbatar da wannan. Wasu daga cikinsu suna yin motsi a zahiri a wasu maballin, yayin da wasu suna buƙatar adadin lokaci don wannan hanya. Abin takaici, ba duk masu amfani sun san duk waɗannan zaɓuɓɓuka ba, sabili da haka wani lokaci sukan yi amfani da hanyoyin da za a iya yi da sauri a wasu hanyoyi. Bari mu dubi hanyoyin da za a iya amfani da layi a cikin Excel.
Darasi: Yadda za'a sauke shafuka a cikin Microsoft Word
Canja matsayi na layin
Swap layi da dama zažužžukan. Wasu daga cikinsu suna ci gaba sosai, amma algorithm na wasu yafi fahimta.
Hanyar 1: Kwafi Cikin hanyar
Mafi hanyar da za a iya amfani da ita don shinge layi shine ƙirƙirar sabbin layi mara kyau tare da ƙara abun ciki na wani zuwa gare shi, sa'annan ta share tushen. Amma, kamar yadda za mu kafa daga bisani, ko da yake wannan zaɓi yana nuna kansa, yana da nisa daga zama mafi sauri kuma ba mafi sauki ba.
- Zaɓi kowane tantanin halitta a cikin jere, kai tsaye sama da abin da za mu karbi wani layi. Yi danna-dama. Yanayin mahallin farawa. Zaɓi abu a ciki "Manna ...".
- A cikin bude kananan taga, wanda ya ba da damar zaɓar abin da za a saka, matsar da canjin zuwa matsayi "Iri". Danna maballin "Ok".
- Bayan waɗannan ayyukan, an ƙara jadawalin komai. Yanzu zaɓar layin layin da muke so a tada. Kuma wannan lokaci yana bukatar a rarraba shi gaba daya. Muna danna maɓallin "Kwafi"tab "Gida" a kan takalma mai tushe a cikin toshe "Rubutun allo". Maimakon haka, zaka iya rubuta haɗin maɓallan makullin Ctrl + C.
- Sanya siginan kwamfuta a cikin hagu na hagu na jere maras kyau wanda aka kara da shi a baya, kuma danna maballin Mannatab "Gida" a cikin saitunan "Rubutun allo". A madadin, yana yiwuwa a rubuta maɓallin haɗin Ctrl + V.
- Bayan an saka jere, dole ne ka share layin farko don kammala aikin. Danna kan kowane tantanin wannan layi tare da maɓallin linzamin linzamin dama. A cikin mahallin menu wanda ya bayyana bayan wannan, zaɓi abu "Share ...".
- Kamar yadda yake a cikin ƙara layi, ƙananan taga yana buɗewa wanda ke sa ka zabi abin da kake so ka share. Yi sake canzawa a cikin matsayi a gaban wancan abu "Iri". Muna danna maɓallin "Ok".
Bayan wadannan matakai, za a share abun da ba dole ba. Saboda haka, za a gudanar da jigilar layuka.
Hanyar 2: hanyar shigarwa
Kamar yadda kake gani, hanya don maye gurbin kirtani tare da wurare a cikin hanyar da aka bayyana a sama yana da rikitarwa. Tsarinta zai buƙaci lokaci mai yawa. Half matsala idan kana buƙatar tsayar da layuka guda biyu, amma idan kana son swap a dozin ko fiye? A wannan yanayin, hanyar sauƙi da sauri zai zo wurin ceto.
- Hagu hagu a kan lambar layi a kan rukunin daidaitawa ta tsaye. Bayan wannan aikin, ana nuna dukkanin jerin. Sa'an nan kuma danna maballin. "Yanke"wanda aka gano akan rubutun a cikin shafin "Gida" a cikin asalin kayan aiki "Rubutun allo". Ana nuna hotunan hoto a cikin nau'i na almakashi.
- Ta danna maɓallin linzamin linzamin maɓallin linzamin kwamfuta a kan kwamiti mai kulawa, zaɓi layin da ke sama wanda ya kamata mu sanya layi na baya a cikin takardar. Je zuwa menu na mahallin, dakatar da zaɓi a kan abu "Saka Yanke Yanke".
- Bayan wadannan ayyukan, za'a sake saitin layi zuwa wurin da aka kayyade.
Kamar yadda kake gani, wannan hanya ya haɗa da yin wasu ayyuka fiye da na baya, wanda ke nufin za ka iya ajiye lokaci tare da shi.
Hanyar 3: motsa linzamin kwamfuta
Amma akwai sauƙin tafiwar sauri fiye da hanyar da ta gabata. Ya haɗa da jawo layi ta yin amfani da linzamin kwamfuta da keyboard kawai, amma ba tare da amfani da menu mahallin ko kayayyakin aiki a kan rubutun ba.
- Zaži ta danna maɓallin linzamin hagu na mashigin a kan kwamiti mai kula da layin da muke son motsawa.
- Matsar da siginan kwamfuta zuwa iyaka na sama na wannan layin har sai ya ɗauki siffar kibiya, a ƙarshen akwai alamomi huɗu waɗanda aka jagoranci a wurare daban-daban. Muna riƙe da maɓallin Shift a kan maballin kuma danna jigon zuwa wurin da muke so an samo shi.
Kamar yadda kake gani, motsi yana da sauƙi kuma layin ya zama daidai inda mai amfani yake so ya shigar da ita. Don yin wannan, kawai kuna buƙatar yin aikin tare da linzamin kwamfuta.
Akwai hanyoyi da yawa don satar kirtani a Excel. Wanne daga cikin zaɓuɓɓukan da za a yi amfani da su don amfani ya dogara ne akan abubuwan da aka zaɓa na mai amfani. Ɗaya daga cikin mafi dacewa kuma yafi saba da tsohuwar hanya don motsa motsi, yin aiki na kwashewa da kuma kawar da layuka, yayin da wasu sun fi son hanyoyin da suka cigaba. Kowace zaɓin zaɓin da kaina don kansu, amma, ba shakka, zamu iya cewa hanyar da ta fi gaggawa don shinge layi shine zaɓi na overtightening tare da linzamin kwamfuta.
