Duba tsayayyen wuraren
Wasu masu amfani ba quite fahimci yadda za a gane gyarawa a cikin yankunan Excel kuma iya dame wasu saituna da wannan aiki, kokarin kashe ta. Akwai sauki hanya domin kayyade aiki na bunqasar - scrolling takardar.
A lazimta yankunan zama a wuri a lokacin da wasu Kwayoyin suna scrolled. A cikin hali na farko saman line, pinning za a iya ƙaddara tare da m line, daban-daban daga al'ada cell iyakoki.
Idan ya aikata ba taimako, kawai fara scrolling saukar da page saukar da amfani da dabaran da za ka gani, shin na farko line saura a wurin.
Aƙalla guda ya shafi na farko shafi, amma wannan lokacin shi zai yi don gungurawa ta hanyar da page, da kuma shi za a mafi wuya ga gane rabuwa line.
Lokacin da ka gane ko da farko m cewa tsayayyen wuraren ne ba a tebur, ci gaba da kau kamar yadda aka nuna a kasa.
Cire bunqasar na yankunan a Excel
Akwai daya ne kawai samuwa hanyar cire yankin fastening zuwa extell, wanda ta atomatik ya shafi dukan gyarawa Lines da kuma ginshikan, don haka la'akari da shi lokacin da ka mirgine baya da saituna, in ba haka ba za ka yi da hannu haifar da waɗanda kullawa, wanda ba ka so.
- Bude View shafin, inda dole kayan aiki da ake located.
- Expand da "Secure Area" drop-saukar menu.
- Click a kan "Cire sihiri Region" button, amma karanta bayanin wannan aiki a gaba.
- Koma zuwa tebur da kuma amfani da scrolling zuwa sake tabbatar da nasara kau kau.
Idan ka ba zato ba tsammani bukatar ƙarfafa wasu yankunan, misali, a lokacin da aka yi ba daidai ba a karon farko, mun ba da shawara ku don Masana wani wa'azi a kan shafin yanar, inda marubucin ya bayyana duk zaɓuɓɓuka saboda yin wannan aiki.
Read more: fastening yankin a Microsoft Excel