Wani lokacin lokacin aiki tare da Excel, akan kowane takarda na littafin, rubutu "Shafin 1", "Shafi na 2" da sauransu Mai amfani da ƙwarewa koyaushe yana mamakin abin da za a yi da kuma yadda za a kashe shi. A zahiri, an magance matsalar a sauƙaƙe. Bari mu gano yadda za a cire irin waɗannan rubutun daga takaddar.
Kashe nunin gani na lamba
Halin da aka nuna tare da gani na pagination don bugawa ya faru lokacin da mai amfani da gangan ko kuma ba da gangan ba ya sauya yanayin yanayin aiki na yau da kullun ko yanayin shimfiɗar kallo a cikin takaddar shafi. Dangane da haka, don kashe lambar gani, kana buƙatar canzawa zuwa wani nau'in nuni. Akwai hanyoyi guda biyu don yin wannan, wanda za'a tattauna a ƙasa.
Ya kamata a sani yanzunnan cewa baza ku iya kashe nuni na pagination ba kuma har yanzu kuna cikin yanayin shafi. Hakanan yana da mahimmanci a ambaci cewa idan mai amfani ya sanya zanen gado don bugawa, to bayanan bayanan da aka buga ba zasu ƙunshi waɗannan alamun ba, tunda an yi nufin su ne kawai don dubawa daga allon mai duba.
Hanyar 1: Matsayin Matsayi
Hanya mafi sauki don sauya hanyoyin kallo na takaddar Excel shine amfani da gumakan da suke kan sandar matsayi a ɓangaren dama na taga.
Gumakan yanayin shafi shine farkon farkon lamura sauyawa uku a dama. Don kashe nunin gani na lambobin shafi, danna kan kowane gumakan guda biyu da suka rage: "Al'ada" ko Tsarin shafin. Don yin yawancin ayyuka, ya fi dacewa a yi aiki a farkon su.
Bayan an yi sauyin, lambobin da ke jikin shafin ya kare.
Hanyar 2: Bututun Ribbon
Hakanan zaka iya kashe nuni na bayannan ta amfani da maɓallin don sauya gabatarwar gani a kan kintinkiri.
- Je zuwa shafin "Duba".
- A kan tef ɗin muna neman toshe kayan aiki Tsarin Canjin Littafin. Zai yi sauƙi a same shi, tunda yana kan gefen hagu na tef. Mun danna ɗayan maɓallin da ke cikin wannan rukunin - "Al'ada" ko Tsarin shafin.
Bayan waɗannan ayyuka, za a kashe yanayin duba shafin, wanda ke nufin cewa lambar maɓallin bango zata kuma shuɗe.
Kamar yadda kake gani, cire alamar asalin tare da pagination a cikin Excel mai sauki ne. Kawai canza ra'ayi, wanda za'a iya yi ta hanyoyi biyu. A lokaci guda, idan wani yayi ƙoƙarin neman hanyar musanya waɗannan alamun, amma a lokaci guda yana so ya kasance cikin yanayin shafi, dole ne a faɗi cewa bincikensa zai zama na banza, tunda ba irin wannan zaɓi. Amma, kafin a kashe rubutun, mai amfani yana buƙatar yin tunani game da ko da gaske yana damunsa ko wataƙila, akasin haka, yana taimakawa wajen jan hankali daftarin. Haka kuma, alamarin bangon waya ba zai taba tabbata ba a buga.
