Lissafin lamba kayan aiki ne wanda yake yafi sauƙin shirya takarda lokacin bugawa. Lallai, zanen gado mai lamba sun fi sauƙin shirya a tsari. Kuma idan sun haɗasu ba zato ba tsammani a gaba, koyaushe zaka iya ƙara su da sauri bisa ga adadinsu. Amma wani lokaci kuna buƙatar cire wannan lambar bayan an shigar dashi a cikin takaddar. Bari mu ga yadda za a yi wannan.
Duba kuma: Yadda zaka cire lamba shafi a Magana
Zaɓuɓɓukan cirewa na lamba
Algorithm na hanya don cire lamba a cikin Excel, da farko, ya dogara da yadda kuma dalilin da yasa aka shigar dashi. Akwai manyan kungiyoyin lambobi biyu. Na farkon su bayyane lokacin da aka buga takarda, kuma na biyu za'a iya lura dashi yayin aiki tare da falle akan mai saka idanu. A dangane da wannan, lambobin suna tsabtace ta hanyoyi daban-daban. Bari muyi cikakken bayani akan su.
Hanyar 1: cire lambobin shafi na baya
Bari mu zauna kan hanya don cire lambar shafi na baya, wanda za'a iya gani kawai akan allon mai duba. Wannan lambobi ne na nau'in "Page 1", "Shafi 2", da sauransu, wanda aka nuna kai tsaye akan takardar a kan yanayin kallon shafin. Hanya mafi sauki daga wannan halin shine kawai canzawa zuwa kowane yanayin kallo. Akwai hanyoyi guda biyu don cim ma wannan.
- Hanya mafi sauki don canzawa zuwa wani yanayin shine danna kan gunki a kan matsayin matsayin. Wannan hanya koyaushe tana samuwa, kuma a zahiri tare da dannawa ɗaya, komai girman abin da shafin yake. Don yin wannan, sauƙaƙe hagu-danna kan kowane ɗayan gumakan sauyawa sau biyu, sai fa gum "Shafin". Wadannan juyawa suna a cikin masalin hali zuwa hagu na maɓallin zuƙowa.
- Bayan haka, rubutun da lambobi ba za su kasance a bayyane su akan allon bayanan ba.
Hakanan akwai zaɓi na sauya hanyoyin yin amfani da kayan aiki akan tef.
- Matsa zuwa shafin "Duba".
- A kan kintinkiri a cikin toshe saitunan Duba littafi danna maballin "Al'ada" ko Tsarin shafin.
Bayan haka, za a kashe yanayin shafin, wanda ke nufin cewa lambar baya zai shuɗe.
Darasi: Yadda za'a cire rubutun Shafi 1 a Excel
Hanyar 2: share taken da footers
Akwai wani yanayi na juyawa lokacin da, lokacin aiki tare da tebur a Excel, ba a ganin lambobi, amma yana bayyana lokacin da aka buga takarda. Hakanan, ana iya gani a cikin taga samfurin daftarin aiki. Don tafiya can, kuna buƙatar zuwa shafin Fayilolisannan zaɓi abu cikin menu na tsaye na hagu "Buga". A hannun dama na taga wanda zai buɗe, za a sami yankin samfoti na takardar. A nan ne zaka iya gani cewa shafin da za'a buga za'a ƙidaya shi ko a'a. Lambobi na iya zama a saman takardar, a ƙasa ko a cikin duka matsayi biyu lokaci guda.
Ana yin irin wannan lambar ta amfani da footers. Waɗannan waɗancan filayen ɓoye ne wanda za'a iya ganin bayanai a buga. Ana amfani dasu kawai don lambobi, shigar da bayanan daban-daban, da sauransu. A lokaci guda, don lambar shafin, baka buƙatar shigar da lamba akan kowane abu na shafi. Ya isa a shafi ɗaya, yayin da kake cikin yanayin ƙafa, a rubuta magana a cikin ɗaya daga cikin manyan filaye uku ko ƙananan:
& [Shafi]
Bayan haka, za a ci gaba da yin lambobin duk shafuka. Don haka, don cire wannan lambar, kawai kuna buƙatar share filin foowallo daga abubuwan da ke ciki, da adana takaddar.
- Da farko, don kammala aikinmu muna buƙatar canzawa zuwa yanayin footer. Ana iya yin wannan tare da 'yan zaɓuɓɓuka. Matsa zuwa shafin Saka bayanai kuma danna maballin "Shugabannin kai da footers"wacce take akan kintinkiri a cikin akwatin kayan aiki "Rubutu".
Bugu da kari, zaku iya ganin buga labarai da footers ta hanyar sauya sheka zuwa yanayin shimfida shafin ta hanyar gunkin da muka riga muka san shi a matsayin matsayin. Don yin wannan, danna kan gunkin tsakiyar don sauya hanyoyin gani, wanda ake kira Tsarin shafin.
Wani zaɓi shine don zuwa shafin "Duba". Danna maballin a ciki. Tsarin shafin a kan kintinkiri a cikin kayan aikin Tsarin Canjin Littafin.
- Ko wane zaɓi da kuka zaɓi, zaku ga abinda ke ciki da adersan wasan. A cikin lamarinmu, lambar shafin yana cikin manyan hagu da ƙananan hagu na ƙasa.
- Kawai saita siginan kwamfuta a cikin filin da ya dace kuma danna maballin Share a kan keyboard.
- Kamar yadda kake gani, bayan wannan, lambobin sun ɓace ba kawai a saman kusurwar hagu na shafin da aka goge murfin ba, har ma a duk sauran abubuwan takaddar a wuri guda. Haka kuma, muna share abinda ke cikin murfin. Sanya siginan kwamfuta a can kuma danna maɓallin Share.
- Yanzu da duk bayanan da ke cikin ƙafafun an share su, za mu iya canzawa zuwa yanayin aiki na yau da kullun. Don yin wannan, ko dai a cikin shafin "Duba" danna maballin "Al'ada", ko cikin sandar matsayin, danna maballin da daidai sunan shi.
- Kar ka manta ka goge takardan. Don yin wannan, kawai danna kan gunkin, wanda yayi kama da faifan faifan diski kuma yana a saman kusurwar hagu na taga.
- Don tabbatar da cewa lambobin sun mutu da gaske kuma baza su bayyana akan buga ba, muna matsawa shafin Fayiloli.
- A cikin taga da ke buɗe, matsa zuwa ɓangaren "Buga" ta menu a tsaye. Kamar yadda kake gani, a cikin wurin sambatun da kuka riga kuka saba, lamba mai lamba a cikin takardu ya ɓace. Wannan yana nufin cewa idan muka fara buga littafin, to fitowar zata zama zanen gado ba tare da lambobi ba, wanda shine abin da mukeyi.
Bugu da kari, zaku iya kashe footers gaba daya.
- Je zuwa shafin Fayiloli. Mun matsa zuwa sashin "Buga". Saitin bugu suna a tsakiyar ɓangaren taga. A kasan wannan katangar, danna kan rubutun Saitunan Shafi.
- Zaɓuɓɓukan shafin taga. A cikin filayen Shugaban da Mai ba da labari daga jerin zaɓuka, zaɓi zaɓi "(babu)". Bayan haka, danna maɓallin "Ok" a kasan taga.
- Kamar yadda kake gani a wurin samfoti, lambar sanya lambar ta bace.
Darasi: Yadda za a cire footers a Excel
Kamar yadda kake gani, zabar hanyar kashe lambar shafi yana dogara ne akan yadda aka tsara wannan lambar. Idan an nuna shi kawai akan allon saka idanu, to kawai canza yanayin kallo. Idan an buga lambobi, to a wannan yanayin, kuna buƙatar share abubuwan da ke cikin ƙafa.
