Lokacin aiki a cikin kyakkyawan shirin, yana da sau da yawa ana zama dole don ƙara sabbin layi a cikin tebur. Amma, abin takaici, wasu masu amfani ba su san yadda za su iya ko da irin waɗannan abubuwa masu sauƙi ba. Gaskiya ne, ya kamata a lura cewa wannan aikin yana da wasu "posfalls". Bari mu gano yadda ake saka kirtani a Microsoft Excel.
Saka kirtani tsakanin layuka
Ya kamata a lura cewa shigarwar sabon layin a sigogin zamani na shirye-shiryen Excelince na aiki ba da bambanci daga juna.
Don haka, buɗe tebur wanda kuke buƙatar ƙara kirtani. Don saka kirtani tsakanin layin ta danna maɓallin linzamin kwamfuta na dama tare da kowane layin da muke shirin saka sabon abu. A cikin menu na mahallin mahallin wanda ya buɗe, danna don "manna ...".
Hakanan, akwai yiwuwar saka ba tare da kiran menu ba. Don yin wannan, kawai danna maballin maɓallin maɓallin "Ctr +".
Akwatin maganganu yana buɗe, wanda ke ba mu shigar da mu a teburin tantanin halitta tare da juyawa, sel, da kirtani. Mun kafa canzawa zuwa matsayin "kirtani", kuma danna maɓallin "Ok".
Kamar yadda kake gani, ana samun sabon layin a cikin shirin Microsoft Excel ya kara da nasara.
Sanya kirtani a ƙarshen tebur
Amma abin da za a yi idan kuna buƙatar saka sel ba tsakanin layi ba, amma ƙara kirtani a ƙarshen tebur? Bayan haka, idan kuna amfani da hanyar da ke sama, ba za a haɗa layin da aka ƙara aikin a teburin ba, amma zai kasance a waje da iyakokinta.
Don haɓaka tebur da ƙasa, zaɓi maɓallin ƙarshe na teburin. A cikin ƙananan ƙananan kusurwa, an kafa giciye. Na cire shi a kan layi da yawa kamar yadda muke bukatar mu mika tebur.
Amma, kamar yadda muke gani, an samar da duk ƙananan ƙwayoyin tare da bayanan da aka cika daga ɗakin mahaifiyar. Don cire wannan bayanan, zaɓi sabon sel da aka kafa, sai ka danna maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin wanda ya bayyana, zaɓi abun ciki "Share abun ciki".
Kamar yadda kake gani, an tsabtace sel, kuma shirye don cika bayanan.
Wajibi ne a yi la'akari da cewa wannan hanyar ta dace kawai idan babu wani layin ƙasa na sakamako a cikin tebur.
Irƙirar Tebur mai hankali
Amma, mafi dacewa don ƙirƙirar, abin da ake kira, "Smart Tebur". Ana iya yin wannan sau ɗaya, sannan kada ku damu cewa irin layin lokacin da ƙari baya shiga iyakokin tebur. Wannan tebur zai miƙa, kuma ban da, duk bayanai sun ba da gudummawa ga hakan ba zai faɗi ba daga tsarin da ake amfani da su a cikin tebur, a kan takardar a cikin littafin gaba ɗaya.
Don haka, don ƙirƙirar "tebur mai wayo", muna ware duk ƙwayoyin da yakamata shigar da shi. A cikin gida shafin, danna kan tsarin "azaman tebur". A cikin jerin abubuwan da kuka samu, za mu zabi salon da kayi yadda kuka fi so. Don ƙirƙirar "tebur mai wayo", zaɓi na wani salo ba matsala.
Bayan salon an zaɓi, akwatin maganganun yana buɗewa, wanda kewayen sel aka zaɓa, don haka ba kwa buƙatar yin gyare-gyare. Kawai danna maɓallin "Ok".
"Smart Tebur" ya shirya.
Yanzu, don ƙara kirtani, danna kan tantanin hannu wanda za a ƙirƙira. A cikin menu na mahallin, zaɓi layin "Sanya layin tebur da ke sama" abu.
An kara kirtani.
Za'a iya ƙara kirtani tsakanin layuka ta hanyar danna maɓallin "Ctry +". Ba lallai ne in shigar da wani abu ba wannan lokacin.
Sanya kirtani a ƙarshen Tebur ɗin ta cikin hanyoyi da yawa.
Kuna iya tashi a kwayar halitta ta ƙarshe na layin ƙarshe, kuma danna maɓallin maɓallin Tabe (shafin).
Hakanan, zaku iya tashi siginan kwamfuta zuwa dama na dama na kwayar ƙarshe na kwayar halitta ta ƙarshe, kuma cire shi.
A wannan karon, sabbin sel za a cika tare da komai a baya, kuma ba za a buƙace su daga bayanai ba.
Kuma zaku iya shigar da kowane bayanai a ƙarƙashin jere a ƙasa tebur, kuma za a haɗa ta atomatik a cikin tebur.
Kamar yadda kake gani, ƙara sel a teburin a cikin shirin Microsoft Excel zai iya kasancewa cikin hanyoyi daban-daban, amma saboda babu matsaloli tare da ƙara, kafin haka, ya fi dacewa a ƙirƙiri "tebur mai wayo" ta amfani da tsarawa.