Lokacin aiki tare da mahimman adadin bayanai akan takarda a cikin Microsoft Excel, dole ne ka bincika wasu sigogi akai-akai. Amma, idan akwai da yawa daga cikinsu, kuma yankin su ya wuce iyakar allon, kullun motsi sakin layi yana da matukar wahala. Developerswararrun masu haɓakawa sun lura da saukaka wa masu amfani ta hanyar gabatar da yuwuwar gyara wuraren a cikin wannan shirin. Bari mu gano yadda za a raba yanki zuwa wata takardar a Microsoft Excel.
Daskare yankuna
Za mu kalli yadda ake gyara wurare a kan takardar ta amfani da misalin Microsoft Excel 2010. Amma, ba tare da ƙaramar nasara ba, ana iya amfani da algorithm ɗin da aka bayyana a cikin Excel 2007, 2013, da 2016.
Don fara gyara yankin, kuna buƙatar zuwa shafin "Duba" shafin. Bayan haka, zaɓi tantanin, wanda ke belowasan da ke andasan dama da yankin da aka ƙaddara. Wato, duk yankin da zai kasance a sama da hagu na wannan tantanin za a gyara shi.
Bayan haka, danna maɓallin "Yancin yankunan", wanda ke kan kintinkiri a cikin rukunin kayan aiki na "Window". A cikin jerin zaɓi wanda ya bayyana, zaɓi zaɓi "Maɓallai makullin".
Bayan haka, yankin da ke sama da hagu na tantanin da aka zaɓa za'a gyara shi.
Idan ka zabi sashin farko na hagu, to duk sel din da suke sama za'a gyara shi.
Wannan ya dace musamman a lokuta inda kan teburin tebur ya ƙunshi layuka da yawa, tunda dabara tare da gyara saman layi ba zartar ba.
Hakanan, idan kayi amfani da fil, zabi saman sel, to dukkan yankin zuwa hagu na shi za'a gyara.
Docking yankunan
Don cire wuraren gyarawa, baku buƙatar zaɓar sel. Ya isa ya danna maballin “Gyara wuraren” da yake kan kintinkiri, sannan ka zabi abun “Yankunan da ke ciki”.
Bayan haka, duk madaidaitan jeri dake jikin wannan takarda za a yanke su.
Kamar yadda kake gani, hanya don gyarawa da tsare wurare a Microsoft Excel abu ne mai sauki, kuma zaka iya cewa yana da dabara. Abu mafi wahala shine a sami shafin shirin da ya dace, inda kayan aikin warware waɗannan matsalolin suke. Amma, mun yi bayani dalla-dalla game da yadda ake sarrafa da kuma gyara wuraren a cikin wannan edita. Wannan fasalin ne mai amfani, tunda kuna amfani da ayyukan gyara wuraren, zaku iya ƙara amfani da Microsoft Excel, kuma ku adana lokacinku.
