Don wasu dalilai, masu amfani suna buƙatar ajiye taken tebur koyaushe a gaban idonsu, koda kuwa takaddar ta gangara ƙasa. Bugu da kari, sau da yawa ana buƙatar cewa lokacin buga takarda akan matsakaici na zahiri (takarda), ana nuna kan teburin akan kowane shafi. Bari mu gano a cikin waɗanne hanyoyi zaka iya sa taken a Microsoft Excel.
Matsa fil a layin sama
Idan taken teburin yana kan layi mai tsayi, kuma shi kansa ya mallaki sama da jere ɗaya, to gyara shi aikin farat ne. Idan akwai layin guda daya ko daya a saman taken, to za a buƙaci a cire su don amfani da wannan zaɓi na pinning.
Domin daskare taken, kasancewa a cikin shafin "Duba" na Excel, danna maɓallin "yankan yankunan". Wannan maɓallin yana kan kintinkiri a cikin kayan aikin Window. Na gaba, cikin jerin da ke buɗe, zaɓi matsayin "Daskare kan layi na sama".
Bayan haka, taken da ke saman layin za a daidaita shi, kasance tare da shi a tsakanin iyakokin allon.
Daskare yankin
Idan saboda wasu dalilai mai amfani ba ya son share tsoffin ƙwayoyin da ke saman taken, ko kuma idan ta ƙunshi sama da layi ɗaya, to wannan hanyar da ke sama ba za ta yi aiki ba. Dole ne ku yi amfani da zaɓi tare da gyara yankin, wanda, duk da haka, ba shi da rikitarwa fiye da hanyar farko.
Da farko dai, mun matsa zuwa shafin "Duba". Bayan haka, danna kan ƙananan hagu a ƙarƙashin taken. Bayan haka, zamu danna maballin "yankunan da suke daskarewa", wanda aka ambata a sama. Bayan haka, a cikin menu ɗin da aka sabunta, sake zaɓar abu tare da sunan guda - "Yankunan kulle".
Bayan waɗannan ayyukan, za a gyara taken tebur akan takardar ta yanzu.
Cire taken
Duk hanyoyin da aka lissafa a sama, za a gyara taken teburin, domin cire shi, hanya ɗaya ce kawai. Har yanzu, danna maɓallin a kan kintinkiri na "Daskare wuraren", amma wannan lokacin zaɓi matsayin "Yankunan da ba a buɗe" da ke bayyana.
Bayan wannan, taken da aka makala zai zama mara ɓoyewa, kuma idan ka gangara ƙasa, abin ba zai zama bayyananne ba.
Saka taken yayin bugawa
Akwai wasu lokuta lokacin buga takardu na buƙatar gabatarwa kan kowane shafi. Tabbas, zaku iya "karya" teburin da hannu, kuma shigar da taken a wuraren da suka dace. Amma, wannan tsari na iya ɗaukar lokaci mai mahimmanci, kuma, a ƙari, irin wannan canjin na iya lalata amincin teburin, da kuma tsari na lissafin. Akwai hanya mafi sauƙi kuma mafi aminci don buga tebur tare da take akan kowane shafi.
Da farko dai, mun matsa zuwa shafin "La layout". Muna neman katangar tsare-tsaren "Zaɓuɓɓukan Sheet". A cikin ƙananan hagunsa na hagu alama ce a siffar kibiya mai ruɓi. Danna wannan alamar.
Mai taga yana buɗe tare da saitin shafi. Mun matsa zuwa shafin "Sheet". A filin da ke kusa da rubutun "Ku buga ta hanyar layi akan kowane shafi", kuna buƙatar tantance ayyukan daidaita layin da shafin take. A zahiri, ga mai amfani da bai shirya ba wannan ba mai sauki bane. Saboda haka, mun danna maballin da ke gefen dama na filin shigarwa.
Thewararren taga tare da zaɓuɓɓukan shafi an rage girmanta. A lokaci guda, takardar akan teburin da take akansa tayi aiki. Kawai zaɓi layin (ko layuka da yawa) wanda aka sanya kan. Kamar yadda kake gani, an shigar da daidaitawa a taga na musamman. Danna maballin da yake gefen dama na wannan taga.
Kuma, taga yana buɗe tare da saitunan shafi. Dole ne mu danna maɓallin "Ok", wanda ke cikin ƙananan kusurwar dama ta.
Dukkanin ayukkan da suka wajaba sun cika, amma da gani baza ku ga wani canje-canje ba. Don bincika ko yanzu za a buga sunan tebur akan kowane takarda, muna matsa zuwa Fayil na Fayil na Excel. Bayan haka, je sashin "Buga".
Yankin samfoti na littafin da aka buga yana kan gefen dama na taga yana buɗewa. Gungura shi ƙasa ka tabbata cewa an nuna taken da aka buga akan kowane shafin daftarin.
Kamar yadda kake gani, akwai hanyoyi guda uku da zaka iya raba jaka a cikin babban falle Microsoft. Biyu daga cikinsu suna niyyar gyara a cikin edita falle da kanta, lokacin aiki tare da takaddar. Ana amfani da hanya ta uku don nuna taken akan kowane shafi na takaddar da aka buga. Yana da mahimmanci a tuna cewa zaku iya pin taken ta hanyar pinning layi kawai idan an samo ta akan ɗayan, kuma a saman babban takarda. In ba haka ba, kuna buƙatar amfani da hanyar gyara wuraren.
