Lokacin aiki a cikin Excel, wani lokacin zaku iya haɗuwa da buƙatar musanya layin. Akwai hanyoyin da yawa da aka tabbatar da wannan. Wasu daga cikinsu suna motsa zahiri a cikin wasu danna biyu, yayin da wasu suna buƙatar lokaci mai yawa don wannan aikin. Abun takaici, ba duk masu amfani bane suka saba da duk waɗannan zaɓuɓɓukan, sabili da haka wasu lokuta suna ciyar da lokaci mai yawa akan waɗancan hanyoyin da za'a iya aiwatar da sauri sosai a wasu hanyoyi. Bari mu bincika zaɓuɓɓuka da yawa don layin musanyawa a cikin Excel.
Darasi: Yadda ake canza shafuka a cikin Microsoft Word
Canja matsayin layin
Kuna iya musanya layuka tare da zaɓuɓɓuka da yawa. Wasu daga cikinsu sun fi ci gaba, amma hanyoyin wasu sun fi kwarewa.
Hanyar 1: hanyar kwafi
Hanya mafi fahimta da za a canza layin ita ce samar da sabon layi mara komai tare da abinda wani ya kara da shi, sannan a goge asalin. Amma, kamar yadda muke kafawa daga baya, duk da cewa wannan zaɓi yana nuna kansa, yana da nisa da mafi sauri kuma ba mafi sauƙi ba.
- Zabi kowane sel a cikin layin, kai tsaye sama wanda zamu hau zuwa sama. Yi danna maɓallin dama. Yanayin mahallin yana farawa. Zaɓi abu a ciki "Manna ...".
- A cikin karamin taga da ke buɗe, wanda ke ba da shawarar zaɓin abin da za a saka, matsar da sauyawa zuwa matsayi "Layi". Latsa maballin "Ok".
- Bayan waɗannan matakan, an ƙara layin mara lahani. Yanzu zaɓi layin teburin da muke so mu ɗaga. Kuma wannan lokacin, kuna buƙatar gabaɗa shi. Latsa maballin Kwafalocated a cikin shafin "Gida" a kan bel na kayan aiki a cikin toshe Clipboard. Madadin haka, zaku iya rubuta hadewar hotkey Ctrl + C.
- Mun sanya siginan kwamfuta a cikin ƙananan hagu na layin komai wanda aka ƙara a farkon, kuma danna maɓallin Mannalocated a cikin shafin "Gida" a cikin rukunin saiti Clipboard. A madadin haka, zaku iya buga kayan hade Ctrl + V.
- Bayan an saka layin, don kammala aikin kana buƙatar share sashin farko. Mun danna kowane sel na wannan layin tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da ke bayyana bayan hakan, zaɓi "Share ...".
- Kamar yadda yake game da ƙara layin, ƙaramin taga yana buɗe wanda ke ba da damar zaɓar abin da ake buƙatar cirewa. Muna juyawa canjin zuwa matsayin gaban kishiyar abu "Layi". Latsa maballin "Ok".
Bayan waɗannan matakan, za a share abu mara amfani. Ta haka, za a yi sauyawa a jere.
Hanyar 2: saka hanyar
Kamar yadda kake gani, hanya don sauya kirtani tare da wurare a hanyar da aka bayyana a sama tana da rikitarwa. Aiwatarwarsa na buƙatar lokaci mai ƙima. Rabin matsalar, idan kuna buƙatar musanya layuka biyu, amma idan kuna son musanya da dama ko fiye da layin? A wannan yanayin, hanya mafi sauƙi da sauri za ta zo don ceto.
- Na hagu-danna lambar layin a tsaye a kwamiti na tsaye. Bayan wannan matakin, an fifita dukkan layin. Saika danna maballin Yanke, wanda aka ƙulla shi akan kintinkiri a cikin shafin "Gida" a cikin akwatin kayan aiki Clipboard. An wakilta ta almakashi icon.
- Ta danna maɓallin linzamin kwamfuta na dama akan allon hadin kai, zaɓi layin sama wanda ya kamata a sanya layin ɗin da ya gabata. Je zuwa menu na mahallin, dakatar da zaɓi akan abu Manna Cututtuka.
- Bayan waɗannan ayyuka, za a sake layin layin da yake a inda yake.
Kamar yadda kake gani, wannan hanyar ta hada da yin wasu ayyuka kadan fiye da na baya, wanda ke nufin zaku iya ajiye lokaci tare da taimakon sa.
Hanyar 3: matsar da linzamin kwamfuta
Amma akwai kuma zaɓi mafi sauri don motsawa fiye da hanyar da ta gabata. Ya ƙunshi jan da saukar da kirtani ta amfani kawai da linzamin kwamfuta da kuma keyboard, amma ba tare da amfani da mahallin mahallin ko kayan aikin akan kintinkiri ba.
- Zaɓi ɓangaren tare da maɓallin linzamin kwamfuta na hagu a kan kwamiti na daidaiton layin da muke son motsawa.
- Muna motsa siginan kwamfuta zuwa iyakar babba na wannan layin har sai ya ɗauki siffar kibiya, a ƙarshen abin da ya yi nuni daga fayiloli huɗu a cikin fuskoki daban-daban. Mun riƙe maɓallin ftaura a kan maɓallin kuma kawai ja layi zuwa wurin da muke son kasancewa.
Kamar yadda kake gani, motsi abu ne mai sauki kuma layin yayi daidai a inda mai amfani yake son sanya shi. Don yin wannan, kawai kuna buƙatar aiwatar da aiki tare da linzamin kwamfuta.
Akwai hanyoyi da yawa don musanya layin a Excel. Wanne daga zaɓuɓɓukan da aka gabatar don amfani da su ya dogara da fifiko na mai amfani. Daya ne mafi dacewa kuma mafi masaniya a cikin tsohuwar hanyar kera don motsawa, aiwatar da aikin kwafa da cire cire layuka, yayin da wasu suka fi son hanyoyin ci gaba. Kowane mutum na zaɓin zaɓi da kansu, amma, ba shakka, zamu iya cewa hanya mafi sauri don musanya layin itace zaɓi na jan tare da linzamin kwamfuta.
