Gudurawa a cikin Excel yana nufin motsawa sama-da-ƙasa ko gefen zuwa gefe ta hanyar takardar aiki ta amfani da sandan gungura, maɓallin kiban a kan keyboard, ko kuma tafin motsi a kan linzamin kwamfuta.
Ta hanyar tsoho, Excel yana nuna alamar gungura a kwance da gefen dama na allo kamar yadda aka nuna a hoton da ke sama.
Hiding / Viewing Gungura Bars
Lura : Idan kana ɓoye gungumen gungumen kwalliya don ƙara yawan wurin dubawa na takardar aiki, za a buƙatar ka sake duba akwatin shafukan Shafin Show da kuma gungumen gungura mai kwance. Wannan zai cire maɓallin tushe na fitilar Excel.
Don ɓoye sandunan gungura a kwance da / ko a tsaye a cikin sassan Excel (tun daga Excel 2010):
- Danna kan Fayil din shafin don buɗe menu na Fayil;
- Danna maballin Zaɓuɓɓuka a cikin menu domin buɗe akwatin maganganu na Excel Options ;
- A cikin akwatin maganganu, danna Babba a cikin aikin hagu na hagu don buɗe Madaidaicin Zaɓuɓɓuka a kan haɓakar dama;
- A cikin zaɓuɓɓukan ci gaba, gungurawa zuwa Zaɓuɓɓukan Nuni don wannan sashin jarida - game da rabi ƙasa;
- Binciken (nuna) ko rufe (boye) Gungura Gungura mai nunawa da / ko Nuna Gangashin Gungura kan zaɓuɓɓuka kamar yadda ake bukata.
- Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
Sanya Gidan Gungura Mai Gyara
Idan yawan zanen gado a cikin takarda ya kara zuwa maƙasudin cewa ba a iya karanta sunayen dukkanin zane a lokaci daya ba, hanya daya da za a gyara wannan ita ce ta raguwa girman girman gungura mai kwance.
Don yin wannan:
- Sanya maƙalin linzamin kwamfuta a kan rassan ellipsis (tsaye uku) a gefen gefen gungura mai kwance;
- Mainter pointer zai canza zuwa arrow - wanda aka nuna a cikin hoto a sama idan an daidaita shi daidai;
- Latsa ka riƙe ƙasa maballin hagu na hagu kuma ja da maɓallin zuwa dama don ƙyale maɓallin gungura mai kwance ko a gefen hagu don fadada barikin gungura.
Daidaita Gudun Maɓallin Gilashin Gumun Gudun Gudun Vertical Scroll Bar
Abun da ke cikin gungumen maɓallin gungura-akwatin da yake motsa sama da ƙasa da gungun-gungura-canje-canje a girman kamar yawan layuka a cikin wani aikin aiki wanda ya ƙunshi canjin bayanai.
Kamar yadda adadin layuka ya ƙaru, girman girman siginan ya rage.
Idan kana da wata takardar aiki tare da ƙananan ƙananan layuka da ke dauke da bayanai, amma mai zanen yaron yana da ƙananan kuma yana motsawa har ma da adadi kadan ya sa aikin aiki ya tsalle ko saukar da daruruwan idan ba dubban layuka, yana iya haifar da jere ko ma tantanin tantanin salula guda ɗaya da ke ƙasa da aikin aikin da aka kunna a wata hanya.
Daidaita matsalar ita ce ganowa da kuma share layin da ke kunshe da cell din da aka kunna.
Kwayoyin da aka kunna ba dole ba sun ƙunshi bayanai-canza canje-canjen tantanin halitta, ƙara iyakoki, ko ko da amfani da ƙwaƙwalwa ko yin amfani da layi zuwa ƙamshi marar amfani ya isa ya kunna tantanin halitta-kuma wannan na iya sa ganowa da kuma cire jigon da ke dauke da tantanin halitta .
Gano Layin Layi na Ƙarshe
Mataki na farko shine yin kwafin ajiya na ɗawainiyar. Matakai na gaba sun kunshi sharewa layuka a cikin takardun aiki, kuma idan layuka da ke dauke da bayanai masu kyau an cire su ba tare da haɗari ba, hanyar da ta fi dacewa don dawo da su shine a sami kwafin ajiya.
Don samo jere na ƙarshe a cikin takardun aiki wanda ke dauke da tantanin halitta da aka kunna:
- Danna maballin Ctrl + Home a kan keyboard don matsawa zuwa cell A1 a cikin takarda.
- Latsa maballin Ctrl + End a kan keyboard don matsawa zuwa na karshe cell a cikin takardun aiki. Wannan tantanin halitta zai kasance tsakanin tsaka tsakanin layin da aka kunna mafi ƙasƙanci da kuma shafin da aka kunna dama.
Share Aiki na Farko na Ƙarshe
Tun da ba za ku iya tabbatar da cewa ba a kunna wasu layuka tsakanin jerin jere na karshe da bayanai masu kyau ba, hanyar da ta fi dacewa ita ce share duk layuka a ƙasa da bayanan ku da kuma jere na ƙarshe.
Tabbatar zaɓin duk layuka don sharewa ta danna kan maɓallin jeri tare da linzamin kwamfuta ko ta latsa maɓallin Shift + Space a kan keyboard.
Da zarar an zaɓi layuka,
- Dama dama a kan jere na jere na ɗaya daga cikin layuka da aka zaɓa don buɗe menu mahallin;
- Danna kan Share , a cikin menu don share layuka da aka zaɓa.
Duba Kafin Ka Share
Kafin kawar da kowane layuka, tabbatar da cewa abin da ka yi imani da zama layin karshe na muhimman bayanai shine, a gaskiya, jere na karshe na muhimman bayanai, musamman ma idan mutum ya yi amfani da aikin ɗawainiya.
Ba abu ne wanda ba a sani ba don ɓoye bayanai daga wurin aikin yanzu, don haka yana da shawarar yin bincike sosai sannan kafin a fara tare da sharewa.
Ajiye Ɗayan littafin
Bayan share duk waɗannan layuka, mataki na karshe shine don ajiye littafin aiki. Har sai an ajiye littafin, ba za a canza canji da halayyar mai zanewa a cikin gungura ba.