Layin ƙarshen-zuwa ƙarshen shine bayanan bayanan abin da aka nuna yayin da aka buga takaddun akan zanen gado daban-daban a wuri guda. Yana da dacewa musamman don amfani da wannan kayan aiki lokacin cika sunayen tebur da shugabanninsu. Hakanan za'a iya amfani dashi don wasu dalilai. Bari mu bincika yadda zaku iya tsara irin waɗannan bayanan a cikin Microsoft Excel.
Yi amfani da layin ƙarshe
Don ƙirƙirar layi ta hanyar da za'a nuna akan duk shafukan daftarin aiki, kuna buƙatar yin wasu jan hankali.
- Je zuwa shafin Tsarin shafin. A kan kintinkiri a cikin akwatin kayan aiki Saitunan Shafi danna maballin Buga Shugaban.
- Zaɓuɓɓukan window yana buɗewa. Je zuwa shafin Sheetidan taga ya bude a wani shafin. A cikin toshe saitin "Buga a kowane shafi" sanya siginan kwamfuta a cikin filin Layin ƙarshen-zuwa-ƙarshen.
- Kawai zaɓi ɗaya ko sama akan layin da kuke son yin ƙarewa zuwa ƙarshen. Ya kamata a tsara masu tsara su a filin daga sigogi na taga. Latsa maballin "Ok".
Hankali! Idan a halin yanzu kana tantance tantanin halitta, wannan maɓallin ba zai yi aiki ba. Saboda haka, fita yanayin gyara. Hakanan, bazai yi aiki ba idan ba'a shigar da injin kan kwamfutar ba.
Yanzu bayanan da aka shigar a cikin yankin da aka zaɓa kuma za a nuna su a wasu shafuka lokacin buga takaddar, wanda zai iya adana lokaci mai yawa idan aka kwatanta da ɗaya kamar in ka rubuta kuma ka sanya (sanya) mahimman bayanan rikodin akan kowane takarda na ɗab'in bugun hannu da hannu.
Don ganin yadda takaddar zata kaya yayin da aka aikawa firinta, je zuwa shafin Fayiloli kuma matsa zuwa sashin "Buga". A ɓangaren dama na taga, gungura ƙasa daftarin aiki, muna ganin yadda aka kammala aikin cikin nasara, wato, shin an nuna bayani daga layin ƙarshen-ƙarshen ƙarshen duk shafuka.
Hakanan, zaku iya saita ba kawai layuka ba, har ma ginshiƙai. Kawai a wannan yanayin, ana buƙatar shigar da masu gudanarwar a fagen Ta hanyar Lissafi a cikin taga za optionsu window pageukan taga.
Wannan algorithm na ayyuka ya dace da sigogin Microsoft Excel 2007, 2010, 2013 da 2016. Tsarin da ke cikin su daidai yake.
Kamar yadda kake gani, shirin na Excel yana ba da ikon daidaita layin ƙarshen-ƙarshen-littafi a cikin littafi. Wannan zai ba ku damar nuna alamun kwafi a shafuka daban-daban na takaddar, rubuta su sau ɗaya kawai, wanda zai adana lokaci da ƙoƙari.
