Ta hanyar tsohuwa, Microsoft Excel ba ta fitar da lambar takarda da ake gani. A lokaci guda, a lokuta da yawa, musamman idan an aika daftarin don bugawa, suna buƙatar a ƙidaya su. Excel yana ba ku damar yin wannan ta amfani da footers. Bari mu bincika zaɓuɓɓuka daban-daban don yadda za'a ƙidaya zanen gado a cikin wannan aikace-aikacen.
Lambar Excel
Kuna iya lambar shafuka a cikin Excel ta amfani da footers. An ɓoye su ta hanyar tsohuwa, suna a cikin ƙananan da babba na takardar. Siffar su ita ce shigarwar da aka shigar a wannan yankin ƙarshen-kare ne, wato, an nuna su a duk shafukan daftarin.
Hanyar 1: lamba ta al'ada
Lambar da aka saba samu shine adana duk zanen takardan.
- Da farko dai, kuna buƙatar kunna allon nuni da ƙafa. Je zuwa shafin Saka bayanai.
- A kan kintinkiri a cikin akwatin kayan aiki "Rubutu" danna maballin "Shugabannin kai da mahaukata".
- Bayan haka, Excel yana shiga cikin yanayin layout, kuma shafin yana nuna taken da adersan wasa. Suna cikin manyan yankuna da ƙananan yankuna. Bugu da kari, kowannensu ya kasu kashi uku. Mun zabi a wane bangare ne, kuma a wane bangare ne, za'a yi lambar. A mafi yawan halaye, zabi gefen hagu na kan. Danna gefen inda kuka shirya sanya lambar.
- A cikin shafin "Mai zane" toshe ƙarin shafuka "Aiki tare da buga kwallo da kai da kuma footers" danna maballin "Lambar shafi", wanda ke kan kintinkiri a cikin rukunin kayan aiki "Abubuwa masu ɓoye".
- Kamar yadda kake gani, alama ta musamman ta bayyana "& [Shafi]". Don canza shi zuwa takamaiman lambar serial, danna kowane yanki na daftarin.
- Yanzu, a kowane shafi na takaddar Excel, lambar siriya ta bayyana. Don sa ya zama mafi gabatarwa kuma ya tsaya a kan janar gabaɗaya, ana iya tsara shi. Don yin wannan, zaɓi shigar a cikin ƙwallon ƙafa kuma yi rawa a kanta. Tsarin menu yana bayyana wanda zaku iya aiwatar da waɗannan ayyukan:
- canza nau'in font;
- sanya shi italic ko m;
- sake girmanwa;
- canza launi.
Zaɓi ayyukan da kake son aiwatarwa don canza nuni na lamba har sai an sami sakamako mai gamsarwa.
Hanyar 2: lamba don nuna jimlar adadin zanen gado
Bugu da kari, zaku iya lambar shafuka a cikin Excel tare da adadinsu akan kowane takarda.
- Mun kunna nuni na lamba, kamar yadda aka nuna a cikin hanyar da ta gabata.
- Kafin alamar, rubuta kalmar "Shafin", kuma bayan shi muna rubuta kalmar daga.
- Saita siginan kwamfuta a cikin filin labarin bayan kalmar daga. Latsa maballin "Yawan Shafuka", wanda aka sanya akan kintinkiri a cikin shafin "Gida".
- Danna ko'ina cikin daftarin don nuna ƙimar maimakon alamun.
Yanzu muna nuna bayanai ba wai kawai game da takaddar yanzu ba, har ma game da adadinsu.
Hanyar 3: lamba ta shafi na biyu
Akwai lokutan da kuke buƙatar lamba duk takaddar, amma fara daga wani takamaiman wuri. Bari mu tsara yadda za ayi.
Don saita lambobi daga shafi na biyu, kuma wannan ya dace, alal misali, lokacin rubuta takarda, difloma da ayyukan kimiyya, lokacin da ba a ba da izinin lambobi a shafin taken ba, matakan suna ƙasa.
- Je zuwa yanayin mahaifa. Na gaba, matsa zuwa shafin "Maƙerin Zane"wanda yake a cikin toshe shafin "Aiki tare da buga kawunan kai da footers".
- A cikin akwatin kayan aiki "Zaɓuɓɓuka" akan tef, saitin abun saiti "Specialwallan musamman na shafin farko".
- Saita yin lamba ta amfani da maballin "Lambar shafi", kamar yadda aka nuna a sama, amma aikata shi akan kowane shafi sai farkon.
Kamar yadda kake gani, bayan wannan an ƙidaya dukkan zanen gado, sai na farkon. Haka kuma, ana yin la’akari da shafin farko yayin aiwatar da lamba sauran zanen gado, amma, duk da haka, lambar ba ta nuna kanta ba.
Hanyar 4: lamba daga shafin da aka ƙayyade
A lokaci guda, akwai yanayi lokacin da yake buƙatar takarda don farawa ba daga shafin farko ba, amma, alal misali, daga na uku ko na bakwai. Irin wannan buƙatar ba sau da yawa ba, amma, koyaya, a wasu lokuta tambayar da aka gabatar ma tana buƙatar bayani.
- Muna aiwatar da lambobi a hanyar da ta saba, ta amfani da maɓallin dacewa akan kintinkiri, cikakken bayanin abin da aka bayar a sama.
- Je zuwa shafin Tsarin shafin.
- A kan kintinkiri a cikin ƙananan hagu na kushin kayan aiki Saitunan Shafi akwai gumaka a siffar kibiya kibiya. Danna shi.
- Zaɓuɓɓukan window yana buɗewa, je zuwa shafin "Shafin"idan aka bude shi a wani shafin. Mun sanya a cikin sigogi Lambar Shafin Farko lambar da za a ƙidaya. Latsa maballin "Ok".
Kamar yadda kake gani, bayan wannan adadin shafin farko a cikin takaddar ya canza zuwa ainihin da aka ƙayyade a cikin sigogi. Saboda haka lambobin da ke gaba masu zuwa suma sun canza.
Darasi: Yadda za a cire footers a cikin Excel
Lissafin shafuka a cikin babbar hanyar aikin na'urar mai amfani da na'urar kwamfuta tana da sauki kwarai da gaske. Ana yin wannan hanyar lokacin da yanayin ƙafa yake kunne. Bugu da kari, mai amfani na iya tsara lambobi wa kansu: tsara lambar nuni, kara nuni ga jimlar adadin zanen takardan, lamba daga wani takamaiman wuri, da sauransu.
